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