Connection problem

From: Ripon Al Wasim <riponc007(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Connection problem
Date: 2003-08-04 06:37:19
Message-ID: 20030804063719.39549.qmail@web14005.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hello,
I wanna connet between java and PostgreSQL. Here is the code:

import java.sql.*;
public class DBConnection
{
public void connection()
{
String pgsqlDriver = "org.postgresql.Driver";
//String pgsqlURL = "jdbc:postgresql://host:5432/mydb";
String pgsqlURL = "jdbc:postgresql://192.168.0.165/testdb";
String pgsqlUser = "User";
String pgsqlPW = "password";
String pgsqlQuery = null;
Connection pgsqlConn = null;
Statement pgsqlStatement = null;
ResultSet pgsqlRSet = null;
try
{
Class.forName(pgsqlDriver);
pgsqlConn = DriverManager.getConnection(pgsqlURL, pgsqlUser, pgsqlPW);
pgsqlStatement = pgsqlConn.createStatement();
pgsqlQuery = "SELECT * FROM users;";
pgsqlRSet = pgsqlStatement.executeQuery(pgsqlQuery);
}
catch (ClassNotFoundException cnfe)
{
System.out.println("Could not load database driver:" + cnfe.getMessage());
}
catch (SQLException sqle)
{
System.out.println("Could not connect to the database: " + sqle.getMessage());
}
finally
{
try
{
if ( pgsqlConn != null )
{
// Close the connection no matter what.
pgsqlConn.close();
}
}
catch (SQLException sqle)
{
System.out.println("Could not connect to the database(2): " + sqle.getMessage());
}
}//finally
}//end connection()
public static void main(String args[])
{
new DBConnection().connection();
}
}//class

The code is compile well. But here is a runtime problem. The prolem is:

Could not load database driver :org.postgresql.Driver

Is there anybody to help me?

thanking u,
Ripon

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Csaba Nagy 2003-08-04 08:48:38 Re: server side resultset search (for performance reasons)
Previous Message Renaud Waldura 2003-08-04 06:00:58 PostgreSQL & TopLink