This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC driver for mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC driver for mysql" Watch "JDBC driver for mysql" New topic
Author

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="http://www.jobklub.com" target="_blank" rel="nofollow">http://www.jobklub.com</a><br /> 'Add Job To Life'
John Bateman
Ranch Hand

Joined: Mar 09, 2000
Posts: 320
HI
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.
Thanks.

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

Joined: Apr 22, 2000
Posts: 33
Thanks
hanumanth reddy
John Bateman
I have already got the solution for "org.gjt.mm.mysql.Driver"
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: 139
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
frank
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC driver for mysql
 
Similar Threads
which driver for mysql
Make JDBC and JBuilder work together?
Make JDBC and JBuilder work together?
why i can't get the whole string when rs.getString() called ?
Problems redeploying EAR file with Third Party libs