ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
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.