• Post Reply Bookmark Topic Watch Topic
  • New Topic

Hibernate 3 reconnecting problem with oracle 9

Srini N
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Paul Sturrock
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Srini N", please check your private messages for a message from me.
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!