tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Stokes <j_b_sto...@yahoo.co.uk>
Subject Ingres and JdbcRealm problems
Date Tue, 17 Aug 2004 09:00:50 GMT
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


Mime
View raw message