Still baffled by a CONNECTion problem

It appears my first appeal for help wasn�t clear enough.

I want to connect my Java Application running on Windows 2000 to my 
postgresql database.

From what I understand and have read there are AT LEAST 2 things I need to 
do.

(1) Have the application load the relevant JDBC driver and

(2) Make a connection.

With respect to (1), despite numerous attempts I have been unable to resolve 
the ClassNotFound exception.

I have set the CLASSPATH environment variable as follows:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\ULTRAE~1;C:\Program 
Files\Java\jdk1.5.0_04\bin;C:\Program Files\PostgreSQL\8.0\jdbc

I have written some test code in Java to load the Driver, as follows:
	public void displayClasspath()
	{
		String driverPath = "C:\\Program Files\\PostgreSQL\\8.0\\jdbc";
		String classpath = System.getProperty("java.class.path");
		_displayTextArea.append("Classpath = " + classpath + "\n");

		classpath = classpath + ";" + driverPath + 
"\\postgresql-8.0-311.jdbc3.jar";
		System.setProperty("java.class.path", classpath);
		_displayTextArea.append("Classpath = " + classpath + "\n");

		System.setProperty("jdbc.drivers", driverPath);
		String drivers = System.getProperty("jdbc.drivers");
		_displayTextArea.append("Drivers = " + drivers + "\n");

		// 1. Load the jdbc.odbc database driver class
        try
        {
        	File driverDir = new File(driverPath);
        	if ( driverDir.isDirectory() )
        		_displayTextArea.append("DriverDir is a directory \n");
        	else
        		_displayTextArea.append("DriverDir is NOT a directory \n");

        	File dFile = new File(driverPath + 
"\\org\\postgresql\\Driver.class");
        	if ( dFile.isFile() )
        		_displayTextArea.append("Driver is a file \n");
        	else
        		_displayTextArea.append("Driver is NOT a file \n");

        	String driver = "org.postgresql.Driver";
        	driverPath = driverPath + "\\" + driver;

        	Class.forName(driver);
        }
	    catch (ClassNotFoundException cnfe)
	    {
			System.out.println("ClassNotFoundException.");
        }
	}

The output from this code is as follows:
Classpath = C:\Eclipse\Workspace\Test
Classpath = C:\Eclipse\Workspace\Test;C:\Program 
Files\PostgreSQL\8.0\jdbc\postgresql-8.0-311.jdbc3.jar
Drivers = C:\Program Files\PostgreSQL\8.0\jdbc
DriverDir is a directory
Driver is a file

So:
- for some unknown reason my Eclipse editor has reset my CLASSPATH
- but despite this I am able to programmatically adjust the CLASSPATH 
property to suit
- Java recognized the directory where I have installed the JAR file as a 
valid directory and is able to locate the relevant driver file

WHY WON�T IT LOAD the DRIVER?????


With respect to (2) creating a connection.
From what I have read I need to set the PostMaster to run with a �-I� flag 
to enable TCP/IP communication.
However the Postmaster is started somewhere in the boot sequence, and I 
don�t know how to adjust it�s startup.

HOW DO I DO THIS?


IS THERE SOMETHING ELSE I NEED TO DO???

I think I can work out the connection parameters and make the connection IF 
I CAN RESOLVE THESE QUESTIONS.

Yours Sincerely

Peter Cook

_________________________________________________________________
REALESTATE: biggest buy/rent/share listings   
http://ninemsn.realestate.com.au