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.
