We have used both JTDS and JDBC to connect Tomcat to SQL2000. JTDS seems to be more memory efficient. It is also far stricter in how data types are cast. Stored Procedures that worked fine with JDBC sometimes did not properly with JTDS. I think the issue (I am not doing the java work) is that the variable types in preparing the statement must be strictly correct... i.e. JTDS will not truncate a string that is too long for the var type but JDBC will.
Justin > -----Original Message----- > From: Phil Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 09, 2006 10:32 AM > To: Tomcat Users List > Subject: Re: IIS 6 + Apache tomcat 5.5.15 + SQL > Server 2000 ? ( Windows 2003 Server ) > > > I know ... it's not a good Combo > > > > IIS 6 + Apache tomcat 5.5.15 + SQL Server 2000 ? ( Windows 2003 > > Server ) but... let's crash and burn ;) > > Hi, > > I've done this combo before using the jTDS driver from > http://jtds.sourceforge.net/ > > If you notice, all of the examples on the URL you give are > very very similar, and off the > top of my head I can't remember any massive differences > between the SQL Server 2000 config > and MySQL, so just try the MySQL config (with the correct > driverClassName and JDBC URL of > course) and see how far you get. > > Good luck! > > Phil > > > > > Checking in the web site i see that i can install the > Apache-Tomcat > > and that works properly ( First time i work with Windows 2003 ). > > > > What i'm not plenty sure ... I'm going to face problems > if i want > > to stablish JDBC conectivity with a SQL Server 2000 Database. > > > > I just see , Mysql ,Oracle and PostgreSQL Conectivity. > > > > > > > http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-exampl es-howto.html > > Regards and Thx In Advance. > Sergio Gonzalez Ramos. > > --------------------------------- > > LLama Gratis a cualquier PC del Mundo. > Llamadas a fijos y móviles desde 1 céntimo por minuto. > http://es.voice.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
