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:00:23 GMT
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