tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peng Tuck Kwok <pengt...@gmail.com>
Subject Re: Ingres and JdbcRealm problems
Date Tue, 17 Aug 2004 09:05:40 GMT
Looks like something went wrong with the sql statement. Can your jdbc
driver provide more output through some configuration ? Maybe then the
root cause can be seen.

On Tue, 17 Aug 2004 10:00:50 +0100 (BST), Ben Stokes
<j_b_stokes@yahoo.co.uk> wrote:
> Hi,
> 
> I'm currently developing a web application on Tomcat 5
> embedded in Netbeans 3.6 and connecting to an Ingres
> 2.6 database. I've setup a JdbcRealm in Tomcat to
> authenticate users against the database to allow
> access to the application and, from the outside,
> everything appears to work well with the login process
> working as it should. However, looking at the catalina
> log there are obviously problems occuring that aren't
> showing up on the web pages:-
> 
> 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception
> performing authentication
> java.sql.SQLException: line 1, The dynamically defined
> statement 'jdbc_stmt_0_0' not found.
>  Perhaps a PREPARE or DESCRIBE wasn't successful.
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509)
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348)
>         at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357)
>         at
> ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393)
>         at
> org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176)
>         at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
>         at java.lang.Thread.run(Thread.java:534)
> 
> 2004-08-17 08:22:08 JDBCRealm[Catalina]: Username
> tomcat successfully authenticated
> 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception
> performing authentication
> java.sql.SQLException: line 1, The dynamically defined
> statement 'jdbc_stmt_0_0' not found.
>  Perhaps a PREPARE or DESCRIBE wasn't successful.
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509)
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348)
>         at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357)
>         at
> ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393)
>         at
> org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176)
>         at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
>         at java.lang.Thread.run(Thread.java:534)
> 
> 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception
> performing authentication
> java.sql.SQLException: line 1, The dynamically defined
> statement 'jdbc_stmt_0_0' not found.
>  Perhaps a PREPARE or DESCRIBE wasn't successful.
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509)
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348)
>         at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357)
>         at
> ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393)
>         at
> org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176)
>         at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
>         at java.lang.Thread.run(Thread.java:534)
> 
> 2004-08-17 08:22:08 JDBCRealm[Catalina]: Username
> tomcat successfully authenticated
> 2004-08-17 08:22:10 JDBCRealm[Catalina]: Exception
> performing authentication
> java.sql.SQLException: line 1, The dynamically defined
> statement 'jdbc_stmt_0_0' not found.
>  Perhaps a PREPARE or DESCRIBE wasn't successful.
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509)
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348)
>         at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357)
>         at
> ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393)
>         at
> org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176)
>         at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
>         at java.lang.Thread.run(Thread.java:534)
> 
> 2004-08-17 08:22:10 JDBCRealm[Catalina]: Exception
> performing authentication
> java.sql.SQLException: line 1, The dynamically defined
> statement 'jdbc_stmt_0_0' not found.
>  Perhaps a PREPARE or DESCRIBE wasn't successful.
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509)
>         at
> ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348)
>         at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357)
>         at
> ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449)
>         at
> org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393)
>         at
> org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176)
>         at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
>         at java.lang.Thread.run(Thread.java:534)
> 
> I've searched the manual and web for 'jdbc_stmt_0_0'
> but to no avail. Has anyone got an idea as to what's
> going on?
> 
> Thanks
> 
> Ben Stokes
> 
> ___________________________________________________________ALL-NEW Yahoo! Messenger -
all new features - even more fun!  http://uk.messenger.yahoo.com
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message