The problem is likely in the
com/aoc/ito/atoms/ibatis/SCSP0006.xml file. From the error message I
would guess you are using a <select> element instead of a <procedure>
element to call a stored procedure.
Randy
-----Original Message-----
From: smita_b [mailto:[EMAIL PROTECTED]
Sent: Friday, November 17, 2006 12:10 PM
To: [email protected]
Subject: Ibatis - DB2 Universal Driver problem
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.ht
ml#a7406733
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
