JSP and MySQL - unable to load JDBC driver
need your help once again. i am trying to program using jsp to do simple data insertion and extraction to and from mysql database. i have some .jsp files that works at my school but when i transferred them here at my home linux box, it's giving:
Unable to load MySQL JDBC driver.
SQLException: No suitable driver SQLState: 08001 VendorError: 0
here's what i have done:
1) previously installed apache, mysql, and php. my linux distro is fedora core 4. i know mysql works because i have programs written in php to write and read data to and from mysql.
2) i just installed tomcat. it shows my html files that i put in its webapss folder so i know tomcat works.
3) i have java sdk installed. i know it works too because i can run java programs.
4) when doing research, i read somewhere that i need to copy jdbc driver on to my tomcat_folder/server/lib. i have copied two (2) drivers there. a)mm.mysql-2.0.8-bin.jar from my books cd. b) mysql-connector-java-3.1.13-bin.jar from mysql's website (j connector).
in my jsp program, here are the lines i got from my school versus and my edited version. both of them does not work on my linux machine.
School (works at school but not at home):
Connection conn = DriverManager.getConnection ( "jdbc:mysql://repost.insttech.wa.edu/jtuko", "jtuko", "password" );
**or the from school**
Connection conn = DriverManager.getConnection ( "jdbc:mysql://localhost/jtuko", "jtuko", "password" );
im am not sure what the url is supposed to be in connection line. my understanding is jdbc:mysql:// should be followed by nameofserver/nameofdatabase then username and password.