[SQLException:too many clients]-Can someone pls help me?

gcr2002
gcr2002 used Ask the Experts™
on
Hi ,
I am using MS access as my Database.My application is developed using java & servlets.My servlet engine is:tomcat-3.3.1.
I am getting the following error if i run my application
continuosly for 45 minutes:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Can somebody please help me on this.It's very urgent.Thanks in advance.

Regards,
Rashmi.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Java Developer
Top Expert 2010
Commented:
check that you are closing connections once you are done with them.

is anyone esle accessing the same db?

Author

Commented:
I am closing my connections properly.I am using a connection pool & i am returning the connection to the pool in the finally method of the doget method of my servlet.

Ya,this application is running on the intranet but only i m testing the application for now,so it's only me who's accessing the db.
Can me give me more tips on this please.  
Mick BarryJava Developer
Top Expert 2010

Commented:
Assuming you are the only client accessing the database it is possibly too many concurrent connection to the database. If more than one client accessing then it could be too many clients accessing database.
Check how connections u concurrently have open.

Another thing to try is if you are using a system DSN, then try doing a DSN-less connection (ie. connecting without a DSN).
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Author

Commented:
How do i connect without using a System DSN?Can u pls help me on this.How do i check if a connection is still open or closed?
Mick BarryJava Developer
Top Expert 2010

Commented:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=Test.mdb;PWD=mypass","login","password");
gcr2002:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Points for objects

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Venabili
EE Cleanup Volunteer

Author

Commented:
First of all i wud like to apologise for replying so late,the reason beign i was not accessing my mails for a long time.
I haven't resolved my problem still inspite of getting few response.I still am facing this problem.So please suggest me what do i do on this?Can i get more suggestions to resolve my problem or can i request for refund?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial