SQL Error: 17008, SQLState: null
807977Dec 20 2010 — edited Dec 24 2010Dear All,
We are facing some connectivity problems in our production systems.
Oracle RAC
Oracle Version : 10.2.0.4
OS : Solaris 10
Application team uses JDBC connectivity to connect to database and using java hibernate code for testing.
The connectivity works perfect for some hours and suddenly there arises an error.
The error is as follows.
WARNING: SQL Error: 17008, SQLState: null
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Closed Connection
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17008, SQLState: null
Dec 16, 2010 4:35:10 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Closed Connection
org.hibernate.exception.GenericJDBCException: could not execute query
at com.sa.loungefinder.datalayer.ManageUsersLogic.getLoginDetails(ManageUsersLogic.java:75)
at com.sa.loungefinder.helper.user.ManageUserDelegate.getLoginDetails(ManageUserDelegate.java:46)
at com.sa.loungefinder.action.LoginAction.execute(LoginAction.java:100)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:249)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:870)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Kindy provide us some suggestions to eradicate the above error.
Thanks in advance.
Baalaaje.