using a query() with RowMapper.

[Ritesh raushan]

i am using a "query() with RowMapper" and my code compiles but when i execute following output given in the place of data.



Oct 27, 2012 10:56:00 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader lo
adBeanDefinitions
INFO: Loading XML bean definitions from class path resource [spring.xml]
Oct 27, 2012 10:56:01 PM org.springframework.jdbc.datasource.DriverManagerDataSource setD
riverClassName
INFO: Loaded JDBC driver: oracle.jdbc.OracleDriver
Oct 27, 2012 10:56:01 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader lo
adBeanDefinitions
INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/sup
port/sql-error-codes.xml]
Oct 27, 2012 10:56:01 PM org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, Postg
reSQL, Sybase]

[Kr. Pallav]

Are your other operation with database working ? Can you post codes for connection ?

[Ritesh raushan]

Kr. Pallav wrote:Are your other operation with database working ? Can you post codes for connection ?

please help.

//spring.xml

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN2.0//EN"
"http://www.springframework.org/dtd/spring-beans-2.0.dtd">

<beans>
<bean id="id1" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >

<property name="driverClassName" value="oracle.jdbc.OracleDriver" ></property>
<property name="url" value="jdbc : oracle:thin:@localhost:1521 : orcl"></property>
<property name="username" value="scott"></property>
<property name="password" value="tiger"></property>
</bean>

<bean id="id2" class="org.springframework.jdbc.core.JdbcTemplate" >
<property name="dataSource" ref="id1"/>
</bean>
<bean id="id3" class="Mybean">
<property name="jt" ref="id2"/>
</bean>
</beans>

//this is my pojo class where i store and retrieve the data
 class Employee
{
	private int empId;
	private String ename;
	private int sal;
	public void setEmpid(int empId)
	{
		this.empId=empId;
	}
	public int getEmpid()
	{
		return empId;
	}
	public void setEname(String ename)
	{
		this.ename=ename;
	}
	public String getEname()
	{
		return ename;
	}
	public void setSal(int sal)
	{
		this.sal=sal;
	}
	public int getSal()
	{
		return sal;
	}
};

//this class implements RowMapper and there is method mapRow() called by container on each row
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.*;
public class EmployeeMapper implements RowMapper
{
     public Object mapRow(ResultSet rs,int index)throws SQLException
	{
          Employee e=new Employee();
		  e.setEmpid(rs.getInt(1));
		  e.setEname(rs.getString(2));
		  e.setSal(rs.getInt(3));
		  return e;
	}
};

//this is main class where i call Query() and generates output
import org.springframework.jdbc.core.*;
import java.util.*;
 class Mybean
{
	private JdbcTemplate jt;
	public void setJt(JdbcTemplate jt)
	{
		this.jt=jt;
	}
	public void getData()
	{try{
		List l=jt.query("select * from emp",new EmployeeMapper());
		Iterator i=l.iterator();
		while(i.hasNext())
		{
			Employee e=(Employee)i.next();
			System.out.println(e.getEmpid()+" "+e.getEname()+" "+e.getSal());}}
			catch(Exception e){}
		
	}
};

[Saifuddin Merchant]

You code looks ok at first glance. Can you post the error you are getting. Since spring is loading the error xml it indicates that it would some error in executing the SQL. Normally the next few lines tell what that error is ...