Hello all:

I am experiencing strange jdbc errors. I am running tomcat 3.2.2 on win2k. I
store the request parameters from the browser into a hastable. Then I pass
the hashtable and response object to a new instance of a class. The method
in the class then queries the database if a particular user name already
exists. I tried using prepared statement as well as Statement but as soon as
I give a call to database_connection.close(), I get an SQL Exception..The
stack trac is as follows

Closing database connection....
Exception caught here!java.sql.SQLException: General error
java.sql.SQLException: General error
        at
sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2742)
        at
sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:842)
        at
sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:736)
        at dlnet.Signup.Signup_RS.check_user(Signup_RS.java:268)
        at dlnet.Signup.Signup_RS.processInformation(Signup_RS.java:183)
        at dlnet.Mediate.doPost(Mediate.java:114)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
        at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
        at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
        at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)

This subsequently causes tomcat to crash occasianally....it also produces a
log file..

Can someone explain why this is happening? I am using Microsoft Access 2000
Database

Thanks
Prashanth


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Reply via email to