Hai I am using Tomcat server as webserver and SQL Server as database server. Both reside at same. And I am using applets to get data. First time when i am opening in the browser i am getting data perfectly. If i am opening the same page in another page it is showing SQL Excepttion: Too many connections. What i am doing is in init() method of the applet i am getting connection. In destroy() method of applet i am making connection = null.
Joined: Dec 12, 2001
Your database is set up to not allow more than one connection at a time. Presumably you have a single-user license for SQL Server. You have a couple of options: 1) Buy more SQL Server licenses. (This gets expensive really fast, particularly if you have a large user population who might be using your applet). 2) Rearchitect the app so that something on the server is managing the database connections. Because the applet creates a connection, each instance of the applet will create a separate connection. If the applet communicated with something on the server which managed the connections, the server could create 1 connection or only a few connections and then use them to handle the requests.
Joined: Oct 31, 2002
Hai thanks for ur reply. but when i am using the same SQL server in jsp i am not getting problem After ur reply. i made 3 connection objects in the same jsp page and tried to retrive data it is worked fine but where is in applet it is showing the error.