hi,
i dont know whether this is right place to discuss.
i m getting
org.hibernate.TransactionException: JDBC commit failed exception when i access the methods after one day (server still running).
and if i restart the server then its working fine..
this is the my datasource configuration to connection pool configuration also.. in spring
i m using jpa.
my doubt is that connection are not getting created after some hours .
Quote:
<bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource" >
<property name="explicitCachingEnabled" value="true"/>
<property name="URL" value="jdbc:oracle:thin:@10.155.14.3:1521:SF"></property>
<property name="password" value="stg_full_srm_app"></property>
<property name="user" value="stg_full_srm_app"></property>
<property name="connectionCachingEnabled" value="true" />
<property name="connectionCacheProperties">
<props>
<prop key="MinLimit">5</prop>
<prop key="MaxLimit">50</prop>
<prop key="InitialLimit">5</prop>
<prop key="InactivityTimeout">1800</prop>
<prop key="AbandonedConnectionTimeout">900</prop>
</props>
</property>
</bean>
how actually the connection are created and pooled and getting used..?
please let me the solution .. its urgent
Thanks,
jana