Re: Connetion between Tomcat MySQL

2003-09-09 Thread Amy Cheung
so what kind of connection is best? using the J/Connector or the OCBC one? --- Bill Barker [EMAIL PROTECTED] wrote: Assuming that you aren't using JDBCRealm, then it should be enough to put the jar file in $TOMCAT_HOME/lib/apps. If you are using JDBCRealm, then place it in

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Amy Cheung
--- Bill Barker [EMAIL PROTECTED] wrote: Assuming that you aren't using JDBCRealm, then it should be enough to put the jar file in $TOMCAT_HOME/lib/apps. If you are using JDBCRealm, then place it in $TOMCAT_HOME/lib/common. Setting the CLASSPATH is evil ;-). Amy Cheung [EMAIL

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Christopher Williams
I'll assume that you're using Connector /J. Stick the file mysql-connector-java-x.y.zz-bin.jar (where x.y.zz is the version number) in Tomcat's common/lib directory. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Christopher Williams
My apologies (and my tping error), the directory should be common/lib, not lib/common. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Kwok Peng Tuck
Any JDBC driver for mysql (that works for you) will do. Amy Cheung wrote: so what kind of connection is best? using the J/Connector or the OCBC one? --- Bill Barker [EMAIL PROTECTED] wrote: Assuming that you aren't using JDBCRealm, then it should be enough to put the jar file in

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Schalk
There is two things you can do. Set your CLASSPATH to include mm.mysql.driver and include the jar in your webapps lib folder. HTH Kind Regards Schalk Volume4

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Amy Cheung
OK. Thanks. It can connects to the database now. Here is a minor problem. The results I obtained from the query is a ResultSet, rs. I keyed in this code: while (rs.next()) { System.out.print(rs.getString(RoomID); } In the Tomcat server, it printed the results that I wanted. How to incorporate

RE: Connetion between Tomcat MySQL

2003-09-09 Thread Mike Curwen
- From: Schalk [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:20 AM To: Tomcat Users List Subject: Re: Connetion between Tomcat MySQL There is two things you can do. Set your CLASSPATH to include mm.mysql.driver and include the jar in your webapps lib folder. HTH Kind

Re: Connetion between Tomcat MySQL

2003-09-09 Thread Marco Tedone
[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 4:40 AM Subject: Connetion between Tomcat MySQL Hi, I am using Tomcat 3.3.1 and MySQL 4.0 in Window XP. MySQL engine is running. When I run my jsp, it stated the error that import com.mysql.Driver not found. Anyone know how to install

Connetion between Tomcat MySQL

2003-09-08 Thread Amy Cheung
Hi, I am using Tomcat 3.3.1 and MySQL 4.0 in Window XP. MySQL engine is running. When I run my jsp, it stated the error that import com.mysql.Driver not found. Anyone know how to install the driver properly? I read something about setting the class path. But where to set? I don't know much about

Re: Connetion between Tomcat MySQL

2003-09-08 Thread Bill Barker
Assuming that you aren't using JDBCRealm, then it should be enough to put the jar file in $TOMCAT_HOME/lib/apps. If you are using JDBCRealm, then place it in $TOMCAT_HOME/lib/common. Setting the CLASSPATH is evil ;-). Amy Cheung [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I