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