Re: JDBC Drivers for Java

Here is working example for you to try:

--In my databse
CREATE TABLE people (
id SERIAL,
name TEXT
);
INSERT INTO people(name) VALUES ('sue');
INSERT INTO people(name) VALUES ('peter');
INSERT INTO people(name) VALUES ('tony');
INSERT INTO people(name) VALUES ('mary');

--ListPeople.java
import java.sql.*;

public class ListPeople {
public static void main(String[] args) {
try {
Class.forName("org.postgresql.Driver");

//the url is
jdbc:postgresql://<host_name>:<port_number>/<database_name>?user=<user_name>&password=<password>
//in my case, the database is in localhost, and I need no passwords,
so using
//jdbc:postgresql:<database_name>?user=<user_name> will be just fine
Connection
con=DriverManager.getConnection("jdbc:postgresql:franco?user=admin");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM people");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
}
catch (Exception e) {
System.out.println("Exception: "+e.getMessage());
}
}
}

It works for me, so if doesn't work for you I'm sure the problem is in your
CLASSPATH.

On Friday 11 April 2003 20:47, Greg Lugering wrote:
> I just installed the Windows version of PostgreSQL 7.3.1.
> A jar file was included however the path was org/postgresql/Driver which
> causes and exception. I expected somethig like org.postgresql.Driver.
>
> If anyone can help me and send the exact code for making the connection it
> woud be appreciated.
>
> Thanks!
>
> Bob Lugering
> blugering(at)cfl(dot)rr(dot)com