Hibernate version: 2.1.3
Name and version of the database you are using: Oracle 9i
Hi,
I have found problems when trying to connect to Oracle 9i when my application is clustered into 2 nodes. From one node all things seems to work fine, but I've experienced troubles when trying to connect from the other IP. All the configuration in both nodes are exactly the same.
The fact is that the application works fine when stands alone or is deployed in non-clusted webapp server, which is a
WebSphere App. Server 4.0, but not have a connection pool, since the connection is completely managed from the configuration of the
hibernate.cfg.xml
Code:
<session-factory>
<property name="connection.username">[i]user[/i]</property>
<property name="connection.password">[i]pwd[/i]</property>
<property name="connection.url">[i]url[/i]</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
When connecting, the following error appears:
Code:
[25/Jan/2005 13:15:47] WARN Servlet.Engine.Transports:50 net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1012, SQLState: 72000
[25/Jan/2005 13:15:47] ERROR Servlet.Engine.Transports:50 net.sf.hibernate.util.JDBCExceptionReporter - ORA-01012: not logged on
[25/Jan/2005 13:15:47] WARN Servlet.Engine.Transports:50 net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1012, SQLState: 72000
[25/Jan/2005 13:15:47] ERROR Servlet.Engine.Transports:50 net.sf.hibernate.util.JDBCExceptionReporter - ORA-01012: not logged on
[25/Jan/2005 13:15:47] ERROR Servlet.Engine.Transports:50 net.sf.hibernate.util.JDBCExceptionReporter - SQLException occurred
java.sql.SQLException: ORA-01012: not logged on
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:120)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:223)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:121)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3604)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at com.gedas.mivo.modelo.mgr.UsuariosMgr.getAutentificacion(UsuariosMgr.java:57)
at com.gedas.mivo.modelo.mgr.LoginMgr.authenticateToMivo(LoginMgr.java:76)
at com.gedas.mivo.actions.LoginAction.execute(LoginAction.java:78)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:477)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:351)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
I've checked all the transactions and there is always a session.close to prevente from connection leaking.
Any clue?
Regards
Login
FAQ
Search
