PLS HELP in connecting with jdbc driver

From: "Rohit Johry" <rohit(dot)johry(at)esteltelecom(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: PLS HELP in connecting with jdbc driver
Date: 2003-04-03 05:33:40
Message-ID: 004201c2f9a2$9a631c80$9000000a@estelcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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
{
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);
}
}
}

I am not professional in Linux.
Hoping you will replay me very soon.

With regards,
Rohit

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Csaba Nagy 2003-04-03 08:55:09 Re: Jdbc3PoolingDataSource default auto commit is false
Previous Message Joseph Shraibman 2003-04-03 05:30:38 Re: SQLException : Unknown Response Type