Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.x

Full stack trace of any exception that occurs:

java.rmi.RemoteException: SOAP Fault:javax.xml.rpc.soap.SOAPFaultException: Exception during processing: org.hibernate.HibernateException: Not able to obtain connection (see Fault Detail for stacktrace)
Detail:
<detail>
<bea_fault:stacktrace xmlns:bea_fault="http://www.bea.com/servers/wls70/webservice/fault/1.0.0">org.hibernate.HibernateException: Not able to obtain connection
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:113)
at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:82)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
at ru.lanit.eccp.dao.ReferenceDaoImpl.saveTimeZone(ReferenceDaoImpl.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy98.saveTimeZone(Unknown Source)
at ru.lanit.eccp.service.ReferenceServiceImpl.createAndSaveTimeZone(ReferenceServiceImpl.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy103.createAndSaveTimeZone(Unknown Source)
at ru.lanit.eccp.sc.service.ProvisioningServiceImpl.createAccountWithCreateTimeZone(ProvisioningServiceImpl.java:137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy107.createAccountWithCreateTimeZone(Unknown Source)
at ru.lanit.eccp.sc.ws.ProvisioningWs.createAccountWithCreateTimeZone(ProvisioningWs.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.webservice.component.javaclass.JavaClassInvocationHandler.invoke(JavaClassInvocationHandler.java:133)
at weblogic.webservice.core.handler.InvokeHandler.handleRequest(InvokeHandler.java:104)
at weblogic.webservice.core.HandlerChainImpl.handleRequest(HandlerChainImpl.java:143)
at weblogic.webservice.core.DefaultOperation.process(DefaultOperation.java:535)
at weblogic.webservice.server.Dispatcher.process(Dispatcher.java:204)
at weblogic.webservice.server.Dispatcher.doDispatch(Dispatcher.java:176)
at weblogic.webservice.server.Dispatcher.dispatch(Dispatcher.java:96)
at weblogic.webservice.server.WebServiceManager.dispatch(WebServiceManager.java:100)
at weblogic.webservice.server.servlet.WebServiceServlet.serverSideInvoke(WebServiceServlet.java:297)
at weblogic.webservice.server.servlet.ServletBase.doPost(ServletBase.java:485)
at weblogic.webservice.server.servlet.WebServiceServlet.doPost(WebServiceServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6718)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
</bea_fault:stacktrace>
</detail>; nested exception is:
javax.xml.rpc.soap.SOAPFaultException: Exception during processing: org.hibernate.HibernateException: Not able to obtain connection (see Fault Detail for stacktrace)
at ru.lanit.eccp.sc.ws.client.ProvisioningWsPort_Stub.createAccountWithCreateTimeZone(ProvisioningWsPort_Stub.java:310)
at Test.main(Test.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: javax.xml.rpc.soap.SOAPFaultException: Exception during processing: org.hibernate.HibernateException: Not able to obtain connection (see Fault Detail for stacktrace)
at weblogic.webservice.core.ClientDispatcher.receive(ClientDispatcher.java:313)
at weblogic.webservice.core.ClientDispatcher.dispatch(ClientDispatcher.java:144)
at weblogic.webservice.core.DefaultOperation.invoke(DefaultOperation.java:457)
at weblogic.webservice.core.DefaultOperation.invoke(DefaultOperation.java:443)
at weblogic.webservice.core.rpc.StubImpl._invoke(StubImpl.java:303)
at ru.lanit.eccp.sc.ws.client.ProvisioningWsPort_Stub.createAccountWithCreateTimeZone(ProvisioningWsPort_Stub.java:298)
... 6 more

Name and version of the database you are using: Oracle 9.x

Hi to all!

This is a part of my application:

<beans>

<bean id="referenceDaoTarget" class="ru.lanit.eccp.dao.ReferenceDaoImpl">
<property name="sessionFactory">
<ref local="sf"/>
</property>
</bean>

<bean id="referenceDao" parent="tp">
<property name="proxyInterfaces">
<value>ru.lanit.eccp.dao.ReferenceDao</value>
</property>
<property name="target">
<ref local="referenceDaoTarget"/>
</property>
</bean>

<bean id="tp" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true" >
<property name="transactionManager">
<ref bean="tm"/>
</property>

<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_REQUIRED,readOnly,timeout_600</prop>
<prop key="find*">PROPAGATION_REQUIRED,readOnly,timeout_600</prop>
<prop key="save*">PROPAGATION_REQUIRED,timeout_600</prop>
<prop key="assign*">PROPAGATION_REQUIRED,timeout_600</prop>
<prop key="check*">PROPAGATION_REQUIRED,timeout_600</prop>
<prop key="createAndSave*">PROPAGATION_REQUIRES_NEW,timeout_600</prop>
<prop key="delete*">PROPAGATION_REQUIRED,timeout_600</prop>
<prop key="change*">PROPAGATION_REQUIRED,timeout_600</prop>
<prop key="import*">PROPAGATION_REQUIRED,timeout_600</prop>
</props>
</property>
<property name="proxyTargetClass">
<value>false</value>
</property>
</bean>

<!-- Services -->
<bean id="provisioningServiceTarget" class="ru.lanit.eccp.sc.service.ProvisioningServiceImpl">
<property name="subscriberDao">
<ref bean="subscriberDao"/>
</property>
<property name="subscriberService">
<ref bean="subscriberService"/>
</property>
<property name="referenceDao">
<ref bean="referenceDao"/>
</property>
<property name="systemDao">
<ref bean="systemDao"/>
</property>
<property name="referenceService">
<ref bean="referenceService"/>
</property>
<property name="beeServiceDao">
<ref bean="beeServiceDao"/>
</property>
<property name="beeServiceService">
<ref bean="beeServiceService"/>
</property>
</bean>

<bean id="provisioningService" parent="tp">
<property name="proxyInterfaces">
<value>ru.lanit.eccp.sc.service.ProvisioningService</value>
</property>
<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_REQUIRED,readOnly,timeout_600,-WsException</prop>
<!--<prop key="*">PROPAGATION_REQUIRED,timeout_600,-WsException</prop>-->
<prop key="createAccount">PROPAGATION_REQUIRED,timeout_600,-WsException</prop>
<prop key="createAccountWithCreateTimeZone">PROPAGATION_NEVER</prop>
</props>
</property>
<property name="target">
<ref local="provisioningServiceTarget"/>
</property>
</bean>
</beans>

public int createAccountWithCreateTimeZone(String msisdn, AccountDetails detail, String user) throws DuplicateSubscriberWsException, NoSuchElementWsException, IllegalArgumentWsException {
System.out.println("++++++++++++++++++++++++++++++++createAccountWithCreateTimeZone++++++++++++++++++++++++++++++++++++++++++++");
System.out.println(TransactionHelper.getTransactionHelper().getTransaction());
System.out.println("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");
try {
ScServiceLocator.getProvisioningService().createAccount(msisdn,detail,user);
} catch(NoSuchTimeZoneWsException e) {
AccountParam[] params = detail.getParams();
for (int i = 0; i < params.length; i++) {
AccountParam param = params[i];
if (ScWsConst.ACCOUNT_PARAM_NAME_MARKET_CODE.equals(param.getName())) {
referenceService.createAndSaveTimeZone(param.getValue(),Configuration.getInstance().getTimeShiftDefault(),user);
return ScWsConst.RC_TIME_ZONE_CREATED;
}
}
throw e;
}
return ScWsConst.RC_OK;
}

... and ru.lanit.eccp.dao.ReferenceDao.saveTimeZone is invoked inside of createAndSaveTimeZone().

This is the full log:

92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for ru.lanit.eccp.sc.service.ProvisioningService.createAccountWithCreateTimeZone
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@147e585]
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Initializing transaction synchronization
++++++++++++++++++++++++++++++++createAccountWithCreateTimeZone++++++++++++++++++++++++++++++++++++++++++++
null
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'provisioningService'
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Bean with name 'provisioningService' is a factory bean
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for ru.lanit.eccp.sc.service.ProvisioningService.createAccount
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@1485de]
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Creating new transaction with name [ru.lanit.eccp.sc.service.ProvisioningService.createAccount]
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Beginning JTA transaction
++++++++++++++++++++++++++++++++createAccount++++++++++++++++++++++++++++++++++++++++++++
Name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount,Xid=BEA1-001C727E69B4(23117093),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=600,activeThread=Thread[ExecuteThread: '12' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],SCInfo[eccpDevDomain+eccpDevServer]=(state=active),properties=({weblogic.transaction.name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=eccpDevServer+172.16.25.79:7001+eccpDevDomain+t3+, XAResources={},NonXAResources={})])
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++toSubscriberParam++++++++++++++++++++++++++++++++++++++++++++
Name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount,Xid=BEA1-001C727E69B4(23117093),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=600,activeThread=Thread[ExecuteThread: '12' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],SCInfo[eccpDevDomain+eccpDevServer]=(state=active),properties=({weblogic.transaction.name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=eccpDevServer+172.16.25.79:7001+eccpDevDomain+t3+, XAResources={},NonXAResources={})])
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for ru.lanit.eccp.dao.ReferenceDao.findTimeZone
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@1b7b4bd]
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Participating in existing transaction
++++++++++++++++++++++++++++++++findTimeZone++++++++++++++++++++++++++++++++++++++++++++
Name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount,Xid=BEA1-001C727E69B4(23117093),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=600,activeThread=Thread[ExecuteThread: '12' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],SCInfo[eccpDevDomain+eccpDevServer]=(state=active),properties=({weblogic.transaction.name=ru.lanit.eccp.sc.service.ProvisioningService.createAccount}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=eccpDevServer+172.16.25.79:7001+eccpDevDomain+t3+, XAResources={},NonXAResources={})])
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
92613 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.orm.hibernate3.SessionFactoryUtils - Opening Hibernate Session
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.JDBCContext - successfully registered Synchronization
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - opened session at timestamp: 4637208766066688
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.orm.hibernate3.SessionFactoryUtils - Registering Spring transaction synchronization for new Hibernate Session
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Bound value [org.springframework.orm.hibernate3.SessionHolder@1bae633] for key [org.hibernate.impl.SessionFactoryImpl@86c8b4] to thread [ExecuteThread: '12' for queue: 'weblogic.kernel.Default']
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bae633] for key [org.hibernate.impl.SessionFactoryImpl@86c8b4] bound to thread [ExecuteThread: '12' for queue: 'weblogic.kernel.Default']
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - find: from time_zone tz where tz.marketCode = :marketCode
92629 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.engine.QueryParameters - named parameters: {marketCode=888}
92644 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.hql.classic.QueryTranslatorImpl - compiling query
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.hql.classic.QueryTranslatorImpl - HQL: from time_zone tz where tz.marketCode = :marketCode
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.hql.classic.QueryTranslatorImpl - SQL: select time_zone0_.TIME_ZONE_ID as TIME1_, time_zone0_.MARKET_CODE as MARKET2_3_, time_zone0_.TIME_SHIFT as TIME3_3_, time_zone0_.CREATE_BY as CREATE4_3_, time_zone0_.CREATE_DATE as CREATE5_3_ from TIME_ZONE time_zone0_ where (time_zone0_.MARKET_CODE=? )
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.SQL - select time_zone0_.TIME_ZONE_ID as TIME1_, time_zone0_.MARKET_CODE as MARKET2_3_, time_zone0_.TIME_SHIFT as TIME3_3_, time_zone0_.CREATE_BY as CREATE4_3_, time_zone0_.CREATE_DATE as CREATE5_3_ from TIME_ZONE time_zone0_ where (time_zone0_.MARKET_CODE=? )
Hibernate: select time_zone0_.TIME_ZONE_ID as TIME1_, time_zone0_.MARKET_CODE as MARKET2_3_, time_zone0_.TIME_SHIFT as TIME3_3_, time_zone0_.CREATE_BY as CREATE4_3_, time_zone0_.CREATE_DATE as CREATE5_3_ from TIME_ZONE time_zone0_ where (time_zone0_.MARKET_CODE=? )
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
92660 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.type.StringType - binding '888' to parameter: 1
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open ResultSet (open ResultSets: 0, globally: 0)
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.loader.Loader - processing result set
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.loader.Loader - done processing result set (0 rows)
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close ResultSet (open ResultSets: 1, globally: 1)
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.ConnectionManager - closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.loader.Loader - total objects hydrated: 0
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.engine.PersistenceContext - initializing non-lazy collections
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking commit for transaction on ru.lanit.eccp.dao.ReferenceDao.findTimeZone
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Applying rules to determine whether transaction should rollback on ru.lanit.eccp.common.wsexception.NoSuchTimeZoneWsException: Can't find Time zone with Market code = [888]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Winning rollback rule is: RollbackRule with pattern [WsException]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking rollback for transaction on ru.lanit.eccp.sc.service.ProvisioningService.createAccount due to throwable [ru.lanit.eccp.common.wsexception.NoSuchTimeZoneWsException: Can't find Time zone with Market code = [888]]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Initiating transaction rollback
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Rolling back JTA transaction
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.transaction.CacheSynchronization - transaction after completion callback, status: 4
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.JDBCContext - after transaction completion
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - after transaction completion
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.transaction.CacheSynchronization - automatically closing session
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - automatically closing session
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - closing session
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for ru.lanit.eccp.service.ReferenceService.createAndSaveTimeZone
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@ac8828]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Creating new transaction with name [ru.lanit.eccp.service.ReferenceService.createAndSaveTimeZone]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Beginning JTA transaction
++++++++++++++++++++++++++++++++++createAndSaveTimeZone++++++++++++++++++++++++++++++++++++++++++
Name=ru.lanit.eccp.service.ReferenceService.createAndSaveTimeZone,Xid=BEA1-001D727E69B4(18815811),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=600,activeThread=Thread[ExecuteThread: '12' for queue: 'weblogic.kernel.Default',5,Thread Group for Queue: 'weblogic.kernel.Default'],SCInfo[eccpDevDomain+eccpDevServer]=(state=active),properties=({weblogic.transaction.name=ru.lanit.eccp.service.ReferenceService.createAndSaveTimeZone}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=eccpDevServer+172.16.25.79:7001+eccpDevDomain+t3+, XAResources={},NonXAResources={})])
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Getting transaction for ru.lanit.eccp.dao.ReferenceDao.saveTimeZone
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@a1de60]
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Participating in existing transaction
92675 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bae633] for key [org.hibernate.impl.SessionFactoryImpl@86c8b4] bound to thread [ExecuteThread: '12' for queue: 'weblogic.kernel.Default']
92691 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.event.def.AbstractSaveEventListener - transient instance of: time_zone
92691 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - saving transient instance
92691 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Applying rules to determine whether transaction should rollback on org.hibernate.HibernateException: Not able to obtain connection
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Winning rollback rule is: null
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - No relevant rollback rule found: applying superclass default
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking rollback for transaction on ru.lanit.eccp.dao.ReferenceDao.saveTimeZone due to throwable [org.hibernate.HibernateException: Not able to obtain connection]
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Participating transaction failed - marking existing transaction as rollback-only
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Setting JTA transaction rollback-only
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Applying rules to determine whether transaction should rollback on org.hibernate.HibernateException: Not able to obtain connection
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Winning rollback rule is: null
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - No relevant rollback rule found: applying superclass default
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking rollback for transaction on ru.lanit.eccp.service.ReferenceService.createAndSaveTimeZone due to throwable [org.hibernate.HibernateException: Not able to obtain connection]
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Initiating transaction rollback
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Rolling back JTA transaction
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Applying rules to determine whether transaction should rollback on org.hibernate.HibernateException: Not able to obtain connection
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - Winning rollback rule is: null
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.RuleBasedTransactionAttribute - No relevant rollback rule found: applying superclass default
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.interceptor.TransactionInterceptor - Invoking rollback for transaction on ru.lanit.eccp.sc.service.ProvisioningService.createAccountWithCreateTimeZone due to throwable [org.hibernate.HibernateException: Not able to obtain connection]
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Triggering beforeCompletion synchronization
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Removed value [org.springframework.orm.hibernate3.SessionHolder@1bae633] for key [org.hibernate.impl.SessionFactoryImpl@86c8b4] from thread [ExecuteThread: '12' for queue: 'weblogic.kernel.Default']
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.orm.hibernate3.SessionFactoryUtils - Closing Hibernate Session
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.hibernate.impl.SessionImpl - closing session
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] WARN org.springframework.transaction.jta.WebLogicJtaTransactionManager - Should roll back transaction but cannot - no transaction available
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.jta.WebLogicJtaTransactionManager - Triggering afterCompletion synchronization
92707 [ExecuteThread: '12' for queue: 'weblogic.kernel.Default'] DEBUG org.springframework.transaction.support.TransactionSynchronizationManager - Clearing transaction synchronization
96238 [Finalizer] DEBUG org.hibernate.jdbc.ConnectionManager - running Session.finalize()

The question is: why it cannot obtain connection????