ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Nayak" <chetannay...@gmail.com>
Subject Re: Please Help
Date Thu, 18 Oct 2007 21:28:45 GMT
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 <chetannayaks@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 <lmeadors@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 <chetannayaks@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.
> >
>
>

Mime
View raw message