Thread: Creating a .jar that uses a DB

Hi,

I have written a simple server program that allows users to log in and register for a class using client.

The server connects to a database and is run on a server at my uni. Everything worked fine until I tried to create a .jar file for the server and run it on the remote server. I get a classNotFoundException: org.postgresql.Driver I stress everything worked fine until I tried to use the jar.

Is there something different I need to do when specifying the drivers for the DB if it is within a .jar? Like I would need to if I was including data files.

Current DB connection code below:

public void connect() throws Exception{
		Class.forName("org.postgresql.Driver");
		connect = DriverManager.getConnection("jdbc:postgresql://igor.gold.ac.uk:5432/database","username", "password");
		st = connect.createStatement();
		System.out.println("connected");
		connected = true;
	}

Thanks for your help.
M

Right don't worry, I have figured it out.

Incase any one else is having a similar problem what I needed to to do was:

1. Include a Class-Path: header in my manifest file that referenced the .jar file containing the postgresql drivers (postgresql-9.0-801.jdbc3.jar)
2. Put a copy of postgresql-9.0-801.jdbc3.jar in the same directory on the server where my .jar is run.

Alternatively I could have un-archived postgresql-9.0-801.jdbc3.jar, taken the .class files that are the DB drivers and added them to my .jar that I created, but this seemed a little long winded.

well done me.