| From: | Bart <bart(at)alator(dot)kotnet(dot)org> | 
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org | 
| Subject: | I can't connect | 
| Date: | 2001-03-21 20:00:45 | 
| Message-ID: | 20010321210045.1304ad85.bart@alator.kotnet.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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 with the 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 it to jdbc.jar and moved it to ~/jdk1.3/lib, set the CLASSPATH to ~/jdk1.3/lib and used a program, found in the Deitel&Deitel Java 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();
		}
. . . . . . . . .
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dax Duskin | 2001-03-21 20:06:20 | Re: I can't connect | 
| Previous Message | Peter Eisentraut | 2001-03-21 19:33:25 | patches for jdbc1 (fwd) |