Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate 3 reconnecting problem with oracle 9

 
Srini N
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Sturrock
Bartender
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic