This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

too many client tasks ?

 
Clod Patry
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9340
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic