> i have postgresSql in my linux box i want to connect to it. I
>don't know the way. i think i should have the driver installed in the
>client side. And the postmaster is running in the server machine.
>Any thing else is needed for the connectivity. Ask me if you don't get the
>question clearly.
On the client side all you have to do is to make sure that postgresql.jar is
in your classpath.
Then use code like this to connect:
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
Error.error("ClassNotFoundException: " + e.getMessage());
}
try {
connection = DriverManager.getConnection(url,login,password);
} catch (SQLException ex) {
Error.error(ex.getMessage());
}
where driver = "postgresql.Driver";
and url = ""jdbc:postgresql://host:5432/database";
where host is the name of the host you are connecting to and database the
name of the postgresql database that you want to access.
For more info on how to connect see the postgresql JDBC driver page at
http://www.retep.org.uk/postgres/
Regards
Wim Ceulemans - [EMAIL PROTECTED]
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
