File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC driver for mysql 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 "JDBC driver for mysql" Watch "JDBC driver for mysql" New topic

JDBC driver for mysql

sean zang
Ranch Hand

Joined: Apr 22, 2000
Posts: 33
HI, all
I successfully install Mysql on NT. It works ok.
I download serveral JDBC for Mysql driver such as MM.mysql, Twz1, unfortunatelly, no one can run succssefully even if compliation is absolute no problem. most errors occur at runtime!! Does anyone can tell which JDBC driver is best one for Mysql? I very urgent for this request becasue I have to use Mysql in my next project!
any reply will be great apprecaited!!!
hanumanth reddy
Ranch Hand

Joined: Jun 12, 2000
Posts: 118
iam succesfully abele to use the mm.mysql driver just set the path and class path correctly

<a href="" target="_blank" rel="nofollow"></a><br /> 'Add Job To Life'
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
I've had no problems using the TWZ driver. Can you supply the error you are getting? Maybe do a printStackTrace() and post it here for us to analyze.

SOURCE CODE should be SURROUNDED by "code" tags.
sean zang
Ranch Hand

Joined: Apr 22, 2000
Posts: 33
hanumanth reddy
John Bateman
I have already got the solution for ""
The resaon is very simple. each time when the driver is changed,
The Servlet Engine must be restarted. Here is my runnig environment:
Web server: iis4
Servlet Engine:Jrun 2.3.3
Database: Mysql, oracle( Oracle has its own driver, It works perfectly.)
When i try to use "twz1.jdbc.mysql.jdbcMysqlDriver");
It gives me the following error:
java.lang.VerifyError: (class: twz1/jdbc/mysql/jdbcMysqlBase, method: isMultipleQuery signature: (Ltwz1/jdbc/mysql/jdbcMysqlConnex Z) Illegal use of nonvirtual function call
John, Did you encounter this error before?
thanks reply
Frank Daly
Ranch Hand

Joined: Mar 31, 2000
Posts: 141
i have downloaded the mm.mysql driver binary jar file and put it into the jre\lib\ext subdirectory of the jdk. What else do i have to do To get the mm.mysql driver working successfully?
thanks in advance
I agree. Here's the link:
subject: JDBC driver for mysql
It's not a secret anymore!