ODP: JDBCRealm reconnect problems?
i had a similar problem and solved it by changing connectionURL to: connectionURL="jdbc:mysql://localhost/dbase?user=somebodyamp;password=secre t" and commenting connectionName and Password. vVolf -Oryginalna wiadomooe- Od: Vladimir Grishchenko [mailto:[EMAIL PROTECTED]] Wysano: 16 marca 2001 20:45 Do: [EMAIL PROTECTED] Temat: JDBCRealm reconnect problems? Has anyone experienced JDBCReconnect problems??? Looks like mysql db connection times out and JDBCRealm cannot reopen it for some reason. Actually it tries to reopen it and somehow is able to authenticate a user, but then dies completely... Any ideas what can be wrong? This is the error/exceptions from tomcat log file: 2001-03-16 11:20:33 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:33 - ContextManager: JDBCRealm: There was an SQLException while in authenticate: null 2001-03-16 11:20:33 - ContextManager: JDBCRealm: SQLException: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException 2001-03-16 11:20:38 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:38 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT password FROM profiles WHERE username = ? 2001-03-16 11:20:38 - ContextManager: JDBCRealm: Authentication unsuccessful for user null 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Authentication successful for user Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Auth ok, user=Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Controled access for Walter R( /ngs_web + /entering/buttons.jsp + null) Ct (jsp(org.apache.jasper.servlet.JspServlet/null) ) 2001-03-16 11:20:47 - ContextManager: JDBCRealm: There was an SQLException while in getUserRoles: Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: SQLException: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Auth ok, user has no roles 2001-03-16 11:20:47 - ContextManager: JDBCRealm: UnAuthorized Y 2001-03-16 11:20:55 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:55 - Ctx( /ngs_web ): Exception in: R( /ngs_web + /entering/buttons.jsp + null) - java.lang.NullPointerException at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatem ent.java:198) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:307) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:482) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextMa nager.java:837) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:503) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManag er.java:855) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:789) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin t.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo ol.java:498) at java.lang.Thread.run(Thread.java:498) 2001-03-16 11:21:00 - Ctx( /ngs_web ): Exception in: R( /ngs_web + /display/ngs_home.jsp + null) - javax.servlet.ServletException at java.lang.Throwable.init(Throwable.java:96) at java.lang.Exception.init(Exception.java:44) at javax.servlet.ServletException.init(ServletException.java:161) at org.apache.jasper.runtime.PageContextImpl.handlePageException( PageContextImpl.java:459) at display._0002fdisplay_0002fngs_0005fhome_0002ejspngs_0005fhome _jsp_4._jspService(_0002fdisplay_0002fngs_0005fhome_0002ejspng s_0005fhome_jsp_4.java:2404) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service (JspServlet.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet .java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper .java:404) at
Re: ODP: JDBCRealm reconnect problems?
Hi, I've had this as well. Solved it by customising JDBCRealm to use database connection pooling - perhaps a little heavy handed ;-). As far as I could make out the problem seemed to be related to the wait_timout variable set to 28800 by default. According to earlier posts 1) This bug is fixed in 3.2.2. , 3.3 and 4.0 2) Can also be solved by adding ;autoreconnect=true to the db connect string (haven't tried this myself) Andrew On Mon, 19 Mar 2001, you wrote: i had a similar problem and solved it by changing connectionURL to: connectionURL="jdbc:mysql://localhost/dbase?user=somebodyamp;password=secre t" and commenting connectionName and Password. vVolf -Oryginalna wiadomooeæ- Od: Vladimir Grishchenko [mailto:[EMAIL PROTECTED]] Wys³ano: 16 marca 2001 20:45 Do: [EMAIL PROTECTED] Temat: JDBCRealm reconnect problems? Has anyone experienced JDBCReconnect problems??? Looks like mysql db connection times out and JDBCRealm cannot reopen it for some reason. Actually it tries to reopen it and somehow is able to authenticate a user, but then dies completely... Any ideas what can be wrong? This is the error/exceptions from tomcat log file: 2001-03-16 11:20:33 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:33 - ContextManager: JDBCRealm: There was an SQLException while in authenticate: null 2001-03-16 11:20:33 - ContextManager: JDBCRealm: SQLException: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException 2001-03-16 11:20:38 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:38 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT password FROM profiles WHERE username = ? 2001-03-16 11:20:38 - ContextManager: JDBCRealm: Authentication unsuccessful for user null 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Authentication successful for user Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Auth ok, user=Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Controled access for Walter R( /ngs_web + /entering/buttons.jsp + null) Ct (jsp(org.apache.jasper.servlet.JspServlet/null) ) 2001-03-16 11:20:47 - ContextManager: JDBCRealm: There was an SQLException while in getUserRoles: Walter 2001-03-16 11:20:47 - ContextManager: JDBCRealm: SQLException: java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException 2001-03-16 11:20:47 - ContextManager: JDBCRealm: Auth ok, user has no roles 2001-03-16 11:20:47 - ContextManager: JDBCRealm: UnAuthorized Y 2001-03-16 11:20:55 - ContextManager: JDBCRealm: The database connection is null or was found to be closed. Trying to re-open it. 2001-03-16 11:20:55 - Ctx( /ngs_web ): Exception in: R( /ngs_web + /entering/buttons.jsp + null) - java.lang.NullPointerException at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatem ent.java:198) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:307) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:482) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextMa nager.java:837) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:503) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManag er.java:855) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:789) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin t.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo ol.java:498) at java.lang.Thread.run(Thread.java:498) 2001-03-16 11:21:00 - Ctx( /ngs_web ): Exception in: R( /ngs_web + /display/ngs_home.jsp + null) - javax.servlet.ServletException at java.lang.Throwable.init(Throwable.java:96) at java.lang.Exception.init(Exception.java:44) at javax.servlet.ServletException.init(ServletException.java:161) at org.apache.jasper.runtime.PageContextImpl.handlePageException( PageContextImpl.java:459) at display._0002fdisplay_0002fngs_0005fhome_0002ejspngs_0005fhome _jsp_4._jspService(_0002fdisplay_0002fngs_0005fhome_0002ejspng s_0005fhome_jsp_4.java:2404) at