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.
