Archive for the ‘Learning Center’ category

Newer Entries »

How to redirect a page to a subdomain ?

August 9th, 2008

In case you want to redirect a URL on URL domain to your subdomain or another URL , There are many ways you can do it

Technique 1

  • Open the file .htAccess file present in /public_html/yourDomain folder using an ftp client .
  • Add an entry in it as follows :Redirect 301 /oldPath http://www.subdomain.yourdomain.com/
  • To move the entire site : Use this Redirect 301 / http://www.example.com/
  • Save the file , And upload it again . Make sure that you upload it in ASCII mode.

» Read more: How to redirect a page to a subdomain ?

No comments »

Posted in Web

Tags:

IBatis vs Hibernate ? Which one to choose?

August 9th, 2008

A lot of people ask me when i give sessions on IBatis.Which is better ?IBatis or Hibernate? IBatis maps the Java Objects to the SQL Query’s results. Hibernate, maps Java Objects to DB tables (Object-Relational Mapping). Hibernate automatically generates all the SQL for you. In IBatis you can directly write queried in SQL, thus if you are a good SQL programmer, you would find learning Ibatis very easy. Thus Ibatis allows you to do anything what could be done through SQL. Thus you can virtually know what the affect of a query would be.

8 comments »

Posted in iBatis

IBatis Tutorial – Sample Application Step 1

August 8th, 2008

Steps :

1) Creata a databas and a table

2) Create a package com.Employee

3) SQL mapper – Employee.xml
» Read more: IBatis Tutorial – Sample Application Step 1

2 comments »

Posted in iBatis

Ibatis Tutorial – Sample Application Step 2

August 8th, 2008

Step 2: Create a package and a java object .


package com.Employee
import java.io.Serializable;
public class Employee implements Serializable {
private int employeeID;
» Read more: Ibatis Tutorial – Sample Application Step 2

1 comment »

Posted in iBatis

Ibatis Tutorial – Sample Application Step 3

August 8th, 2008

Step 3: Create struts-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC “-//ibatis.apache.org//DTD SQL Map Config 2.0//EN”
“http://ibatis.apache.org/dtd/sql-map-config-2.dtd”>
<sqlMapConfig>
<transactionManager type=”JDBC”>
<dataSource type=”SIMPLE”>
<property name=”JDBC.Driver” value=”com.mysql.jdbc.Driver”/>
<property name=”JDBC.ConnectionURL”
value=”jdbc:mysql://localhost:3306/employeedb”/>
<property name=”JDBC.Username” value=”root”/>
<property name=”JDBC.Password” value=”"/>
</dataSource>
</transactionManager>
<sqlMap resource=”com/Employee.xml”/>
</sqlMapConfig>

Also Read : IBatis vs Hibernate ? Which one to choose?
IBatis Tutorial – Sample Application Step 4
Introduction to IBatis Tutorial -Part 1

2 comments »

Posted in iBatis

Tags:

IBatis Tutorial – Sample Application Step 4

August 8th, 2008

Create Employee.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC “-//ibatis.apache.org//DTD
SQL Map 2.0//EN”
“http://ibatis.apache.org/dtd/sql-map-2.dtd”>
<sqlMap>
<select id=“getEmployee” parameterClass=“int”
resultClass=“com.Contact”>
SELECT employeeID as employeeID,
firstName as firstName,
lastName as lastName,
email as email
from Employee
where employeeID=#value#
</select>
<select id=“getEmployees” resultClass=“com.Employee”>
SELECT employeeID as employeeID,
firstName as firstName,
lastName as lastName,
email as email
from Employee
</select>
</sqlMap>


Technorati :

Also Read : IBatis vs Hibernate ? Which one to choose?
IBatis Tutorial – Sample Application Step 5
Introduction to IBatis Tutorial -Part 1

3 comments »

Posted in iBatis

Tags:

Ibatis Tutorial – Sample Application Step 5

August 8th, 2008

Step 5 : Create a standalone java class to run the application .

import java.io.Reader;
import java.util.List;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.model.Employee;

public class QueryEmployee {

public static void main(String[] args) {
try {
String resource = “SqlMapConfig.xml”;

Reader reader = Resources.getResourceAsReader(resource);
SqlMapClient sqlMap =
SqlMapClientBuilder.buildSqlMapClient(reader);
Integer employeePrimaryKey = new Integer(1);
Employee employee =
(Employee)sqlMap.queryForObject(“getEmployee”,
employeePrimaryKey);
System.out.println(employee.getFirstName()
+ “\t” + employee.getLastName());
}catch(Exception e) {
e.printStackTrace();
}
}
}


Technorati :

Also Read : IBatis vs Hibernate ? Which one to choose?
IBatis Tutorial – Sample Application Step 1

1 comment »

Posted in iBatis

Tags:

IBatis Tutorial Part 3 – SQLMapConfig.xml optional settings

August 8th, 2008

Here are some of the options setting which are worth mentioning.

<settings

maxRequests ="120"

maxSessions ="20"

maxTransactions="10"

lazyLoadingEnabled =" true"

enhancementEnabled ="true"

cacheModelsEnabled ="true"

useStatementNamespaces ="false"

defaultStatementTimeout ="5" />

<typaAlias alias = ""employee> type ="com.Emloyee" />

Settings attributes : » Read more: IBatis Tutorial Part 3 – SQLMapConfig.xml optional settings

9 comments »

Posted in iBatis

Tags:

Introduction to IBatis Tutorial -Part 1

August 8th, 2008

This is a tutorial on IBatis . IBatis is a persistence framework which enables mapping SQL queries to POJOs (Plain Old Java Objects). The SQL queries are decoupled from an application by putting the queries in XML files. Mapping of the retrieved objects is automatic or semi-automatic.

IBatis couples objects with stored procedures or SQL statements using a XML descriptor.iBatis provides a set of APIs which can be used to call these statements written in an XML file. Also since IBatis gives you the power to write any SQL query in the XML file, there is nothing that IBatis cannot achieve, thus making it a very good persistence framework.IBatis is simple to learn and anyone who can write SQL queries can very well work on this. » Read more: Introduction to IBatis Tutorial -Part 1

5 comments »

Posted in iBatis

Tags: