What's your iBATIS version? The current version always calls "execute" -
not executeQuery or executeUpdate.
Also - if the procedure doesn't return a result set, make sure you'r calling
it with the iBATIS update or insert API - not queryForObject or
queryForList.
Jeff Butler
On 11/17/06, smita_b <[EMAIL PROTECTED]> wrote:
no. i am using <procedure>
<procedure id="SCSP0006" parameterMap="PM_SCSP0006">{call
$dbid$.SCSP0006(?,?,?,?,?,?,?,?,?)}</procedure>
</sqlMap>
Randy Layman wrote:
>
>
> 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: user-java@ibatis.apache.org
> 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.
>
>
>
--
View this message in context:
http://www.nabble.com/Ibatis---DB2-Universal-Driver-problem-tf2655136.html#a7408013
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
