• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

too many client tasks ?

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 9626
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic