You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Chetan Nayak <ch...@gmail.com> on 2007/10/18 21:57:43 UTC
Please Help
Hi All ,
Im facing a vert strange problem ,Our application uses IBATIS .
Everything seems to be working locally ,When we deploy on the server ,One of
the queries which uses a XmlTypeCallBackHandler fails , But when it runs
locally it works fine.
Does anyone have any idea why this is happening.
Thanks
Chetan
Re: Please Help
Posted by Christopher Lamey <cl...@localmatters.com>.
According to the logs you sent, the root cause is this:
> java.lang.UnsupportedOperationException: XMLType mapping only supported for
> Oracle RDBMS
> at
> com.cerner.clm.dao.sqlmap.XMLTypeHandlerCallback.getResult(XMLTypeHandlerCallb
> ack.java:69)
Which I'm guessing is the one from here that you cut and pasted into your
project:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/XMLTypeHandler
Callback.java
Is that right?
If so, that Class will throw that exception when the ResultSet or
PreparedStatement are not Oracle specific ones.
So my guess is it's something to do with your jars and classpath ordering.
Make sure they're the exact same between the two enviroments.
On 10/18/07 3:28 PM, "Chetan Nayak" <ch...@gmail.com> wrote:
> What Could make it work locally in dev environment and not in Server ,In
> both cases i connect to the same DB.
>
>
>
> On 10/19/07, Chetan Nayak <ch...@gmail.com> wrote:
>>
>> Alright sorry for hi-jacking those threads guys ,I didn't mean to do it
>> ,Will make sure i don't do it again.............:)
>> So here is the description ,We use RAD for local development which has a
>> inbuilt Websphere server ,Also we use Websphere at the place where we deploy
>> ,ie. our CERTIFICATION servers.
>> Now when i connect to the CERTIFICATION Database ,everything works fine
>> ,But after i deploy in CERT SERVER ,IBATIS queries which uses the
>> XMLTypeCallBackHandler fails,I have no clue why..........:(
>> Here is the server log.
>>
>>
>> [10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,901 DEBUG (DaoConfig:228): DaoConfig : SQL = PersonPrivData; Obj
>> type = HashMap
>> [10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,901 DEBUG (SimpleDataSource:27): Checked out connection 430184868
>> from pool.
>> [10/18/07 13:34:54:932 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,932 DEBUG (Connection:27): {conn-100013} Connection
>> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,948 DEBUG (Connection:27): {conn-100013} Preparing Statement:
>> SELECT secp.sec_person_id, secp.username,
>> secp.person_priv_xml_data FROM clm_sec_person secp WHERE 1=1
>> and SEC_PERSON_ID = 'person_200705040938521234'
>> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Executing
>> Statement: SELECT secp.sec_person_id, secp.username,
>> secp.person_priv_xml_data FROM clm_sec_person secp WHERE 1=1
>> and SEC_PERSON_ID = 'person_200705040938521234'
>> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Parameters: []
>> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Types: []
>> [10/18/07 13:34:55:308 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,308 DEBUG (ResultSet:27): {rset-100015} ResultSet
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 ERROR (DaoConfig:239): DaoConfig Error : SQL Exception caught
>> |com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in dao/RolePrivilegeManager.xml.
>> --- The error occurred while applying a result map.
>> --- Check the RolePrivilegeManager.getPersonPrivDataMap.
>> --- Check the result mapping for the 'SECQUESTION' property.
>> --- Cause: java.lang.UnsupportedOperationException : XMLType mapping only
>> supported for Oracle RDBMS
>> com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in dao/RolePrivilegeManager.xml.
>> --- The error occurred while applying a result map.
>> --- Check the RolePrivilegeManager.getPersonPrivDataMap.
>> --- Check the result mapping for the 'SECQUESTION' property.
>> --- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
>> supported for Oracle RDBMS
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithC
>> allback
>> (GeneralStatement.java:188)
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForLi
>> st
>> (GeneralStatement.java :123)
>> at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
>> SqlMapExecutorDelegate.java:615)
>> at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
>> SqlMapExecutorDelegate.java:589)
>> at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
>> SqlMapSessionImpl.java:118)
>> at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
>> SqlMapClientImpl.java:95)
>> at com.cerner.clm.dao.DaoConfig.queryForListing (DaoConfig.java:234)
>> at com.cerner.clm.dao.sqlmap.CLMDataManagerHelperDao.getData(
>> CLMDataManagerHelperDao.java:55)
>> at com.cerner.clm.ejb.session.CLMDataManagerBean.getData(
>> CLMDataManagerBean.java:877)
>> at
>> com.cerner.clm.ejb.session.EJSRemoteStatelessCLMDataManager_3743debc.getData(
>> EJSRemoteStatelessCLMDataManager_3743debc.java:94)
>> at com.cerner.clm.ejb.session._CLMDataManager_Stub.getData
>> (_CLMDataManager_Stub.java:316)
>> at com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getData(
>> ClmRolePrivilegeManagerBean.java :166)
>> at
>> com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getUserPrivileges(
>> ClmRolePrivilegeManagerBean.java:1142)
>> at
>> com.cerner.clm.ejb.session.EJSRemoteStatelessClmRolePrivilegeManager_24a482ba
>> .getUserPrivileges(EJSRemoteStatelessClmRolePrivilegeManager_24a482ba.java:19
>> 3)
>> at
>> com.cerner.clm.ejb.session._ClmRolePrivilegeManager_Stub.getUserPrivileges
>> (_ClmRolePrivilegeManager_Stub.java:481)
>> at com.cerner.clm.ejb.session.CLMSecurityManagerBean.userAllPrivs (
>> CLMSecurityManagerBean.java:565)
>> at
>> com.cerner.clm.ejb.session.CLMSecurityManagerBean.getUserPrivsAndStoreInDB
>> (CLMSecurityManagerBean.java:444)
>> at
>> com.cerner.clm.ejb.session.EJSRemoteStatelessCLMSecurityManager_6f2c4b85.getU
>> serPrivsAndStoreInDB(EJSRemoteStatelessCLMSecurityManager_6f2c4b85.java:799)
>> at
>> com.cerner.clm.ejb.session._CLMSecurityManager_Stub.getUserPrivsAndStoreInDB
>> (_CLMSecurityManager_Stub.java:1008)
>> at com.cerner.clm.ui.CLMServlet.getSessionInfoAndStoreInDB (
>> CLMServlet.java:869)
>> at com.cerner.clm.ui.CLMServlet.checkLogin(CLMServlet.java:778)
>> at com.cerner.clm.ui.CLMServlet.verifyAuthentication(CLMServlet.java:681)
>> at com.cerner.clm.ui.CLMServlet.processRequest(CLMServlet.java :293)
>> at com.cerner.clm.ui.CLMServlet.doPost(CLMServlet.java:147)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
>> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service (
>> ServletWrapper.java:989)
>> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
>> ServletWrapper.java:501)
>> at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(
>> ServletWrapper.java:464)
>> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
>> CacheServletWrapper.java:90)
>> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java
>> :744)
>> at com.ibm.ws.wswebcontainer.WebContainer.handleRequest (
>> WebContainer.java:1433)
>> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java
>> :111)
>> at
>> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(
>> HttpInboundLink.java:454)
>> at
>> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(
>> HttpInboundLink.java:383)
>> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
>> HttpICLReadCallback.java:102)
>> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(
>> AioReadCompletionListener.java:165)
>> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(
>> AbstractAsyncFuture.java:217)
>> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(
>> AsyncChannelFuture.java:161)
>> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
>> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
>> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(
>> ResultHandler.java:743)
>> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
>> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
>> Caused by:
>> java.lang.UnsupportedOperationException: XMLType mapping only supported
>> for Oracle RDBMS
>> at com.cerner.clm.dao.sqlmap.XMLTypeHandlerCallback.getResult(
>> XMLTypeHandlerCallback.java:69)
>> at com.ibatis.sqlmap.engine.type.CustomTypeHandler.getResult(
>> CustomTypeHandler.java:52)
>> at
>> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMapp
>> ingValue(
>> BasicResultMap.java:611)
>> at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(
>> BasicResultMap.java:344)
>> at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(
>> SqlExecutor.java:381)
>> at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(
>> SqlExecutor.java:301)
>> at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
>> SqlExecutor.java:190)
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
>> GeneralStatement.java:205)
>> at
>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithC
>> allback
>> (GeneralStatement.java:173)
>> ... 43 more
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 DEBUG (SimpleDataSource:27): Returned connection 430184868 to
>> pool.
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 INFO (DaoConfig:254): DaoConfig.handleEJBCall() : returned
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 INFO (CLMDataManagerHelperDao:86):
>> CLMDataManagerHelperDao.convertListToString() : has been called
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:99): CLMDataManagerHelperDao :
>> list size = 0
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:154): CLMDataManagerHelperDao :
>> returnString = <ROWSET></ROWSET>
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:155): xmlString replaced =
>> <ROWSET></ROWSET>
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 INFO (CLMDataManagerHelperDao:159):
>> CLMDataManagerHelperDao.convertListToString() : returned
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 INFO (CLMDataManagerHelperDao:67):
>> CLMDataManagerHelperDao.getData() : returned
>> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
>> 13:34:55,323 DEBUG (CLMDataManagerBean:881): CLMDataManagerBean : data
>> returned From the DM = <ROWSET></ROWSET>
>>
>>
>>
>>
>> On 10/19/07, Larry Meadors <lm...@apache.org> wrote:
>>>
>>> OK, two suggestions:
>>>
>>> - please don't hi-jack threads
>>> - please don't post to *every* list @ ibatis.apache.org
>>>
>>> Larry
>>>
>>>
>>> On 10/18/07, Chetan Nayak <ch...@gmail.com> wrote:
>>>> Hi All ,
>>>>
>>>> Im facing a vert strange problem ,Our application uses
>>> IBATIS .
>>>> Everything seems to be working locally ,When we deploy on the server
>>> ,One of
>>>> the queries which uses a XmlTypeCallBackHandler fails , But when it
>>> runs
>>>> locally it works fine.
>>>> Does anyone have any idea why this is happening.
>>>
>>
>>
Re: Please Help
Posted by Chetan Nayak <ch...@gmail.com>.
What Could make it work locally in dev environment and not in Server ,In
both cases i connect to the same DB.
On 10/19/07, Chetan Nayak <ch...@gmail.com> wrote:
>
> Alright sorry for hi-jacking those threads guys ,I didn't mean to do it
> ,Will make sure i don't do it again.............:)
> So here is the description ,We use RAD for local development which has a
> inbuilt Websphere server ,Also we use Websphere at the place where we deploy
> ,ie. our CERTIFICATION servers.
> Now when i connect to the CERTIFICATION Database ,everything works fine
> ,But after i deploy in CERT SERVER ,IBATIS queries which uses the
> XMLTypeCallBackHandler fails,I have no clue why..........:(
> Here is the server log.
>
>
> [10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,901 DEBUG (DaoConfig:228): DaoConfig : SQL = PersonPrivData; Obj
> type = HashMap
> [10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,901 DEBUG (SimpleDataSource:27): Checked out connection 430184868
> from pool.
> [10/18/07 13:34:54:932 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,932 DEBUG (Connection:27): {conn-100013} Connection
> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,948 DEBUG (Connection:27): {conn-100013} Preparing Statement:
> SELECT secp.sec_person_id, secp.username,
> secp.person_priv_xml_data FROM clm_sec_person secp WHERE 1=1
> and SEC_PERSON_ID = 'person_200705040938521234'
> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Executing
> Statement: SELECT secp.sec_person_id, secp.username,
> secp.person_priv_xml_data FROM clm_sec_person secp WHERE 1=1
> and SEC_PERSON_ID = 'person_200705040938521234'
> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Parameters: []
> [10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:54,948 DEBUG (PreparedStatement:27): {pstm-100014} Types: []
> [10/18/07 13:34:55:308 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,308 DEBUG (ResultSet:27): {rset-100015} ResultSet
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 ERROR (DaoConfig:239): DaoConfig Error : SQL Exception caught
> |com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in dao/RolePrivilegeManager.xml.
> --- The error occurred while applying a result map.
> --- Check the RolePrivilegeManager.getPersonPrivDataMap.
> --- Check the result mapping for the 'SECQUESTION' property.
> --- Cause: java.lang.UnsupportedOperationException : XMLType mapping only
> supported for Oracle RDBMS
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in dao/RolePrivilegeManager.xml.
> --- The error occurred while applying a result map.
> --- Check the RolePrivilegeManager.getPersonPrivDataMap.
> --- Check the result mapping for the 'SECQUESTION' property.
> --- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
> supported for Oracle RDBMS
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> (GeneralStatement.java:188)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
> (GeneralStatement.java :123)
> at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> SqlMapExecutorDelegate.java:615)
> at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> SqlMapExecutorDelegate.java:589)
> at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
> SqlMapSessionImpl.java:118)
> at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
> SqlMapClientImpl.java:95)
> at com.cerner.clm.dao.DaoConfig.queryForListing (DaoConfig.java:234)
> at com.cerner.clm.dao.sqlmap.CLMDataManagerHelperDao.getData(
> CLMDataManagerHelperDao.java:55)
> at com.cerner.clm.ejb.session.CLMDataManagerBean.getData(
> CLMDataManagerBean.java:877)
> at
> com.cerner.clm.ejb.session.EJSRemoteStatelessCLMDataManager_3743debc.getData(EJSRemoteStatelessCLMDataManager_3743debc.java:94)
> at com.cerner.clm.ejb.session._CLMDataManager_Stub.getData
> (_CLMDataManager_Stub.java:316)
> at com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getData(
> ClmRolePrivilegeManagerBean.java :166)
> at
> com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getUserPrivileges(
> ClmRolePrivilegeManagerBean.java:1142)
> at
> com.cerner.clm.ejb.session.EJSRemoteStatelessClmRolePrivilegeManager_24a482ba.getUserPrivileges(EJSRemoteStatelessClmRolePrivilegeManager_24a482ba.java:193)
> at
> com.cerner.clm.ejb.session._ClmRolePrivilegeManager_Stub.getUserPrivileges
> (_ClmRolePrivilegeManager_Stub.java:481)
> at com.cerner.clm.ejb.session.CLMSecurityManagerBean.userAllPrivs (
> CLMSecurityManagerBean.java:565)
> at
> com.cerner.clm.ejb.session.CLMSecurityManagerBean.getUserPrivsAndStoreInDB
> (CLMSecurityManagerBean.java:444)
> at
> com.cerner.clm.ejb.session.EJSRemoteStatelessCLMSecurityManager_6f2c4b85.getUserPrivsAndStoreInDB(EJSRemoteStatelessCLMSecurityManager_6f2c4b85.java:799)
> at
> com.cerner.clm.ejb.session._CLMSecurityManager_Stub.getUserPrivsAndStoreInDB
> (_CLMSecurityManager_Stub.java:1008)
> at com.cerner.clm.ui.CLMServlet.getSessionInfoAndStoreInDB (
> CLMServlet.java:869)
> at com.cerner.clm.ui.CLMServlet.checkLogin(CLMServlet.java:778)
> at com.cerner.clm.ui.CLMServlet.verifyAuthentication(CLMServlet.java:681)
> at com.cerner.clm.ui.CLMServlet.processRequest(CLMServlet.java :293)
> at com.cerner.clm.ui.CLMServlet.doPost(CLMServlet.java:147)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service (
> ServletWrapper.java:989)
> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> ServletWrapper.java:501)
> at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(
> ServletWrapper.java:464)
> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
> CacheServletWrapper.java:90)
> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java
> :744)
> at com.ibm.ws.wswebcontainer.WebContainer.handleRequest (
> WebContainer.java:1433)
> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java
> :111)
> at
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(
> HttpInboundLink.java:454)
> at
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(
> HttpInboundLink.java:383)
> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
> HttpICLReadCallback.java:102)
> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(
> AioReadCompletionListener.java:165)
> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(
> AbstractAsyncFuture.java:217)
> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(
> AsyncChannelFuture.java:161)
> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(
> ResultHandler.java:743)
> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
> Caused by:
> java.lang.UnsupportedOperationException: XMLType mapping only supported
> for Oracle RDBMS
> at com.cerner.clm.dao.sqlmap.XMLTypeHandlerCallback.getResult(
> XMLTypeHandlerCallback.java:69)
> at com.ibatis.sqlmap.engine.type.CustomTypeHandler.getResult(
> CustomTypeHandler.java:52)
> at
> com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue(
> BasicResultMap.java:611)
> at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(
> BasicResultMap.java:344)
> at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(
> SqlExecutor.java:381)
> at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(
> SqlExecutor.java:301)
> at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> SqlExecutor.java:190)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
> GeneralStatement.java:205)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> (GeneralStatement.java:173)
> ... 43 more
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 DEBUG (SimpleDataSource:27): Returned connection 430184868 to
> pool.
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 INFO (DaoConfig:254): DaoConfig.handleEJBCall() : returned
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 INFO (CLMDataManagerHelperDao:86):
> CLMDataManagerHelperDao.convertListToString() : has been called
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:99): CLMDataManagerHelperDao :
> list size = 0
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:154): CLMDataManagerHelperDao :
> returnString = <ROWSET></ROWSET>
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 DEBUG (CLMDataManagerHelperDao:155): xmlString replaced =
> <ROWSET></ROWSET>
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 INFO (CLMDataManagerHelperDao:159):
> CLMDataManagerHelperDao.convertListToString() : returned
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 INFO (CLMDataManagerHelperDao:67):
> CLMDataManagerHelperDao.getData() : returned
> [10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18
> 13:34:55,323 DEBUG (CLMDataManagerBean:881): CLMDataManagerBean : data
> returned From the DM = <ROWSET></ROWSET>
>
>
>
>
> On 10/19/07, Larry Meadors <lm...@apache.org> wrote:
> >
> > OK, two suggestions:
> >
> > - please don't hi-jack threads
> > - please don't post to *every* list @ ibatis.apache.org
> >
> > Larry
> >
> >
> > On 10/18/07, Chetan Nayak <ch...@gmail.com> wrote:
> > > Hi All ,
> > >
> > > Im facing a vert strange problem ,Our application uses
> > IBATIS .
> > > Everything seems to be working locally ,When we deploy on the server
> > ,One of
> > > the queries which uses a XmlTypeCallBackHandler fails , But when it
> > runs
> > > locally it works fine.
> > > Does anyone have any idea why this is happening.
> >
>
>
Re: Please Help
Posted by Chetan Nayak <ch...@gmail.com>.
Alright sorry for hi-jacking those threads guys ,I didn't mean to do it
,Will make sure i don't do it again.............:)
So here is the description ,We use RAD for local development which has a
inbuilt Websphere server ,Also we use Websphere at the place where we deploy
,ie. our CERTIFICATION servers.
Now when i connect to the CERTIFICATION Database ,everything works fine ,But
after i deploy in CERT SERVER ,IBATIS queries which uses the
XMLTypeCallBackHandler fails,I have no clue why..........:(
Here is the server log.
[10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,901
DEBUG (DaoConfig:228): DaoConfig : SQL = PersonPrivData; Obj type = HashMap
[10/18/07 13:34:54:901 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,901
DEBUG (SimpleDataSource:27): Checked out connection 430184868 from pool.
[10/18/07 13:34:54:932 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,932
DEBUG (Connection:27): {conn-100013} Connection
[10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,948
DEBUG (Connection:27): {conn-100013} Preparing Statement: SELECT
secp.sec_person_id, secp.username, secp.person_priv_xml_data FROM
clm_sec_person secp WHERE 1=1 and SEC_PERSON_ID =
'person_200705040938521234'
[10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,948
DEBUG (PreparedStatement:27): {pstm-100014} Executing Statement:
SELECT secp.sec_person_id, secp.username, secp.person_priv_xml_data
FROM clm_sec_person secp WHERE 1=1 and SEC_PERSON_ID =
'person_200705040938521234'
[10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,948
DEBUG (PreparedStatement:27): {pstm-100014} Parameters: []
[10/18/07 13:34:54:948 CDT] 0000002f SystemOut O 2007-10-18 13:34:54,948
DEBUG (PreparedStatement:27): {pstm-100014} Types: []
[10/18/07 13:34:55:308 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,308
DEBUG (ResultSet:27): {rset-100015} ResultSet
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
ERROR (DaoConfig:239): DaoConfig Error : SQL Exception caught
|com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in dao/RolePrivilegeManager.xml.
--- The error occurred while applying a result map.
--- Check the RolePrivilegeManager.getPersonPrivDataMap.
--- Check the result mapping for the 'SECQUESTION' property.
--- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
supported for Oracle RDBMS
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in dao/RolePrivilegeManager.xml.
--- The error occurred while applying a result map.
--- Check the RolePrivilegeManager.getPersonPrivDataMap.
--- Check the result mapping for the 'SECQUESTION' property.
--- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
supported for Oracle RDBMS
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:188)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
SqlMapClientImpl.java:95)
at com.cerner.clm.dao.DaoConfig.queryForListing(DaoConfig.java:234)
at com.cerner.clm.dao.sqlmap.CLMDataManagerHelperDao.getData(
CLMDataManagerHelperDao.java:55)
at com.cerner.clm.ejb.session.CLMDataManagerBean.getData(
CLMDataManagerBean.java:877)
at
com.cerner.clm.ejb.session.EJSRemoteStatelessCLMDataManager_3743debc.getData
(EJSRemoteStatelessCLMDataManager_3743debc.java:94)
at com.cerner.clm.ejb.session._CLMDataManager_Stub.getData
(_CLMDataManager_Stub.java:316)
at com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getData(
ClmRolePrivilegeManagerBean.java:166)
at com.cerner.clm.ejb.session.ClmRolePrivilegeManagerBean.getUserPrivileges
(ClmRolePrivilegeManagerBean.java:1142)
at
com.cerner.clm.ejb.session.EJSRemoteStatelessClmRolePrivilegeManager_24a482ba.getUserPrivileges
(EJSRemoteStatelessClmRolePrivilegeManager_24a482ba.java:193)
at
com.cerner.clm.ejb.session._ClmRolePrivilegeManager_Stub.getUserPrivileges
(_ClmRolePrivilegeManager_Stub.java:481)
at com.cerner.clm.ejb.session.CLMSecurityManagerBean.userAllPrivs(
CLMSecurityManagerBean.java:565)
at
com.cerner.clm.ejb.session.CLMSecurityManagerBean.getUserPrivsAndStoreInDB(
CLMSecurityManagerBean.java:444)
at
com.cerner.clm.ejb.session.EJSRemoteStatelessCLMSecurityManager_6f2c4b85.getUserPrivsAndStoreInDB
(EJSRemoteStatelessCLMSecurityManager_6f2c4b85.java:799)
at
com.cerner.clm.ejb.session._CLMSecurityManager_Stub.getUserPrivsAndStoreInDB
(_CLMSecurityManager_Stub.java:1008)
at com.cerner.clm.ui.CLMServlet.getSessionInfoAndStoreInDB(CLMServlet.java
:869)
at com.cerner.clm.ui.CLMServlet.checkLogin(CLMServlet.java:778)
at com.cerner.clm.ui.CLMServlet.verifyAuthentication(CLMServlet.java:681)
at com.cerner.clm.ui.CLMServlet.processRequest(CLMServlet.java:293)
at com.cerner.clm.ui.CLMServlet.doPost(CLMServlet.java:147)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
ServletWrapper.java:989)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
ServletWrapper.java:501)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(
ServletWrapper.java:464)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java
:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java
:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java
:111)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(
HttpInboundLink.java:454)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(
HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(
AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(
AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(
AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java
:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
Caused by:
java.lang.UnsupportedOperationException: XMLType mapping only supported for
Oracle RDBMS
at com.cerner.clm.dao.sqlmap.XMLTypeHandlerCallback.getResult(
XMLTypeHandlerCallback.java:69)
at com.ibatis.sqlmap.engine.type.CustomTypeHandler.getResult(
CustomTypeHandler.java:52)
at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMappingValue
(BasicResultMap.java:611)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(
BasicResultMap.java:344)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(
SqlExecutor.java:381)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(
SqlExecutor.java:301)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
SqlExecutor.java:190)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:173)
... 43 more
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
DEBUG (SimpleDataSource:27): Returned connection 430184868 to pool.
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
INFO (DaoConfig:254): DaoConfig.handleEJBCall() : returned
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
INFO (CLMDataManagerHelperDao:86):
CLMDataManagerHelperDao.convertListToString() : has been called
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
DEBUG (CLMDataManagerHelperDao:99): CLMDataManagerHelperDao : list size = 0
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
DEBUG (CLMDataManagerHelperDao:154): CLMDataManagerHelperDao : returnString
= <ROWSET></ROWSET>
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
DEBUG (CLMDataManagerHelperDao:155): xmlString replaced = <ROWSET></ROWSET>
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
INFO (CLMDataManagerHelperDao:159):
CLMDataManagerHelperDao.convertListToString() : returned
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
INFO (CLMDataManagerHelperDao:67): CLMDataManagerHelperDao.getData() :
returned
[10/18/07 13:34:55:323 CDT] 0000002f SystemOut O 2007-10-18 13:34:55,323
DEBUG (CLMDataManagerBean:881): CLMDataManagerBean : data returned From the
DM = <ROWSET></ROWSET>
On 10/19/07, Larry Meadors <lm...@apache.org> wrote:
>
> OK, two suggestions:
>
> - please don't hi-jack threads
> - please don't post to *every* list @ibatis.apache.org
>
> Larry
>
>
> On 10/18/07, Chetan Nayak <ch...@gmail.com> wrote:
> > Hi All ,
> >
> > Im facing a vert strange problem ,Our application uses
> IBATIS .
> > Everything seems to be working locally ,When we deploy on the server
> ,One of
> > the queries which uses a XmlTypeCallBackHandler fails , But when it runs
> > locally it works fine.
> > Does anyone have any idea why this is happening.
>
Re: Please Help
Posted by Larry Meadors <lm...@apache.org>.
OK, two suggestions:
- please don't hi-jack threads
- please don't post to *every* list @ibatis.apache.org
Larry
On 10/18/07, Chetan Nayak <ch...@gmail.com> wrote:
> Hi All ,
>
> Im facing a vert strange problem ,Our application uses IBATIS .
> Everything seems to be working locally ,When we deploy on the server ,One of
> the queries which uses a XmlTypeCallBackHandler fails , But when it runs
> locally it works fine.
> Does anyone have any idea why this is happening.
Re: Please Help
Posted by Christopher Lamey <cl...@localmatters.com>.
We'll need more information to help.
To start with, what server, what is different between local and server
runtimes, and what is the error (cut and paste the exception).
On 10/18/07 1:57 PM, "Chetan Nayak" <ch...@gmail.com> wrote:
> Hi All ,
>
> Im facing a vert strange problem ,Our application uses IBATIS .
> Everything seems to be working locally ,When we deploy on the server ,One of
> the queries which uses a XmlTypeCallBackHandler fails , But when it runs
> locally it works fine.
> Does anyone have any idea why this is happening.
>
>
> Thanks
> Chetan