I have, but I use the JDBC/ODBC bridge that ships with JDK 1.3 (the one with
1.2.2 does not support JDBC 2). I also handle all database operations in a
separate layer of code, not in Tomcat itself. But the JDBC/ODBC bridge does
seem to work ok. It can be very picky about some things, such as you must
request the data from you query results in the order the columns appear.
For example, if you issues a select firstName, lastName, emailAddress ...,
and then you attempt to read the emailAddress, firstName, lastName (in that
order) you will get an exception. There are other quirks, but I can't
remember them offhand.
-Original Message-
From: Sachin Phatak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 11:09 PM
To: [EMAIL PROTECTED]
Subject: MSSQL Tomcat JSP / Servlets
Hi!
Has anyone setup MSSQL 7.0 with TC?
Can anyone point me in the right direction?
thanks
sachin
