You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Carlos <li...@lpis.com> on 2000/12/12 15:45:28 UTC
linux->NT->MSsqlServer
I am using tomcat in a linux, and my database is in a NT (it is a microsoft
SQL server).
anybody can say me what driver i good to use with this database?
there is any experience in this database from a linux using a JDB driver?
i have see a long list for buying a driver but i dont kown what i must to
buy.
i want to konw what is a good driver, not slow and solid
thanks
carlos
Re: linux->NT->MSsqlServer
Posted by Pier Paolo Bortone <pi...@netengineering.it>.
I'm using jdbc from freetds project.
It's very small, very good and very easy to use (JDBC level 4).
Thanks to freetds development team.
My environment is:
Good components:
Linux (best linux) on intel
apache 1.3.14
tomcat 3.2
jdbc:freetds 0.51
Bad components:
Windows NT4.0
MSSQLServer 7.0
Pier Paolo.
----- Original Message -----
From: Carlos
To: tomcat-user@jakarta.apache.org
Sent: Tuesday, December 12, 2000 3:45 PM
Subject: linux->NT->MSsqlServer
I am using tomcat in a linux, and my database is in a NT (it is a microsoft
SQL server).
anybody can say me what driver i good to use with this database?
there is any experience in this database from a linux using a JDB driver?
i have see a long list for buying a driver but i dont kown what i must to
buy.
i want to konw what is a good driver, not slow and solid
thanks
carlos
Re: linux->NT->MSsqlServer
Posted by Matt Goss <mg...@rtci.com>.
Carlos,
I ran both drivers against a Microsoft SQL 7 datbase, pulling back a 792 row
table. After 5 times, the Jturbo driver was averaging 700 milliseconds to bring
back the data, and the bea driver was averaging 4000 milliseconds! (This was my
own personal test, no public benchmark)
Matt
Carlos wrote:
> can you say me where are these tests?
> ----- Original Message -----
> From: "Matt Goss" <mg...@rtci.com>
> To: <to...@jakarta.apache.org>
> Sent: Tuesday, December 12, 2000 6:11 PM
> Subject: Re: linux->NT->MSsqlServer
>
> > Ditto...
> > I'm also using the JTurbo 2.0 JDBC driver, and on benchmark tests against
> Bea's
> > Weblogic JDBC driver, it came up 5 times faster!
> > Matt
> >
> > Eric Hartmann wrote:
> >
> > > Hello,
> > >
> > > I've test two drivers JDBC for Microsoft SQL Server 7 / 2000. jdbcKona
> > > driver from BEA (does not works with SQL 2000) and JTurbo from Ashna.
> JTurbo
> > > 2.0 (www.jturbo.com) is a very good driver for SQL Server. It's fast and
> > > reliable with my tests. I didn't test it on Linux but you can download a
> > > test version for 30j and limited to 5 connections. It seems that JTurbo
> is
> > > more reliable than jdbcKona. But this two level 4 drivers are good
> however
> > > we choose JTurbo that seems to be faster.
> > >
> > > I hope this helps
> > >
> > > Eric
> > >
> > > -----Original Message-----
> > > From: Carlos [mailto:linux@lpis.com]
> > > Sent: mardi 12 décembre 2000 15:45
> > > To: tomcat-user@jakarta.apache.org
> > > Subject: linux->NT->MSsqlServer
> > >
> > > I am using tomcat in a linux, and my database is in a NT (it is a
> microsoft
> > > SQL server).
> > > anybody can say me what driver i good to use with this database?
> > > there is any experience in this database from a linux using a JDB
> driver?
> > > i have see a long list for buying a driver but i dont kown what i must
> to
> > > buy.
> > > i want to konw what is a good driver, not slow and solid
> > > thanks
> > > carlos
> >
Re: linux->NT->MSsqlServer
Posted by Carlos <li...@lpis.com>.
can you say me where are these tests?
----- Original Message -----
From: "Matt Goss" <mg...@rtci.com>
To: <to...@jakarta.apache.org>
Sent: Tuesday, December 12, 2000 6:11 PM
Subject: Re: linux->NT->MSsqlServer
> Ditto...
> I'm also using the JTurbo 2.0 JDBC driver, and on benchmark tests against
Bea's
> Weblogic JDBC driver, it came up 5 times faster!
> Matt
>
> Eric Hartmann wrote:
>
> > Hello,
> >
> > I've test two drivers JDBC for Microsoft SQL Server 7 / 2000. jdbcKona
> > driver from BEA (does not works with SQL 2000) and JTurbo from Ashna.
JTurbo
> > 2.0 (www.jturbo.com) is a very good driver for SQL Server. It's fast and
> > reliable with my tests. I didn't test it on Linux but you can download a
> > test version for 30j and limited to 5 connections. It seems that JTurbo
is
> > more reliable than jdbcKona. But this two level 4 drivers are good
however
> > we choose JTurbo that seems to be faster.
> >
> > I hope this helps
> >
> > Eric
> >
> > -----Original Message-----
> > From: Carlos [mailto:linux@lpis.com]
> > Sent: mardi 12 décembre 2000 15:45
> > To: tomcat-user@jakarta.apache.org
> > Subject: linux->NT->MSsqlServer
> >
> > I am using tomcat in a linux, and my database is in a NT (it is a
microsoft
> > SQL server).
> > anybody can say me what driver i good to use with this database?
> > there is any experience in this database from a linux using a JDB
driver?
> > i have see a long list for buying a driver but i dont kown what i must
to
> > buy.
> > i want to konw what is a good driver, not slow and solid
> > thanks
> > carlos
>
RE: Linux->NT->MSsqlServer
Posted by "G.Nagarajan" <gn...@dkf.de>.
Yes, the atinav driver forces you to use a single statement throughout a
transaction.
And in the freeTDS driver, the transaction is connected with the statement.
How about these type 3 drivers from Merant and others. Has anyone worked
with them?
I did not try them for two reasons. Adding another intermediate layer and
making
things complicated and to avoid one more source of possible errors.
-----Original Message-----
From: Matt Goss [mailto:mgoss@rtci.com]
Sent: Tuesday, December 12, 2000 6:11 PM
To: tomcat-user@jakarta.apache.org
Subject: Re: linux->NT->MSsqlServer
Ditto...
I'm also using the JTurbo 2.0 JDBC driver, and on benchmark tests against
Bea's
Weblogic JDBC driver, it came up 5 times faster!
Matt
Eric Hartmann wrote:
> Hello,
>
> I've test two drivers JDBC for Microsoft SQL Server 7 / 2000. jdbcKona
> driver from BEA (does not works with SQL 2000) and JTurbo from Ashna.
JTurbo
> 2.0 (www.jturbo.com) is a very good driver for SQL Server. It's fast and
> reliable with my tests. I didn't test it on Linux but you can download a
> test version for 30j and limited to 5 connections. It seems that JTurbo is
> more reliable than jdbcKona. But this two level 4 drivers are good however
> we choose JTurbo that seems to be faster.
>
> I hope this helps
>
> Eric
>
Re: linux->NT->MSsqlServer
Posted by Matt Goss <mg...@rtci.com>.
Ditto...
I'm also using the JTurbo 2.0 JDBC driver, and on benchmark tests against Bea's
Weblogic JDBC driver, it came up 5 times faster!
Matt
Eric Hartmann wrote:
> Hello,
>
> I've test two drivers JDBC for Microsoft SQL Server 7 / 2000. jdbcKona
> driver from BEA (does not works with SQL 2000) and JTurbo from Ashna. JTurbo
> 2.0 (www.jturbo.com) is a very good driver for SQL Server. It's fast and
> reliable with my tests. I didn't test it on Linux but you can download a
> test version for 30j and limited to 5 connections. It seems that JTurbo is
> more reliable than jdbcKona. But this two level 4 drivers are good however
> we choose JTurbo that seems to be faster.
>
> I hope this helps
>
> Eric
>
> -----Original Message-----
> From: Carlos [mailto:linux@lpis.com]
> Sent: mardi 12 décembre 2000 15:45
> To: tomcat-user@jakarta.apache.org
> Subject: linux->NT->MSsqlServer
>
> I am using tomcat in a linux, and my database is in a NT (it is a microsoft
> SQL server).
> anybody can say me what driver i good to use with this database?
> there is any experience in this database from a linux using a JDB driver?
> i have see a long list for buying a driver but i dont kown what i must to
> buy.
> i want to konw what is a good driver, not slow and solid
> thanks
> carlos
RE: linux->NT->MSsqlServer
Posted by Eric Hartmann <er...@rhinfo.com>.
Hello,
I've test two drivers JDBC for Microsoft SQL Server 7 / 2000. jdbcKona
driver from BEA (does not works with SQL 2000) and JTurbo from Ashna. JTurbo
2.0 (www.jturbo.com) is a very good driver for SQL Server. It's fast and
reliable with my tests. I didn't test it on Linux but you can download a
test version for 30j and limited to 5 connections. It seems that JTurbo is
more reliable than jdbcKona. But this two level 4 drivers are good however
we choose JTurbo that seems to be faster.
I hope this helps
Eric
-----Original Message-----
From: Carlos [mailto:linux@lpis.com]
Sent: mardi 12 décembre 2000 15:45
To: tomcat-user@jakarta.apache.org
Subject: linux->NT->MSsqlServer
I am using tomcat in a linux, and my database is in a NT (it is a microsoft
SQL server).
anybody can say me what driver i good to use with this database?
there is any experience in this database from a linux using a JDB driver?
i have see a long list for buying a driver but i dont kown what i must to
buy.
i want to konw what is a good driver, not slow and solid
thanks
carlos