Connection/JDBC/MS SQL Server 
Author Message
 Connection/JDBC/MS SQL Server

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
_________________________________________________________________



Tue, 14 Nov 2000 03:00:00 GMT
 Connection/JDBC/MS SQL Server

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/
__________________________________________________________

Quote:

>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
>_________________________________________________________________



Tue, 14 Nov 2000 03:00:00 GMT
 Connection/JDBC/MS SQL Server

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

Quote:

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

This is an excellent answer, but I'd also like to stress that you
should STRONGLY consider using something other than the jdbc-odbc
bridge for production code.  It's just not a good idea...

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



Wed, 15 Nov 2000 03:00:00 GMT
 Connection/JDBC/MS SQL Server

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

Quote:

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

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

> This is an excellent answer, but I'd also like to stress that you
> should STRONGLY consider using something other than the jdbc-odbc
> bridge for production code.  It's just not a good idea...

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



Thu, 16 Nov 2000 03:00:00 GMT
 Connection/JDBC/MS SQL Server

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



Sun, 19 Nov 2000 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. JDBC Connection to MS SQL Server 2000

2. JDBC connection to MS SQL Server with Windows NTLM Authentication

3. Applet, JDBC-ODBC and MS ACCESS and MS SQL server

4. JDBC-Like pure java class to connect to Ms Sql Server or Ms Access

5. MS SQL Connection Error with JDBC

6. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

7. Configuring SQL.INI For Connection To MS SQL Server

8. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

9. GA-Alpharetta-110503--MS SQL Server-DBA Skills-Database Administrator (DBA)-MS SQL Server

10. JDBC to MS SQL Server

11. Applet to MS SQL Server 6.5 via JDBC

12. JDBC - MS SQL Server Stored Procedure problems


 
Powered by phpBB® Forum Software