You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jim Cheesman <jc...@msl.es> on 2001/10/17 09:09:08 UTC

Re: Jdbc-odbc bridge: app not closing MSSQL database connections

At 10:42 PM 16/10/01, you wrote:
>Hello, I am having a problem with my database connections not closing
>with MSSQL and jakarta tomcat on a WIN-NT 4 box.  Here's a run down of
>the damage:


Solution: don't use the jdbc:odbc bridge... it's not very reliable!

A quick search at java.sun.com or on the archives of this system should 
turn up some better drivers.



Jim




--

                           *   Jim Cheesman   *
             Trabajo: 
jchees@msl.es - (34)(91) 724 9200 x 2360
                 I am becoming 
increasingly worried that
                  there isn't enough anxiety in 
my life.



Re: Jdbc-odbc bridge: app not closing MSSQL database connections

Posted by Dmitri Colebatch <di...@bigpond.net.au>.
here tis:

http://www.microsoft.com/sql/downloads/2000/jdbc.asp

the newsgroup microsoft.public.sqlserver.jdbcdriver on
msnews.microsoft.com is a good source of information on this.

cheesr
dim

On Wed, 17 Oct 2001, Jim Cheesman wrote:

> At 09:14 AM 17/10/01, you wrote:
> >M$ have actually recently released a jdbc driver for SQL server.  I dont
> >have the url handy, but will send it later tonight.
> 
> 
> That's the one we're using, and it seems to work pretty well. We got it 
> from microsoft.com - you need to look in products, then SQL Server and it's 
> near there. (And no, I don't have the exact URL handy either ;)
> 
> 
> 
> Jim
> 
> --
> 
>                            *   Jim Cheesman   *
>              Trabajo: 
> jchees@msl.es - (34)(91) 724 9200 x 2360
>                  I am becoming 
> increasingly worried that
>                   there isn't enough anxiety in 
> my life.
> 
> 
> 


Re: Jdbc-odbc bridge: app not closing MSSQL database connections

Posted by Jim Cheesman <jc...@msl.es>.
At 09:14 AM 17/10/01, you wrote:
>M$ have actually recently released a jdbc driver for SQL server.  I dont
>have the url handy, but will send it later tonight.


That's the one we're using, and it seems to work pretty well. We got it 
from microsoft.com - you need to look in products, then SQL Server and it's 
near there. (And no, I don't have the exact URL handy either ;)



Jim

--

                           *   Jim Cheesman   *
             Trabajo: 
jchees@msl.es - (34)(91) 724 9200 x 2360
                 I am becoming 
increasingly worried that
                  there isn't enough anxiety in 
my life.



Re: Jdbc-odbc bridge: app not closing MSSQL database connections

Posted by Dmitri Colebatch <di...@bigpond.net.au>.
M$ have actually recently released a jdbc driver for SQL server.  I dont
have the url handy, but will send it later tonight.

cheers
dim

On Wed, 17 Oct 2001, Jim Cheesman wrote:

> At 10:42 PM 16/10/01, you wrote:
> >Hello, I am having a problem with my database connections not closing
> >with MSSQL and jakarta tomcat on a WIN-NT 4 box.  Here's a run down of
> >the damage:
> 
> 
> Solution: don't use the jdbc:odbc bridge... it's not very reliable!
> 
> A quick search at java.sun.com or on the archives of this system should 
> turn up some better drivers.
> 
> 
> 
> Jim
> 
> 
> 
> 
> --
> 
>                            *   Jim Cheesman   *
>              Trabajo: 
> jchees@msl.es - (34)(91) 724 9200 x 2360
>                  I am becoming 
> increasingly worried that
>                   there isn't enough anxiety in 
> my life.
> 
> 
>