Thread: PLS HELP in connecting with jdbc driver
Hello,
I am a new user using the Postgre-sql for the first time please help me in establishing the connection between JDBC and POSTGRE.
POSTGRE >> 7.2.1
JAVA >> 1.4.1_01
LINUX >> 7.3
Having the CLASSPATH:
:/usr/share/pgsql/jdbc7.2dev-1.2.jar:/usr/lib/pgsql/pg72jdbc2.jar:/usr/java/j2sdk1.4.1_01/lib/*.jar
I got ERROR as
Sub : java.lang.ClassNotFoundException: org.postgresql:Driver
Rohit : java.sql.SQLException: No suitable driver
Here is my CODE "JDBC_POSTGRE.java"
import java.sql.*;
class JDBC_POSTGRE
{
public static void main(String args[])
{
Statement stmt1;
ResultSet rs1;
DatabaseMetaData dbmd1;
try
{
try
{
{
public static void main(String args[])
{
Statement stmt1;
ResultSet rs1;
DatabaseMetaData dbmd1;
try
{
try
{
Class.forName("org.postgresql.Driver");
//Driver for POSTGRE-SQL :pg72jdbc2.jar
}
catch(Exception ex)
{
System.out.println("Sub : " + ex);
}
Connection conn1 = DriverManager.getConnection("jdbc:postgresql:AirTel_RTL", "", "");
//AirTel_RTL is a database, user='', password=''
stmt1 = conn1.createStatement();
rs1 = stmt1.executeQuery("Select * from tonedata"); // 'tonedata' is a table in database
while(rs1.next())
{
System.out.println(rs1.getInt("toneid") + "," + rs1.getString("tone_name") );
}
}
catch(Exception e)
{
System.out.println("Rohit : "+e);
}
}
}
//Driver for POSTGRE-SQL :pg72jdbc2.jar
}
catch(Exception ex)
{
System.out.println("Sub : " + ex);
}
Connection conn1 = DriverManager.getConnection("jdbc:postgresql:AirTel_RTL", "", "");
//AirTel_RTL is a database, user='', password=''
stmt1 = conn1.createStatement();
rs1 = stmt1.executeQuery("Select * from tonedata"); // 'tonedata' is a table in database
while(rs1.next())
{
System.out.println(rs1.getInt("toneid") + "," + rs1.getString("tone_name") );
}
}
catch(Exception e)
{
System.out.println("Rohit : "+e);
}
}
}
I am not professional in Linux.
Hoping you will replay me very soon.
With regards,
Rohit
Rohit,
You should consider removing wild cards from your classpath. Also, it is unusual to explicitly reference jars from the JRE/JDK in your classpath. You might also want to limit yourself to a single postgres jar file in your classpath.
----- Original Message -----From: Rohit JohrySent: Thursday, April 03, 2003 3:33 PMSubject: [JDBC] PLS HELP in connecting with jdbc driverHello,I am a new user using the Postgre-sql for the first time please help me in establishing the connection between JDBC and POSTGRE.Having the CLASSPATH::/usr/share/pgsql/jdbc7.2dev-1.2.jar:/usr/lib/pgsql/pg72jdbc2.jar:/usr/java/j2sdk1.4.1_01/lib/*.jarI got ERROR asSub : java.lang.ClassNotFoundException: org.postgresql:DriverRohit : java.sql.SQLException: No suitable driverI am not professional in Linux.Hoping you will replay me very soon.