Re: IIS 6 + Apache tomcat 5.5.15 + SQL Server 2000 ? ( Windows 20 03 Server )

[Justin Greene <bs...@spamex.com>]

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:p.g.wilson@bath.ac.uk] 
> 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org