newbe cant get mysql with jsp

Thread view:

joe - 27 Feb 2007 16:55 GMT

Hello I am getting

org.apache.jasper.JasperException: Exception in JSP: /test.jsp:13

10: //try {
11:
12: Connection ocon = null;
13: Class.forName("org.gjt.mm.mysql.Driver");
14:
15: ocon = DriverManager.getConnection("jdbc:mysql://localhost/
test","test","test");
16: //ocon = DriverManager.getConnection("jdbc:mysql://localhost/test?
user=test&password=te

My database is call test, my table is called test and the username and
password are call test

I added this to the tomcat5.conf
LD_LIBRARY_PATH=/usr/share/java
#LD_LIBRARY_PATH=/usr/share/java/mysql-connector-java.jar

#CLASSPATH=${CLASSPATH}:/usr/share/java/mysql-connector-java.jar
CLASSPATH=${CLASSPATH}:/usr/share/java/mysql-connector-java-3.1.12.jar

but no cheese, please help.

Reply to this Message

joe - 28 Feb 2007 13:07 GMT

Got it found this link

http://csci.csusb.edu/turner/archive/notes/gentoo/tomcat.html

Got rid off the last lines classpath and ld_ and then just create a
link for mysql and it worked :)

> Hello I am getting
>
[quoted text clipped - 21 lines]
>
> but no cheese, please help.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...