ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BiswaMishra <Biswaranjan_Mis...@satyam.com>
Subject Ibatis select Query failing throwing Error getting Connection from Transaction
Date Fri, 17 Jul 2009 05:44:02 GMT

Hi,

I am using Spring and ibatis as DB mapping layer . i am facing one problem
consistantly . my application is running in cluster environment . In Ibatis
DAO in one of the method i am using querryForList(id,object) . This is
working fine . this is used in a web application . the problem i am facing ,
my Ibatis select query is working fine when the request is executing in one
of the server always . we have two different servers, it is configured with
BigIP . but when my request is reaching other server, my Ibatis select query
is always failing throwing below exception :

Caused by: com.tgt.ecl.exception.TgtDataAccessException:
com.ibatis.common.jdbc.exception.NestedSQLException: Error getting
Connection from Transaction.  Cause:
com.ibatis.sqlmap.engine.transaction.TransactionException: JtaTransaction
could not start transaction.  Cause: 
	at
com.tgt.ecl.dao.ibatis.TgtIbatisTemplateImpl.queryForList(TgtIbatisTemplateImpl.java:192)
	at com.myself.pt.dao.xxxDAO.getItemDetails(MyMediaDAO.java:51)
	... 34 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: Error
getting Connection from Transaction.  Cause:
com.ibatis.sqlmap.engine.transaction.TransactionException: JtaTransaction
could not start transaction.  Cause: 
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:126)
	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.tgt.ecl.dao.ibatis.TgtIbatisTemplateImpl.queryForList(TgtIbatisTemplateImpl.java:190)
	... 35 more
Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException:
JtaTransaction could not start transaction.  Cause: 
	at
com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.init(JtaTransaction.java:64)
	at
com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.getConnection(JtaTransaction.java:131)
	at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	... 40 more
Caused by: java.lang.NullPointerException
	at
com.ibm.ejs.container.EJSContainer.processTxContextChange(EJSContainer.java:2202)
	at
com.ibm.ejs.container.UserTransactionWrapper.begin(UserTransactionWrapper.java:206)
	at
com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.init(JtaTransaction.java:61)
	... 42 more



Initially i thought it might be due to BigIp issue, i mean may be BigIP is
not configured properly . but later on when i deployed the same code again
with same existing BigiP configuration, what i find this time ibatis select
query is working fine in both the servers .

but  i find after some days, the same issue comes back again . 

I IBATIS ,Spring configuration  i am using JTA Transaction with Transaction
Scope as "Prototype" . 
In DAO i am not using any implicit Transaction in Java Code like "
startBatch() and executeBatch() methods.

wanted to know, does any body have any ANS to my problem  ?  after reading
though some articles on net i am thinking to add exlicit Transactions in
Java code by adding above 2 methods , not sure it will able to fix the issue
or not .

Please reply me , if some body has an ans to my problems
-- 
View this message in context: http://www.nabble.com/Ibatis-select-Query-failing-throwing--Error-getting-Connection-from-Transaction-tp24528912p24528912.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message