...but I keep getting the error message like this:
java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:532) at java.sql.DriverManager.getConnection(DriverManager.java:171) at tryJDBC.createConnection(tryJDBC.java:37) at tryJDBC.main(tryJDBC.java:135)
Tom, Well u have successfully loaded the driver, otherwise u would get a "ClassNotFound" Exception.
I guess there is a problem with your database url. Just check it up with your driver's documentation.
Joined: May 28, 2003
Thanks for the reply. I don't think the problem is because of the url, because the program above works fine if I added classes12.jar to the CLASSPATH. I wonder if I can use URLClassLoader for loading the JDBC driver, then I won't have to copy the driver files to every users' computers...(My boss doesn't want to use WEB...)
subject: URLClassLoader for loading JDBC driver...