Here are the logs :
2001-04-05 08:02:18 - ContextManager: JDBCRealm: The database connection is
null or was found to be closed. Trying to
re-open it.
2001-04-05 08:02:18 - ContextManager: JDBCRealm: Auth ok, first
role=cap_acheteur
_conn != null
Sql query :
select * from role
2001-04-06 09:43:29 - ContextManager: Error mapping the request R( /capimmo
+ /my/ + null) 302
2001-04-06 09:43:29 - Ctx( /capimmo ): Handler
tomcat.redirectHandler(null/null) tomcat.redirectHandler
2001-04-06 09:43:29 - ContextManager: Authorize status 401
2001-04-06 09:43:29 - ContextManager: Authorize error R( /capimmo +
/my/index.jsp + null) 401
2001-04-06 09:43:29 - Ctx( /capimmo ): Handler
tomcat.formAuthHandler(null/null)
tomcat.formAuthHandler
2001-04-06 09:43:29 - Ctx( /capimmo ): Handler
tomcat.redirectHandler(null/null) tomcat.redirectHandler
2001-04-06 09:43:29 - ContextManager: Authorize status 401
2001-04-06 09:43:29 - ContextManager: Authorize status 401
2001-04-06 09:43:29 - ContextManager: Authorize status 401
2001-04-06 09:43:29 - ContextManager: Authorize status 401
2001-04-06 09:43:36 - Ctx( /capimmo ): Handler
tomcat.redirectHandler(null/null) tomcat.redirectHandler
2001-04-06 09:43:36 - ContextManager: JDBCRealm: The database connection is
null or was found to be closed. Trying to
re-open it.
java.io.IOException: Broken pipe
at java.net.SocketOutputStream.socketWrite(Native Method)
at java.net.SocketOutputStream.write(SocketOutputStream.java:83)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:72)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:130)
at java.io.DataOutputStream.flush(DataOutputStream.java:104)
at org.gjt.mm.mysql.MysqlIO.send(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at
org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java)
at
org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:299)
at
org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:453)
at
org.apache.tomcat.core.ContextManager.doAuthenticate(ContextManager.java:837)
at
org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341)
at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:475)
at
org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java:855)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:789)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
2001-04-06 09:43:36 - ContextManager: JDBCRealm: There was an SQLException
while in authenticate: testAll
2001-04-06 09:43:36 - ContextManager: JDBCRealm: SQLException:
java.sql.SQLException: Communication link failure:
java.io.IOException
2001-04-06 09:43:36 - ContextManager: Authorize status 401
2001-04-06 09:43:36 - ContextManager: Authorize error R( /capimmo +
/my/index.jsp + null) 401
2001-04-06 09:43:36 - Ctx( /capimmo ): Handler
tomcat.formAuthHandler(null/null) tomcat.formAuthHandler
2001-04-06 09:43:36 - Ctx( /capimmo ): Handler
tomcat.redirectHandler(null/null) tomcat.redirectHandler
2001-04-06 09:43:37 - ContextManager: Authorize status 401
2001-04-06 09:43:37 - ContextManager: Authorize status 401
2001-04-06 09:43:37 - ContextManager: Authorize status 401
2001-04-06 09:43:37 - ContextManager: Authorize status 401
I wonder, in my project I use a database Pooling from tableGenerator
(http://freespace.virgin.net/joe.carter/TableGen/index.html)
that use 2 class :
DbGlobal And DatabaseAccess that use org.ewin.sql.* pakadges;
the line
" _conn != null
Sql query :
select * from role"
came from my debugge variable, it means that theis was a sql query
It seams to me that the session never ends.
and that it broke the pipe in the end.
Could you help me ??
At 13:13 04/04/2001 +0200, you wrote:
>Please some logs, config files..every bit of info you can send will be
>useful trying to find that.. attached files better..
>
>Versions of JDBC drivers & db too
>
>TIA
>
>Saludos ,
>Ignacio J. Ortega
>
>
> > -----Mensaje original-----
> > De: Kaneda K [mailto:[EMAIL PROTECTED]]
> > Enviado el: miércoles 4 de abril de 2001 13:02
> > Para: [EMAIL PROTECTED]
> > Asunto: JDBCReamls Still freeze after 24 hours wokrs
> >
> >
> >
> > Hello, I upgrade my tomcat to 3.2.2 beta 6 (BTW how to check
> > version when
> > you did not downloaded it yourself ?) and the JDBCReamls
> > still freeze
> > after 24 hours.
> >
> > on
> > redhat 6.2
> > jdk sun 1.3.0
> > 256 mo Ram
> >
> > the package I download was at this url :
> >
> > http://jakarta.apache.org/builds/jakarta-tomcat/release/v3.2.2
> > -beta-2/bin/jakarta-tomcat-3.2.2b2.zip
> >
> >