Re: Using servlet and mysql

2007-05-29 Thread De Haan Software Engineering
I agree completely. For testing purposes or migration it works. We are switching to MySQL asap, but dozens of customers are still using it... Sije At 14:38 29-5-2007, you wrote: I would actually recommend steering clear of the jdbc-odbc bridge driver. It's not stable enough for production u

Re: Using servlet and mysql

2007-05-29 Thread David Smith
I would actually recommend steering clear of the jdbc-odbc bridge driver. It's not stable enough for production use on any level. Get MySQL (it's free), install it, configure it according to the docs and setup your db there. Docs are plentiful on the mysql website. You will be much happier with

Re: Using servlet and mysql

2007-05-29 Thread De Haan Software Engineering
Access databases can only be accessed by ODBC (default present at 2000 / XP). MySQL has nothing to do with it. 1) First create your Access database (.mdb, I don't know what a Works database is?). It may be placed anywhere on your Tomcat Server. 2) Then configure it for usage by ODBC. Click

Re: Using servlet and mysql

2007-05-29 Thread Foo Shyn
Hi, In short, to get a MySQL server up, try the following: 1) Install an instance of MySQL 2) Install the client software (you can get them from the MySQL web site too, like MySQL Administrator etc or you can try the MySQL Front for older version of MySQL) 3) Create a database using the client

Re: Using servlet and mysql

2007-05-29 Thread Teh Noranis Mohd Aris
I'm very new to this. This is the first time I'm using mysql and servlet. I might be doing a lot of mistakes. I realized that I should not use Microsoft Works Database. How can I actually create the database name, table and its field using mysql? In which directory should I put the database? Ple

Re: Using servlet and mysql

2007-05-29 Thread Foo Shyn
Hi, This is getting more confusing, you mentioned earlier that you're using MySQL but now it is a Microsoft Works Database. Hmmm perhaps i'm missing something? Anyway, if the database you're using is something like an Access database, you'll just need to use the correct driver and point the

Re: Using servlet and mysql

2007-05-29 Thread Teh Noranis Mohd Aris
Yes, the login name and password are correct. I created the database name, teh, with field username and password, using Microsoft Works Database and saved it in directory catalina_home\webapps\ROOT\. I'm not sure whether it is the correct directory to put the database. However, in the program th

Re: Using servlet and mysql

2007-05-29 Thread Foo Shyn
Hi, Is your login name and password correct? It shows 'root' and the password is 'root' in the code you posted there. - I put the database name, teh in directory catalina_home\webapps\ROOT\ hmm i can't really get what you meant here. Thanx. FooShyn Teh Noranis Mohd Aris wrote: Dear All,

Re: Using servlet and mysql

2007-05-28 Thread Teh Noranis Mohd Aris
Dear All, I already put mysql database driver (jar file) in directory catalina_home\common\lib and changed 8080 to 3306 but I got the error "java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect". What should be the

Re: Using servlet and mysql

2007-05-28 Thread Foo Shyn
Hi, You'll need to get the MySQL database driver and put them in the {catalina_home}\common\lib folder. The driver can be easily obtained through MySQL site. BTW, as far as i know, the default port for MySQL database is 3306, so you might wanna change that. 8080 is for Tomcat, not the database

Re: Using servlet and mysql

2007-05-28 Thread Zachary Grafton
On Tuesday 29 May 2007 01:14, Teh Noranis Mohd Aris wrote: > Thank you so much for the reply. I've put "jdbc:mysql://localhost:8080/teh > but I got the error java.lang.ClassNotFoundException: > com.mysql.jdbc.Driver. I'm very new to using mysql database and servlet. > Can you please explain to me h

Re: Using servlet and mysql

2007-05-28 Thread Teh Noranis Mohd Aris
Thank you so much for the reply. I've put "jdbc:mysql://localhost:8080/teh but I got the error java.lang.ClassNotFoundException: com.mysql.jdbc.Driver. I'm very new to using mysql database and servlet. Can you please explain to me how to create the database name and its fields? Should I install

Re: Using servlet and mysql

2007-05-28 Thread Foo Shyn
Hi, would be ur database port, xxx will be ur database name HTH FooShyn Teh Noranis Mohd Aris wrote: Hi, I would like to access mysql database from a servlet but I'm not sure what to initialize for the String connectionURL marked as "jdbc:mysql://localhost:/xxx" in the program b