jdbc on ubuntu no class found

trscookie · 02-03-2008, 09:39 AM

Hello all,

Could some one please explain why my program cant find the jdbc driver for my mysql database I have configured it according to the ubuntu website, it looks like other people have had a similar problem until the defined their drivers in their classpath. But I still get the same error no class defined errors:

install jdbc:

Code:

sudo aptitude install libmysql-java

export the classpath:

Code:

export CLASSPATH=$CLASSPATH:/home/adrian/Desktop/mysql-connector-java-5.1.5.    tar.gz:/usr/share/java/mysql-connector-java.jar:/usr/share/java/mysql.jar:/u    sr/share/java/jtds-1.2.2.jar

Application code:

Code:

dbDriver    =   "com.mysql.jdbc.Driver";
dbUrl       =   "jdbc:mysql://localhost/helpdesk";

Error message:

Code:

Error with SQL: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/helpdesk.

Could someone please help with this, thanks trscookie.

jay73 · 02-06-2008, 07:24 PM

Why does your classpath look so weirdly chopped up?

Anyway, check your /usr/share/java, I don't think that there is a "mysql-connector-java.jar", I am missing the version numbers..

Also, if you put the path in /etc/profile, make sure that the file gets sourced.

trscookie · 02-06-2008, 07:31 PM

I think that it must have been something to do with the way that I pasted the line in, It doesnt look like that on my profile, I should have mentioned that mysql-connector.jar is a symlink to the jdbc.jar.

I've just found out what the problem is, even though the jdbc jar was in my classpath I did not have the jdbc driver linked in my project, school boy error! Thanks anyway, trscookie.