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
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,
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
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
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?
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
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.
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
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
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
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
11 matches
Mail list logo