File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "too many client tasks ?" Watch "too many client tasks ?" New topic

too many client tasks ?

Clod Patry

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
at sun.jdbc.odbc.JdbcOdbc.createSQLException(
at sun.jdbc.odbc.JdbcOdbc.standardError(
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(
at sun.jdbc.odbc.JdbcOdbcDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at jspCon.UserAccess.createConnection(
at org.apache.jsp.index_jsp._jspService(
at org.apache.jasper.runtime.HttpJspBase.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
at org.apache.jasper.servlet.JspServlet.service(
at javax.servlet.http.HttpServlet.service(

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.
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

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

[How To Ask Questions On JavaRanch]
I agree. Here's the link:
subject: too many client tasks ?
It's not a secret anymore!