ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From viren1 <virendra.dhap...@modius.com>
Subject anybody using MSSQL 2005 JDBC 1.1 driver with ibatis?
Date Wed, 08 Nov 2006 18:02:43 GMT



viren1 wrote:
> 
> Hi,
> I just started using MSSQL 2005 jdbc 1.1 driver and getting a following
> exception. Till now I was usiing mssql jdbc 2000 drivers everything worked
> perfect.  Here "NAME_SPACE_GET" is user define function.
> 
> Any kind of help would be appreciated.
> 
> com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id
> [getNameSpaceId], parameterObject [{code=DEVICE_22, nameSpaceId=null,
> objId=6914992}].  Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:   
> jvm 1    | --- The error occurred in com/modius/ee/dao/sqlmap/Device.xml.  
> jvm 1    | --- The error occurred while applying a parameter map.  
> jvm 1    | --- Check the Device.getNameSpaceIdMap.  
> jvm 1    | --- Check the statement (update procedure failed).  
> jvm 1    | --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
> jvm 1    | --- The error occurred in com/modius/ee/dao/sqlmap/Device.xml.  
> jvm 1    | --- The error occurred while applying a parameter map.  
> jvm 1    | --- Check the Device.getNameSpaceIdMap.  
> jvm 1    | --- Check the statement (update procedure failed).  
> jvm 1    | --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | 	at
> com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:164)
> jvm 1    | 	at
> com.modius.ee.dao.sqlmap.SqlMapDeviceDAO.getNameSpaceId(SqlMapDeviceDAO.java:335)
> jvm 1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> jvm 1    | 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> jvm 1    | 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> jvm 1    | 	at java.lang.reflect.Method.invoke(Method.java:585)
> jvm 1    | 	at
> com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:64)
> jvm 1    | 	at $Proxy5.getNameSpaceId(Unknown Source)
> jvm 1    | 	at
> com.modius.em.metadata.DeviceSync.updateCollectorURL(DeviceSync.java:632)
> jvm 1    | 	at
> com.modius.em.metadata.DeviceSync.updateDevice(DeviceSync.java:336)
> jvm 1    | 	at
> com.modius.em.metadata.DeviceSync.processUpdate(DeviceSync.java:391)
> jvm 1    | 	at
> com.modius.em.metadata.DeviceSync.syncDevice(DeviceSync.java:109)
> jvm 1    | 	at
> com.modius.em.metadata.DeviceSync.objectAdapterAdded(DeviceSync.java:89)
> jvm 1    | 	at
> com.impactdatacorp.protocol.adapter.registrar.POARegistrarService$AddCallback.execute(POARegistrarService.java:152)
> jvm 1    | 	at
> com.impactdatacorp.util.command.CommandProcessor.run(CommandProcessor.java:254)
> jvm 1    | Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
> jvm 1    | --- The error occurred in com/modius/ee/dao/sqlmap/Device.xml.  
> jvm 1    | --- The error occurred while applying a parameter map.  
> jvm 1    | --- Check the Device.getNameSpaceIdMap.  
> jvm 1    | --- Check the statement (update procedure failed).  
> jvm 1    | --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
> jvm 1    | 	at
> com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:162)
> jvm 1    | 	... 14 more
> jvm 1    | Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
> request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is
> a function object.
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
> Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
> Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
> Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
> Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
> jvm 1    | 	at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown
> Source)
> jvm 1    | 	at
> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:287)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)
> jvm 1    | 	at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
> jvm 1    | 	... 20 more
> 
> 
> This is from sqlmap file:
> 
>  <parameterMap id="getNameSpaceIdMap" class="java.util.HashMap">
>          <parameter property="nameSpaceId" jdbcType="BIGINT"  mode="OUT"/>
>          <parameter property="objId" jdbcType="BIGINT"  />
>          <parameter property="code" jdbcType="VARCHAR"  />
>     </parameterMap>
>     <procedure id="getNameSpaceId" parameterMap="getNameSpaceIdMap"
> ><![CDATA[
>          { ?  =  CALL EG.NAME_SPACE_GET( ?, ? )}
>      ]]></procedure >
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/com.microsoft.sqlserver.jdbc.SQLServerException%3A-The-request-for-procedure-%27NAME_SPACE_GET%27-failed-because-%27NAME_SPACE_GET%27-is-a-function-object.-tf2592488.html#a7243606
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message