aspose file tools*
The moose likes JDBC and the fly likes too many client tasks ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "too many client tasks ?" Watch "too many client tasks ?" New topic
Author

too many client tasks ?

Clod Patry
Greenhorn

Joined: Nov 21, 2003
Posts: 9
hi guys, im running my application, and after a certain interraction with the DB, im getting this error:
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
and this is the rest:
this session's page (sessions) was succesfully added to session 262
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many client
tasks.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
23)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jspCon.UserAccess.createConnection(UserAccess.java:42)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:405)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
95)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
.....

how can i solve it ?
i NEED to use Access and java, so dont tell me to use mysql please.
the client wants it, and i've previously talk about the possibility of mysql, he rejected it.
Thanks
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8927
    
    9

Originally posted by Clod Patry:

[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Given this much information I'd say you are either:
(A) not calling close() on your ResultSet, Statement and Connection objects. If these objects are not properly cleaned up they will not be garbage collected and your database will eventually run out of resources
(B) Using the JDBC-ODBC bridge to get to Access and trying to use Access like a full-featured SQL database (i.e. trying to hit it concurrently with multiple clients). The JDBC-ODBC bridge is not for use in production environments. Read the
JDBC FAQ


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
 
jQuery in Action, 2nd edition
 
subject: too many client tasks ?