java - hibernate how to set SQL state =null -

java - hibernate how to set SQL state =null -

i'm working on struts 2 framework hibernate 3.3. db oracle 11g ojdbc6 driver. project working fine since lastly 5 months. nowadays faces next problem frequently.

first error is

java.sql.sqlrecoverableexception: closed connection 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ oracle.jdbc.driver.physicalconnection.needline(physicalconnection.java:5389) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ oracle.jdbc.driver.oraclestatement.closeorcache(oraclestatement.java:1578) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ oracle.jdbc.driver.oraclestatement.close(oraclestatement.java:1563) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ oracle.jdbc.driver.oraclestatementwrapper.close(oraclestatementwrapper.java:94) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ oracle.jdbc.driver.oraclepreparedstatementwrapper.close(oraclepreparedstatementwrapper.java:80) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.jdbc.abstractbatcher.closepreparedstatement(abstractbatcher.java:563) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.jdbc.abstractbatcher.closestatement(abstractbatcher.java:291) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.jdbc.abstractbatcher.closequerystatement(abstractbatcher.java:307) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.jdbc.abstractbatcher.closequerystatement(abstractbatcher.java:234) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.loader.loader.getresultset(loader.java:1826) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) @ org.hibernate.loader.hql.queryloader.iterate(queryloader.java:427) 11:42:35,742 error [stderr] (http-/0.0.0.0:8080-8) ... 75 more

then maintain on coming follwing error...

22:06:37,001 warn [org.hibernate.util.jdbcexceptionreporter](http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,002 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,002 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,002 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,002 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,002 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,003 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,003 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,011 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,011 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,011 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,012 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection 22:06:37,012 warn [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) sql error: 17008, sqlstate: null 22:06:37,012 error [org.hibernate.util.jdbcexceptionreporter] (http-/0.0.0.0:8079-11) closed connection

my hibernate configuration

<session-factory> <property name="hibernate.current_session_context_class"> thread </property> <!-- <property name="hibernate.show_sql">true</property> --> <property name="hibernate.generate_statistics">true</property> <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl </property> <property name="connection.username">user</property> <property name="connection.password">user</property> <property name="connection.driver_class"> oracle.jdbc.oracledriver </property> <property name="myeclipse.connection.profile">oracle</property> <property name="dialect"> org.hibernate.dialect.oracle10gdialect</property> </session-factory>

so trace issue i'd create sqlstate: null manually. please help me solve issue.

java oracle hibernate