-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: Unable to connect after an exception occurs Weblogic 9.2
PostPosted: Thu Dec 04, 2008 12:55 am 
Newbie

Joined: Thu Dec 04, 2008 12:47 am
Posts: 5
Location: San Francisco
this is my hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- properties -->
<property name="show_sql">false</property>
<property name="connection.datasource">datasource.jndi</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<!-- <property name="jta.UserTransaction">javax/transaction/UserTransaction</property> -->
<property name="jta.UserTransaction">weblogic/transaction/UserTransaction</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WeblogicTransactionManagerLookup</property>
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="hibernate.jdbc.batch_size">0</property>
<property name="hibernate.jdbc.use_streams_for_binary">true</property>
<!-- <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> -->
<!-- mapping files -->
<mapping resource="table1.hbm.xml"/>
<mapping resource="table2.hbm.xml"/>
<mapping resource="table3.hbm.xml"/>
</session-factory>
<!-- <property name="cache.use_query_cache">false</property> -->
<!-- <property name="cache.use_minimal_puts">false</property> -->
</hibernate-configuration>


and this is the insert code

public void insert(Event event throws DBException {
Session session = null;
try {
SessionFactory factory = new Configuration().configure("/hibernate.cfg.xml").buildSessionFactory();
session = factory.openSession();
org.hibernate.Transaction tx = session.beginTransaction();
session.save(event);
session.flush();
tx.commit();
//session.close();
} catch (HibernateException e) {
logger.error("Caught HibernateException in CafeAuditDAO().insert() logging before rethrow", e);
throw new DBException();
} finally {
session.close();
session = null;
}
}


everything works fine, but when a HibernateException occurs the future transactions have the following error..


org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)


i have tried all options in the datasource setting in weblogic 9.2 and going crazy....

any help appreciated....


Last edited by ehlan on Thu Dec 04, 2008 1:08 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Unable to connect after an exception occurs Weblogic 9.2
PostPosted: Thu Dec 04, 2008 1:04 pm 
Expert
Expert

Joined: Wed Apr 11, 2007 11:39 am
Posts: 735
Location: Montreal, QC
Is this all of the stack trace?



Farzad-


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 04, 2008 1:13 pm 
Newbie

Joined: Thu Dec 04, 2008 12:47 am
Posts: 5
Location: San Francisco
here are some more stacktrace..

i ran some query with exception all day yesterday, then ran some good ones and it was fine, then this morning i'm seeing connection error again with the good ones..

2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 122 seconds
BEA1-003DB87336AE5AD8D319
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1432)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1344)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:441)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:397)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:359)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)

2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - Caught HibernateException in CafeXMLDAO().insert() logging before rethrow
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 04, 2008 1:23 pm 
Expert
Expert

Joined: Wed Apr 11, 2007 11:39 am
Posts: 735
Location: Montreal, QC
These stack trace are not complete either. However, from your explanation I could assume you have some stale connections in your pool which is a rather common case most databases. They close idle connection in order to free up OS resources. In your connection pool you need to add a sql command that would be used to verify connections when they are being checked out from the pool.

On the other hand, the exception with transaction time out smells and I doubt if I can explain that one with the previous explanation. For that, you are probably running a long task and if you have things like this then you need to break them down or increase transaction time outs. If the duration is not the problem then one of your queries is locked by other queries and then you need to find out the use cases that could possibly cause this.



Farzad-


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 04, 2008 1:40 pm 
Newbie

Joined: Thu Dec 04, 2008 12:47 am
Posts: 5
Location: San Francisco
thanks Farzad, let me try setting "select count(*) from DUAL" in my weblogic Test Table Name setting.
I will keep you posted

I just took out my local code reference from the stacktrace, here is the full one

2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 122 seconds
BEA1-003DB87336AE5AD8D319
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1432)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1344)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:441)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:397)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:359)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:76)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody9$advice(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:138)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody10(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl$AjcClosure11.run(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)

2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - Caught HibernateException in CafeXMLDAO().insert() logging before rethrow
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:76)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
Caused by: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 122 seconds
BEA1-003DB87336AE5AD8D319
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1432)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1344)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:441)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:397)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:359)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:76)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody9$advice(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:138)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody10(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl$AjcClosure11.run(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)

at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1357)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:441)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:397)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:359)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:76)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody9$advice(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:138)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody10(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl$AjcClosure11.run(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.launchpad.logging.RuntimeExceptionCatcher.ajc$around$com_wellsfargo_launchpad_logging_RuntimeExceptionCatcher$1$fbf11ea4proceed(RuntimeExceptionCatcher.aj:1)
2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - com.wf.bd.cafe.util.fault.CafeDBException -- exceptionInstanceId = b5133940-c224-11dd-9942-b7961b95c435 -- stack trace=
com.wf.bd.cafe.util.fault.CafeDBException
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:82)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody9$advice(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:138)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody10(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl$AjcClosure11.run(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.launchpad.logging.RuntimeExceptionCatcher.ajc$around$com_wellsfargo_launchpad_logging_RuntimeExceptionCatcher$1$fbf11ea4proceed(RuntimeExceptionCatcher.aj:1)
at com.wellsfargo.launchpad.logging.RuntimeExceptionCatcher.ajc$around$com_wellsfargo_launchpad_logging_RuntimeExceptionCatcher$1$fbf11ea4(RuntimeExceptionCatcher.aj:54)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:131)
at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)

2008-12-04 08:58:00,353 ERROR [ EHLAN_ACAPG_12031793 JF processACAPG ] - Cafe WebService unable to write Incoming XML to database tables :
com.wf.bd.cafe.util.fault.CafeDBException
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:82)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.writeDataToTable(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:278)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody8(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:147)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody9$advice(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:138)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG_aroundBody10(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl$AjcClosure11.run(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:1)
at com.wellsfargo.launchpad.logging.RuntimeExceptionCatcher.ajc$around$com_wellsfargo_launchpad_logging_RuntimeExceptionCatcher$1$fbf11ea4proceed(RuntimeExceptionCatcher.aj:1)
at com.wellsfargo.launchpad.logging.RuntimeExceptionCatcher.ajc$around$com_wellsfargo_launchpad_logging_RuntimeExceptionCatcher$1$fbf11ea4(RuntimeExceptionCatcher.aj:54)
at com.wellsfargo.service.provider.businessDirect.cafe.fulfillmentServices.processCreditApplicationFulfillment2008.ProcessCreditApplicationFulfillmentSOAPBindingImpl.processACAPG(ProcessCreditApplicationFulfillmentSOAPBindingImpl.java:131)
at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 04, 2008 1:52 pm 
Expert
Expert

Joined: Wed Apr 11, 2007 11:39 am
Posts: 735
Location: Montreal, QC
this is quite wierd. This means that you app is taking more than 2 minutes to reach the point in which it needs to get a connection and therefor it can not register it with the transaction manager as a XA resource. If your business seriously take more than 2 minutes then you need to increase the transaction time out. At the same time, why are you using a XA connection? Couldn't you go ahead with local transactions?




Farzad-


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 05, 2008 8:09 pm 
Newbie

Joined: Thu Dec 04, 2008 12:47 am
Posts: 5
Location: San Francisco
Farzad, thanks for all your help..

i have rearranged my code, made some static calls non-static..

now i am seeing this error....I am assuming this is to do with my Oracle connection and not with hibernate?


thanks in advance..

2008-12-05 16:56:34,470 WARN [] - Could not obtain connection metadata
java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:72)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wf.bd.cafe.cms.ProcessCMS.processCMSApplication(ProcessCMS.java:208)
at com.wf.bd.cafe.jms.CafeCMSServiceBean.onMessage(CafeCMSServiceBean.java:191)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:335)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:291)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4060)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:3953)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:4467)
at weblogic.work.ServerWorkManagerImpl$WorkAdapterImpl.run(ServerWorkManagerImpl.java:518)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
2008-12-05 16:56:34,516 WARN [] - SQL Error: 17002, SQLState: null
2008-12-05 16:56:34,516 ERROR [] - Io exception: Got minus one from a read call
2008-12-05 16:56:34,516 ERROR [] - Caught HibernateException in CafeXMLDAO().insert() logging before rethrow
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at com.wf.bd.cafe.dao.CafeXMLDAO.insert(CafeXMLDAO.java:75)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:105)
at com.wf.bd.cafe.dao.CafeDBService.writeToXMLTable(CafeDBService.java:141)
at com.wf.bd.cafe.cms.ProcessCMS.processCMSApplication(ProcessCMS.java:208)
at com.wf.bd.cafe.jms.CafeCMSServiceBean.onMessage(CafeCMSServiceBean.java:191)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:429)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:335)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:291)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4060)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:3953)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:4467)
at weblogic.work.ServerWorkManagerImpl$WorkAdapterImpl.run(ServerWorkManagerImpl.java:518)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 08, 2008 3:40 pm 
Beginner
Beginner

Joined: Thu Oct 02, 2008 10:15 am
Posts: 21
Try this:
1) On you server when you configure a connection pool and datasource, there should be someting to test these settings. Try that.It looks like something to do with the specific drivers you are using.
2) Check the configuration you provided to hibernate for datasource.[jndi name etc.]

If still having issues, try to see the oracle forums where you may see this being posted or reported as a bug.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.