SqlMap problem in Spring-ibatis integration app

[Deepaks Deshpande]

Hi ranchers,

I am using spring 2x and ibatis in my project. I am getting the following error while reading the ibatis sql map file. Please help me out i am stuck here

my ibatis qsl map file is:

<?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 namespace="profile">
	<!-- Type alias configurations -->
	<typeAlias alias="users" type="com.spring.mvc.domain.Users" />
	<typeAlias alias="rank" type="com.spring.mvc.domain.Rank" />
	<typeAlias alias="branch" type="com.spring.mvc.domain.Branch" />
	<typeAlias alias="unit" type="com.spring.mvc.domain.Unit" />
	<typeAlias alias="designation" type="com.spring.mvc.domain.Designation" />
	<typeAlias alias="usersection" type="com.spring.mvc.domain.Usersection" />
	
	<!-- Cache model configurations -->
	<cacheModel id="profileCache" type="LRU" readOnly="true">
		<property name="size" value="1000" />
		<flushInterval hours="24" />
	</cacheModel>
	
	<!-- Result map configurations -->
	<resultMap  id="rankMap" class="rank">
 		<result property="rankId" column="rankid" javaType="java.lang.Integer" />
 		<result property="rankName" column="rankname" javaType="java.lang.String" />
 	</resultMap>
 	
 	<resultMap id="branchMap" class="branch">
 		<result property="branchId" column="branchid" javaType="java.lang.Integer" />
 		<result property="branchName" column="branchname" javaType="java.lang.String" />
 	</resultMap>
 	
 	<resultMap id="unitMap" class="unit">
 		<result property="unitId" column="unitid" javaType="java.lang.Integer" />
 		<result property="unitName" column="unitName" javaType="java.lang.String" />
 	</resultMap>
 	
 	<resultMap id="designationMap" class="designation">
 		<result property="designationId" column="designationid" javaType="java.lang.Integer" />
 		<result property="designationName" column="designationname" javaType="java.lang.String" />
 	</resultMap>
	
	<resultMap id="userSectionMap" class="usersection">
		<result property="userSectionId" column="usersectionid" javaType="java.lang.Integer" />
		<result property="userSectionName" column="usersectionname" javaType="java.lang.String" />
	</resultMap>
	<resultMap  id="profileResultMap" class="users">
 		<result property="serviceNo" column="serviceno" javaType="java.lang.String" />
 		<result property="userId" column="userid" javaType="java.lang.String" />
 		<result property="password" column="password" javaType="java.lang.String" />
 		<result property="email" column="emailid" javaType="java.lang.String" />
 		<result property="typeOfUser" column="typeofuser" javaType="java.lang.String" />
 		<result property="dateOfCreation" column="dateofcreation" javaType="java.util.Date" />
 		<result property="rank" resultMap="profile.rankMap" />
 		<result property="branch" resultMap="profile.branchMap" />
 		<result property="userSection" resultMap="profile.userSectionMap" />
 		<result property="unit" resultMap="profile.unitMap" />
 		<result property="designation" resultMap="profile.designationMap" />
 	</resultMap>
 	

 	
 	<parameterMap id="profileParameterMap" class="users">
 		<parameter property="serviceNo" javaType="java.lang.String" jdbcType="VARCHAR" />
 		<parameter property="userId" javaType="java.lang.String" jdbcType="VARCHAR" />
 		<parameter property="password" javaType="java.lang.String" jdbcType="VARCHAR" />
 		<parameter property="email" javaType="java.lang.String" jdbcType="VARCHAR" />
 		<parameter property="tpeOfUser" javaType="java.lang.String" jdbcType="VARCHAR" />
 		<parameter property="dateOfCreation" javaType="java.sql.Timestamp" jdbcType="TIMESTAMP" />
 		<parameter property="rank" javaType="java.lang.Integer" jdbcType="INTEGER" />
 		<parameter property="branch" javaType="java.lang.Integer" jdbcType="INTEGER" />
 		<parameter property="userSection" javaType="java.lang.Integer" jdbcType="INTEGER" />
 		<parameter property="unit" javaType="java.lang.Integer" jdbcType="INTEGER" />
 		<parameter property="designation" javaType="java.lang.Integer" jdbcType="INTEGER" />
 		<parameter property="baseStation" javaType="java.lang.Integer" jdbcType="INTEGER" />
 	</parameterMap>
 	
 	<select id="showProfile" cacheModel="profileCache"
	parameterClass="java.lang.String" resultMap="profileResultMap">
	SELECT 
  	users.serviceno, 
  	users.userid, 
  	users."password", 
  	users."name", 
  	users.emailid, 
  	users.typeofuser, 
  	users.dateofcreation, 
  	rank.rankname, 
  	branch.branchname, 
  	unit.unitname, 
  	designation.designationname, 
  	usersection.usersectionname
	FROM 
  		coderanch.users LEFT JOIN coderanch.usersection
	ON
		(users.usersection = usersection.usersectionid) LEFT JOIN coderanch.rank 
	ON
		(users.rank = rank.rankid) LEFT JOIN coderanch.branch 
	ON 
		(users.branch=branch.branchid) LEFT JOIN coderanch.unit 
	ON
		(users.unit=unit.unitid) LEFT JOIN coderanch.designation 
	ON 
		(users.designation=designation.designationid) WHERE users.userid = #userId#
	</select>
</sqlMap>

Th error generated on the console is:

2012-02-23 15:50:04,442 DEBUG [http-8080-1] - DispatcherServlet with name 'SpringMvcProject' determining Last-Modified value for [/SpringMvcProject/myprofile.htm]
2012-02-23 15:50:04,445 DEBUG [http-8080-1] - Mapping [/myprofile.htm] to handler 'com.spring.mvc.controller.MyProfileController@f1b25e'
2012-02-23 15:50:04,445 DEBUG [http-8080-1] - Last-Modified value for [/SpringMvcProject/myprofile.htm] is: -1
2012-02-23 15:50:04,445 DEBUG [http-8080-1] - DispatcherServlet with name 'SpringMvcProject' processing GET request for [/SpringMvcProject/myprofile.htm]
2012-02-23 15:50:04,445  INFO [http-8080-1] - :::: Displaying profile info for ::::: deepak
2012-02-23 15:50:04,445 DEBUG [http-8080-1] - Returning cached instance of singleton bean 'profileService'
2012-02-23 15:50:04,445  INFO [http-8080-1] - ::: Executing query to display profile information :::
2012-02-23 15:50:04,446 DEBUG [http-8080-1] - Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@3b5587] for iBATIS operation
2012-02-23 15:50:04,446 DEBUG [http-8080-1] - {conn-100003} Connection
2012-02-23 15:50:04,446 DEBUG [http-8080-1] - Obtained JDBC Connection [Transaction-aware proxy for target Connection  from DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@16c1857]] for iBATIS operation
2012-02-23 15:50:04,446 DEBUG [http-8080-1] - Cache 'profile.profileCache': cache miss
2012-02-23 15:50:04,446 DEBUG [http-8080-1] - {conn-100003} Preparing Statement:   SELECT     users.serviceno,     users.userid,     users."password",     users."name",     users.emailid,     users.typeofuser,     users.dateofcreation,     rank.rankname,     branch.branchname,     unit.unitname,     designation.designationname,     usersection.usersectionname  FROM      coderanch.users LEFT JOIN coderanch.usersection  ON   (users.usersection = usersection.usersectionid) LEFT JOIN coderanch.rank   ON   (users.rank = rank.rankid) LEFT JOIN coderanch.branch   ON    (users.branch=branch.branchid) LEFT JOIN coderanch.unit   ON   (users.unit=unit.unitid) LEFT JOIN coderanch.designation   ON    (users.designation=designation.designationid) WHERE users.userid = ?  
2012-02-23 15:50:04,447 DEBUG [http-8080-1] - Fetching JDBC Connection from DataSource
2012-02-23 15:50:04,447 DEBUG [http-8080-1] - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/lms]
2012-02-23 15:50:04,486 DEBUG [http-8080-1] - {pstm-100004} Executing Statement:   SELECT     users.serviceno,     users.userid,     users."password",     users."name",     users.emailid,     users.typeofuser,     users.dateofcreation,     rank.rankname,     branch.branchname,     unit.unitname,     designation.designationname,     usersection.usersectionname  FROM      coderanch.users LEFT JOIN coderanch.usersection  ON   (users.usersection = usersection.usersectionid) LEFT JOIN coderanch.rank   ON   (users.rank = rank.rankid) LEFT JOIN coderanch.branch   ON    (users.branch=branch.branchid) LEFT JOIN coderanch.unit   ON   (users.unit=unit.unitid) LEFT JOIN coderanch.designation   ON    (users.designation=designation.designationid) WHERE users.userid = ?  
2012-02-23 15:50:04,487 DEBUG [http-8080-1] - {pstm-100004} Parameters: [deepak]
2012-02-23 15:50:04,487 DEBUG [http-8080-1] - {pstm-100004} Types: [java.lang.String]
2012-02-23 15:50:04,496 DEBUG [http-8080-1] - {rset-100005} ResultSet
2012-02-23 15:50:04,515  INFO [http-8080-1] - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2012-02-23 15:50:04,515 DEBUG [http-8080-1] - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
2012-02-23 15:50:04,517 DEBUG [http-8080-1] - Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd
2012-02-23 15:50:04,521 DEBUG [http-8080-1] - Loading bean definitions
2012-02-23 15:50:04,531 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'DB2'
2012-02-23 15:50:04,531 DEBUG [http-8080-1] - Creating instance of bean 'DB2'
2012-02-23 15:50:04,532 DEBUG [http-8080-1] - Eagerly caching bean 'DB2' to allow for resolving potential circular references
2012-02-23 15:50:04,537 DEBUG [http-8080-1] - Finished creating instance of bean 'DB2'
2012-02-23 15:50:04,537 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'Derby'
2012-02-23 15:50:04,537 DEBUG [http-8080-1] - Creating instance of bean 'Derby'
2012-02-23 15:50:04,537 DEBUG [http-8080-1] - Eagerly caching bean 'Derby' to allow for resolving potential circular references
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Finished creating instance of bean 'Derby'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'H2'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Creating instance of bean 'H2'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Eagerly caching bean 'H2' to allow for resolving potential circular references
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Finished creating instance of bean 'H2'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'HSQL'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Creating instance of bean 'HSQL'
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Eagerly caching bean 'HSQL' to allow for resolving potential circular references
2012-02-23 15:50:04,538 DEBUG [http-8080-1] - Finished creating instance of bean 'HSQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'Informix'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating instance of bean 'Informix'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Eagerly caching bean 'Informix' to allow for resolving potential circular references
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Finished creating instance of bean 'Informix'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'MS-SQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating instance of bean 'MS-SQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Eagerly caching bean 'MS-SQL' to allow for resolving potential circular references
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Finished creating instance of bean 'MS-SQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'MySQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Creating instance of bean 'MySQL'
2012-02-23 15:50:04,539 DEBUG [http-8080-1] - Eagerly caching bean 'MySQL' to allow for resolving potential circular references
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Finished creating instance of bean 'MySQL'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'Oracle'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Creating instance of bean 'Oracle'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Eagerly caching bean 'Oracle' to allow for resolving potential circular references
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Finished creating instance of bean 'Oracle'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'PostgreSQL'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Creating instance of bean 'PostgreSQL'
2012-02-23 15:50:04,540 DEBUG [http-8080-1] - Eagerly caching bean 'PostgreSQL' to allow for resolving potential circular references
2012-02-23 15:50:04,541 DEBUG [http-8080-1] - Finished creating instance of bean 'PostgreSQL'
2012-02-23 15:50:04,541 DEBUG [http-8080-1] - Creating shared instance of singleton bean 'Sybase'
2012-02-23 15:50:04,541 DEBUG [http-8080-1] - Creating instance of bean 'Sybase'
2012-02-23 15:50:04,541 DEBUG [http-8080-1] - Eagerly caching bean 'Sybase' to allow for resolving potential circular references
2012-02-23 15:50:04,541 DEBUG [http-8080-1] - Finished creating instance of bean 'Sybase'
2012-02-23 15:50:04,541  INFO [http-8080-1] - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2012-02-23 15:50:04,547 DEBUG [http-8080-1] - Looking up default SQLErrorCodes for DataSource [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy@1e9c3f]
2012-02-23 15:50:04,550 DEBUG [http-8080-1] - Fetching JDBC Connection from DataSource
2012-02-23 15:50:04,550 DEBUG [http-8080-1] - Fetching JDBC Connection from DataSource
2012-02-23 15:50:04,550 DEBUG [http-8080-1] - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/lms]
2012-02-23 15:50:04,591 DEBUG [http-8080-1] - Returning JDBC Connection to DataSource
2012-02-23 15:50:04,591 DEBUG [http-8080-1] - Returning JDBC Connection to DataSource
2012-02-23 15:50:04,592 DEBUG [http-8080-1] - Database product name cached for DataSource [org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy@1e9c3f]: name is 'PostgreSQL'
2012-02-23 15:50:04,592 DEBUG [http-8080-1] - SQL error codes for 'PostgreSQL' found
2012-02-23 15:50:04,592 DEBUG [http-8080-1] - Unable to translate SQLException with SQL state 'null', error code '0, will now try the fallback translator
2012-02-23 15:50:04,593 DEBUG [http-8080-1] - Returning JDBC Connection to DataSource
2012-02-23 15:50:04,593 ERROR [http-8080-1] - **** Cannot display profile information for users **** deepak SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   
--- The error occurred in com/spring/mvc/sqlmaps/ProfileSqlMap.xml.  
--- The error occurred while applying a result map.  
--- Check the profile.profileResultMap.  
--- The error happened while setting a property on the result object.  
--- Cause: net.sf.cglib.beans.BulkBeanException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/spring/mvc/sqlmaps/ProfileSqlMap.xml.  
--- The error occurred while applying a result map.  
--- Check the profile.profileResultMap.  
--- The error happened while setting a property on the result object.  
--- Cause: net.sf.cglib.beans.BulkBeanException
2012-02-23 15:50:04,594 DEBUG [http-8080-1] - Invoking afterPropertiesSet() on bean with name 'profile/myprofile'
2012-02-23 15:50:04,594 DEBUG [http-8080-1] - Rendering view [org.springframework.web.servlet.view.JstlView: name 'profile/myprofile'; URL [/view/profile/myprofile.jsp]] in DispatcherServlet with name 'SpringMvcProject'
2012-02-23 15:50:04,594 DEBUG [http-8080-1] - Added model object 'setUserIdToProfile' of type [java.util.ArrayList] to request in view with name 'profile/myprofile'
2012-02-23 15:50:04,594 DEBUG [http-8080-1] - Forwarding to resource [/view/profile/myprofile.jsp] in InternalResourceView 'profile/myprofile'
::: Page session is :::[]
2012-02-23 15:50:04,712 DEBUG [http-8080-1] - Successfully completed request

I even tried and changed my database driver to the latest version, but it hasn't helped me

[Deepaks Deshpande]

Please anyone help me with this problem