Hi
I am getting Exception while reconnecting to the Oracle database.with Hibernate 3. I was getting this problem when Data Base server restarts. its start working when
restartig the application server.
Here is the error message I am getting in logs
JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 17002, SQLState: null
JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions Io exception: The Network Adapter could not establish the connection
SQL Error: 17002, SQLState: null
0000039 JDBCException E Io exception:n reset by peer: socket write error
I tried to solve the problem as following way to configure hibernate.hbm.xml
<property name="hibernate.connection.pool_size">0</property>
<property name="preferredTestQuery" >"select 1 from dual"></property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.timeout">100</property>
<property name="hibernate.c3p0.initialPoolSize">20</property>
<property name="hibernate.c3p0.maxPoolSize">20</property>
<property name="hibernate.c3p0.maxIdleTime">300</property>
<property name="hibernate.c3p0.maxStatements">50</property>
<property name="hibernate.c3p0.minPoolSize">10</property>
<property name="hibernate.c3p0.testOnBorrow">true</property>
But Still I am getting same problem? Can any one help me to solve this problem
