Hello Justin, the error simply says that the configured number of connections is reached, so you should increase the MAXUSERTASKS parameter of the database.
( http://www.sapdb.org/htmhelp/84/d8d198570411d4aa82006094b92fad/content.htm ) Evaluate how much parallel sessions you need, and change it appropriately. Note that overestimating may lead to a performance degrade, as memory consumption increases by increasing this number. Unfortunately you have to stop and restart the database after the parameter change. Also, of course, you may add functionality to your program to check how many parallel connections you are doing, to avoid that the application breaks down under the load instead of rejecting users if there are too many. Don't know whether there is something like this already in Tomcat, so please look there. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:JStanczak@;vinu.edu] > Sent: Thursday, October 24, 2002 4:01 PM > To: [EMAIL PROTECTED] > Subject: Help - SAP DBTech JDBC: Cannot connect to > jdbc:sapdb://hostname/VUDMS [Tasklimit] ! > > > I'm getting this error now that my database is under some > load. I'm not > sure how to fix this yet. I was wondering if someone had a > quick answer for > me on this issue. I'm thinking it has something to do with > the user that > the JDBC driver is using to connect and is limited on the number of > connections that it can have at once. Below is the error I'm > getting. I'm > running a Solaris 8 Sparc as the database server and the app > server that's > connecting to this database with JDBC is Tomcat 4. > > [DEFAULT] ERROR: Error getting Connection from DriverManager with url > (jdbc:sapdb://localhost/VUDMS) and driver > (com.sap.dbtech.jdbc.DriverSapDB) > SAP DBTech JDBC: Cannot connect to jdbc:sapdb://159.218.3.19/VUDMS > [Tasklimit] > com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP > DBTech JDBC: Cannot > connect to jdbc:sapdb://159.218.3.19/VUDMS [Tasklimit] > at > com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:150) > at > java.sql.DriverManager.getConnection(DriverManager.java:512) > at > java.sql.DriverManager.getConnection(DriverManager.java:171) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl > .getConnectionFromDriverManager(ConnectionFactoryDefaultImpl.java:161) > [org.apache.ojb.broker.accesslayer.StatementsForClass] ERROR: > OJB Error: > could not obtain a Connection at > org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl > .newConnection(ConnectionFactoryDefaultImpl.java:204) > at > org.apache.ojb.broker.accesslayer.ConnectionManager.getNewConn > ection(ConnectionManager.java:163) > > > > Thank You, > > Justin A. Stanczak > Web Manager > Shake Learning Resource Center > Vincennes University > (812)888-5813 > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
