Hello,
We have and application using hibernate 3.0. We are trying to connect to a 2 Node RAC and keep on getting error ORA-17008, is there any way to handle this error, given that hibernate takes care of all the connection and we only configure the url in the hibernate.cfg.xml like this:
<property name="connection.url">
jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)(FAILOVER=on)
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=host1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=app1)))
</property>
The error we keep on getting is:
19:02:15,015 WARN JDBCExceptionReporter:57 - SQL Error: 17008, SQLState:
null
19:02:15,031 ERROR JDBCExceptionReporter:58 - Conexión cerrada
19:02:15,031 WARN JDBCExceptionReporter:57 - SQL Error: 17008, SQLState:
null
19:02:15,031 ERROR JDBCExceptionReporter:58 - Conexión cerrada
(MainService.find(Query,int,int,Hashtable)) Mensaje de Error: Could not
execute query
19:02:15,046 WARN NewPooledConnection:400 - [c3p0] A PooledConnection
that has already signalled a Connection error is still in use!
19:02:15,062 WARN NewPooledConnection:401 - [c3p0] Another error has
occurred [ java.sql.SQLException: Conexión cerrada ] which will not be
reported to listeners!
java.sql.SQLException: Conexión cerrada
Can anybody help us?
Thanks