We're developing a product with the Java Servlet technology, and we're
having major problems with the connections to MS SQL Server. Our
previous customers have used Oracle as database product and there was no
problems with that. However, the current customer wants to use MS SQL
Server so we used Suns sun.jdbc.odbc.JdbcOdbcDriver and suddenly we got
SQLExceptions about every second access saying "The connection is busy
with another statement". This is a bit odd because the Connection object
is synchronized, thus the requests should be queued in a fashionable
order. Anybody have a clue?

/Chris
_________________________________________________________________
Christer Holm, Technical Director

Phone:+46-31-7432105 Cell:+46-708-849464 Fax:+46-31-7432101
Postal: IH Gbg AB, Skeppsbron 5-6, S-411 21 Gothenburg Sweden
_________________________________________________________________

Take a look at http://www.***.com/ for a
free database pool.

Aaron

--
__________________________________________________________
Aaron Porter               ICQ - 1585210
CTO {*filter*} Centers, Inc.    http://www.{*filter*}centers.com

JSQuery is a Servlet that dynamically creates HTML from
scripts on the server. It can be used to connect to any
JDBC supported database to publish your data on the web.

Get your FREE trial version at http://www.***.com/
__________________________________________________________

On Fri, 29 May 1998 21:37:29 -0700, "Aaron Porter"

Jim
who'd be getter a much better salary if he spoke for his company.

the WebLogic type 2 or type 4 JDBC drivers for MS SQL Server
will do the trick for you. http://www.weblogic.com

--bob pasker

Well, I am quite not sure if this would be help or not but I used to have
this problem too. In that time, I declare the Connection object as the
static. I try to close the connection and reopen new connection via the same
object. However,that object is not closed although I've already stated to
close the connection in the code. Finally, when I take the "static" out from
the declaration, it's worked.
Hope this may help,
Apichat Banyatsupasil