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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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. >>> >> >>
