Thread: connectivity problem

connectivity problem

From
adp adp
Date:
You asked for code,it is given below:

and the classpath is:
exportCLASSPATH=/root/j2sdk1.4.2/bin/test1.java:/root/j2sdk_nb/j2sdk1.4.2/jre/lib/ext/pg73jdbc3.jar:.


import java.sql.*;
class test2{
  public static void main (String args[]) {


     try{


         Class.forName("postgresql.Driver");
        // DriverManager.registerDriver(new (Driver));




      String url="jdbc:postgresql:test";
      Connection con =
DriverManager.getConnection(url, "postgres", "");
      Statement stm= con.createStatement();


stm.setQueryTimeout(10);
ResultSet rs = stm.executeQuery("select col1 from
test1");


rs.next();


System.out.println(rs.getString(1));
}catch(ClassNotFoundException  e) {




 System.out.println("Exception");
 System.out.println(e.toString());
}
 catch(SQLException e) {




 System.out.println("Exception");
 System.out.println(e.toString());
}
}
}


please help me I have been trying to get connectivity
for a long time.

________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com

Re: connectivity problem

From
Kris Jurka
Date:

On Fri, 30 Jan 2004, [iso-8859-1] adp adp wrote:

> import java.sql.*;
> class test2{
>   public static void main (String args[]) {
>
>      try{
>
>          Class.forName("postgresql.Driver");


This should be Class.forName("org.postgresql.Driver");

Kris Jurka