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 RE: Ibatis - DB2 Universal Driver problem
Date Fri, 17 Nov 2006 17:58:49 GMT

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:Susmita.Kalluri@judiciary.state.nj.us] 
> 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.


Mime
View raw message