Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes Please help, Connector J mysql problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Please help, Connector J mysql problem" Watch "Please help, Connector J mysql problem" New topic

Please help, Connector J mysql problem

Hardy Chou

Joined: Jun 27, 2001
Posts: 27
i am using jdk1.3 and mysql 3.23.51 and tomcat 4.0.4. i downloaded the latest connector j [jdbc driver for mysql] and i put it under jdk1.3\jre\lib\ext\. my tomcat is running now and mysqld --standalone is also running on. however, i cannot seem to connect to the database.
jdbc could find the class, so this below line is ok:
Class.forName "com.mysql.jdbc.Driver").newInstance();
however if i add this line to connect to the db:
con = DriverManager.getConnection "jdbc:mysql://localhost:3306/test");
i would get the error message HTTP Status 500 - Internal Server Error. i never encounter this with my old mm.mysql driver. any idea guys?
thank you
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

see this thread.
[ September 17, 2002: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: Please help, Connector J mysql problem
It's not a secret anymore!