Posted By:
Derek_Illchuk
Posted On:
Saturday, March 16, 2002 12:42 PM
I am developing a JSP internet database application, and am currently stuck with using Access 2000 (until I decide to shell out more cash to get a provider with JSP and MySQL). I am using the JDBC-ODBC driver that comes with Java2. I have been noticing problems when having more than one session open at a time. When closing a connection, a SQLException: General Error is sometimes thrown. The connection does indeed close, but I get the exception. So far, I can keep these exceptions well-handled as to not affect the actual operation of my application, but am not sure of the effects with, say, 20 concurrent sessions. In your humble opinion, if I stick with this setup, am I basically holding on to a sinking ship? Or can I manage? P.S.
More>>
I am developing a JSP internet database application, and am currently stuck with using Access 2000 (until I decide to shell out more cash to get a provider with JSP and MySQL). I am using the JDBC-ODBC driver that comes with Java2.
I have been noticing problems when having more than one session open at a time. When closing a connection, a SQLException: General Error is sometimes thrown. The connection does indeed close, but I get the exception. So far, I can keep these exceptions well-handled as to not affect the actual operation of my application, but am not sure of the effects with, say, 20 concurrent sessions.
In your humble opinion, if I stick with this setup, am I basically holding on to a sinking ship? Or can I manage?
P.S. Anybody know about any free JDBC-ODBC drivers meant for internet-use out there?
Derek
<<Less
