You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Andrea Modesto Rossi <an...@ateneopv.it> on 2007/01/19 08:42:46 UTC
Tomcat and jdbc over MS SQL Server
Hi all,
Need help on this. I'm using Tomcat6 over Debian GNU/Linux. Now
i've a webapps written by JAVA but the database is sql server microsoft
on the windows server.
Is it possible to connect java webapps with sqlserver using jdbc?
Appreciate your help.
Krishna
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat and jdbc over MS SQL Server
Posted by Youko <fr...@yahoo.com>.
and dont forget to install SP3 or above for SQL server 2000.
otherwise, jtds wouldnt work.
--Priyoko
At work we use SQL Server 2000 and 2005. At first we used Opta2000 as
jdbc connector. Now we use jTDS, which is open source and freely
available. I don't know about performance issues, but we don't notice
any difference (it's development mainly, and low traffic sites). I've
tried to use the Microsoft driver, but that didn't work for some reason.
http://jtds.sourceforge.net/
http://www.inetsoftware.de/products/ (for Opta)
JV
--
View this message in context: http://www.nabble.com/Tomcat-and-jdbc-over-MS-SQL-Server-tf3038699.html#a8473892
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat and jdbc over MS SQL Server
Posted by JV <jv...@orange.nl>.
At work we use SQL Server 2000 and 2005. At first we used Opta2000 as
jdbc connector. Now we use jTDS, which is open source and freely
available. I don't know about performance issues, but we don't notice
any difference (it's development mainly, and low traffic sites). I've
tried to use the Microsoft driver, but that didn't work for some reason.
http://jtds.sourceforge.net/
http://www.inetsoftware.de/products/ (for Opta)
JV
Op 20 jan 2007, om 08:20 heeft Zack Grafton het volgende geschreven:
> Hi,
>
> It is possible, there are 2 different methods. The JDBC-ODBC
> bridge, here's a link on the subject http://java.sun.com/j2se/1.3/
> docs/guide/jdbc/getstart/bridge.doc.html
>
> And, depending on your version of SQL Server you could use the one
> provided by Microsoft,
>
> For SQL Server 2000
> http://www.microsoft.com/downloads/details.aspx?
> FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en
>
> For SQL Server 2005
> http://www.microsoft.com/downloads/details.aspx?
> familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en
>
> If you are using anything older than SQL Server 2000, you should
> really consider upgrading.
>
>
> Zack
>
> Andrea Modesto Rossi wrote:
>> Hi all,
>>
>> Need help on this. I'm using Tomcat6 over Debian GNU/Linux. Now
>> i've a webapps written by JAVA but the database is sql server
>> microsoft
>> on the windows server.
>>
>> Is it possible to connect java webapps with sqlserver using jdbc?
>>
>>
>>
>> Appreciate your help.
>>
>>
>>
>> Krishna
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat and jdbc over MS SQL Server
Posted by Zack Grafton <za...@gmail.com>.
Hi,
It is possible, there are 2 different methods. The JDBC-ODBC bridge,
here's a link on the subject
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
And, depending on your version of SQL Server you could use the one
provided by Microsoft,
For SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en
For SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en
If you are using anything older than SQL Server 2000, you should really
consider upgrading.
Zack
Andrea Modesto Rossi wrote:
> Hi all,
>
> Need help on this. I'm using Tomcat6 over Debian GNU/Linux. Now
> i've a webapps written by JAVA but the database is sql server microsoft
> on the windows server.
>
> Is it possible to connect java webapps with sqlserver using jdbc?
>
>
>
>
>
> Appreciate your help.
>
>
>
>
>
> Krishna
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org