asked on

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

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.

ASKER CERTIFIED SOLUTION

Mick Barry

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gcr2002

ASKER

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 Barry

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).

gcr2002

ASKER

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 Barry

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");

CleanupPing

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.

Venabili

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

gcr2002

ASKER

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?