Error while trying to connect to postgresql

From: Danish Siddiqui <dsiddiqui(at)vertex(dot)co(dot)in>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Error while trying to connect to postgresql
Date: 2006-12-29 07:15:19
Message-ID: 4594C087.6040204@vertex.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
Can some one help me out with this problem. Ive been searching around
for some help but couldnt find any...

Im trying to connect PostgreSQL with Java..

import java.sql.*;

class PostgreSQLTest{
public static void main(String[] args){
Class.forName("org.postgresql.Driver");
String url="jdbcostgresql://localhost/postgres";
Connection db = DriverManager.getConnection("url", "postgres", "");

System.out.println("Connection Created");
db.close();
}
}

# javac PostgreSQLTest.java

PostgreSQLTest.java:5: unreported exception
java.lang.ClassNotFoundException; must be caught or declared to be thrown
Class.forName("org.postgresql.Driver");
^
PostgreSQLTest.java:7: unreported exception java.sql.SQLException; must
be caught or declared to be thrown
Connection db = DriverManager.getConnection("url", "postgres", "");
^
PostgreSQLTest.java:10: unreported exception java.sql.SQLException; must
be caught or declared to be thrown
db.close();
^
3 errors

# echo $CLASSPATH
:/usr/local/jdk1.6.0/lib/tools.jar:/usr/local/pgsql/share/java/postgresql-8.1-408.jdbc3.jar:/usr/local/jdk1.6.0/lib/:/home/danish/:/home/danish/PostgreSQLTest.java

Thanks
Danish

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Xavier Poinsard 2006-12-29 09:07:15 Re: Error while trying to connect to postgresql
Previous Message Ken Johanson 2006-12-29 06:10:52 Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel