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