I can't connect - Mailing list pgsql-jdbc

From Bart
Subject I can't connect
Date
Msg-id 20010321210045.1304ad85.bart@alator.kotnet.org
Whole thread Raw
Responses Re: I can't connect
Re: I can't connect
List pgsql-jdbc
Hi,

I installed debian 2.2r2 with _all_ the postgres-packages,  I created a database and via psql I can do whatever I want
withthe DB. Now I'm trying to make a connection via a Java-program. I downloaded the jdbc-6.5-1.2.jar file and renamed
itto jdbc.jar and moved it to ~/jdk1.3/lib, set the CLASSPATH to ~/jdk1.3/lib and used a program, found in the
Deitel&DeitelJava book. 
After that, I tried to make a connection to the database I created (testing) and I keep getting error-messages.

Can someone help me with this? I'm trying for 3 days now and still no luck.

Thanks,
Bart


 --- program from Deitel & Deitel ---

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;

public class TableDisplay extends JFrame
{
    private Connection connection;
    private JTable table;

    public TableDisplay()
    {
        String url = "jdbc:odbc:testing";   // I also tried with <String url = "jdbc:postgres:testing";>
        String username = "postgres";
        String password = "notentered";


        try
        {
            Class.forName("jdbc.Driver");
            connection = DriverManager.getConnection(url, username, password);
        }
        catch (ClassNotFoundException cnfex)
        {
            System.err.println("Failed to load the JDBC/ODBC driver.");
            cnfex.printStackTrace();
            System.exit(1);
        }
        catch (SQLException sqlex)
        {
            System.err.println("Unable to connect to database.");
            sqlex.printStackTrace();
        }
. . . . . . . . .

pgsql-jdbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: patches for jdbc1 (fwd)
Next
From: "Dax Duskin"
Date:
Subject: Re: I can't connect