ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From viren1 <virendra.dhap...@modius.com>
Subject com.microsoft.sqlserver.jdbc.SQLServerException: The request for procedure 'NAME_SPACE_GET' failed because 'NAME_SPACE_GET' is a function object.
Date Wed, 08 Nov 2006 00:19:53 GMT

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#a7230428
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message