Thread: Java.jar and Mysql.jar

Hi all

Right I currently have a two servers, one holding a database, and one with files stored.
I have created a file which gets all the files stored on the second and inserts it into the database.
Using the IP address of the first to tell the system that this is the host.

           url = "jdbc:mysql://192.168.1.10/" + database;
           conn = DriverManager.getConnection(url, user, password);

When i try and run this, the server cannot locate the mysql driver.
with netbean i selected the option to create a jar with specified libs included.

I have also tried adding the driver to the java/lib folder on the second server and this didnt work.

My question is, Is there a way i can point explicitly, to the mysql driver file from the java class?
or combine the Jar files together so they work with each other.

Thanks
Kurt

You need to place the jar on your classpath. If you package the jar's together, you need to make sure the manifest file reflects the class path (see Modifying the Manifest). Otherwise, your server may have a default directory to place jar's that, once in that directory are inherently on the classpath.