Still baffled by a CONNECTion problem - Mailing list pgsql-jdbc

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