ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From smita_b <Susmita.Kall...@judiciary.state.nj.us>
Subject Ibatis - DB2 Universal Driver problem
Date Fri, 17 Nov 2006 17:09:43 GMT

Hi,

We are migrating from WAS 5.1 to WAS 6.0 and also changing from DB2 Legacy
CLI-based Type 2 JDBC driver to DB2 Universal Driver.

Everything works fine with  DB2 Legacy CLI-based Type 2 JDBC driver in WAS
6.0 but gives an exception with DB2 Universal Driver as follows. I am
assuming something needs to be changed in the sql-map-config.xml can someone
point me to a right direction?

Posting the exception and the sql-map-config.xml 
********************************************

ERROR 2006-11-17 11:39:04,802
com.aoc.ito.atoms.dao.ATOMSDB2DAO.findByPrimaryKey(ATOMSDB2DAO.java:96) 
- >> com.ibatis.common.jdbc.exception.NestedSQLException: 
--- The error occurred in com/aoc/ito/atoms/ibatis/SCSP0006.xml. 
--- The error occurred while applying a parameter map.  
--- Check the PM_SCSP0006.  
--- Check the statement (update procedure failed).  

--- Cause: com.ibm.db2.jcc.b.SqlException:
java.sql.CallableStatement.executeQuery() 
was called but no result set was returned. Use
java.sql.CallableStatement.executeUpdate() 
for non-queries.

DEBUG 2006-11-17 11:39:04,817
com.aoc.ito.atoms.actions.Login.execute(Login.java:46) - >> Logged User
ID:admin,
Role ID:null, Description:null
INFO  2006-11-17 11:39:04,817
com.aoc.ito.atoms.actions.Login.execute(Login.java:74) - >> Login Failure,
Userid:admin

sql-map-config.xml
******************
<transactionManager type="EXTERNAL" commitRequired="false">
		<property name="DefaultAutoCommit" value="false" />
		<property name="SetAutomCommitAllowed" value="false" />		

		<dataSource type="JNDI">
			<!--  Resource Reference for EJB	-->
			<property name="DBJndiContext" value="java:comp/env/atomsRF" />
		</dataSource>
</transactionManager>

-- 
View this message in context: http://www.nabble.com/Ibatis---DB2-Universal-Driver-problem-tf2655136.html#a7406733
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message