Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 84253 invoked from network); 8 Nov 2006 18:03:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Nov 2006 18:03:11 -0000 Received: (qmail 19835 invoked by uid 500); 8 Nov 2006 18:03:19 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 19827 invoked by uid 500); 8 Nov 2006 18:03:19 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 19816 invoked by uid 99); 8 Nov 2006 18:03:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Nov 2006 10:03:19 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Nov 2006 10:03:04 -0800 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1Ghrl5-0002j0-OW for user-java@ibatis.apache.org; Wed, 08 Nov 2006 10:02:43 -0800 Message-ID: <7243606.post@talk.nabble.com> Date: Wed, 8 Nov 2006 10:02:43 -0800 (PST) From: viren1 To: user-java@ibatis.apache.org Subject: anybody using MSSQL 2005 JDBC 1.1 driver with ibatis? In-Reply-To: <7230428.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: virendra.dhapola@modius.com References: <7230428.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org 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: > > > > > > > > { ? = CALL EG.NAME_SPACE_GET( ?, ? )} > ]]> > > > > -- 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.