Thread: please checkits urgent

please checkits urgent

From

"durga prasad"

Date:

17 July 2007, 16:43:52

iam durga prasad,

iam using Postgresql8.2 when iam trying to connect the driver is not working (org.postgresql.Driver) can please send me the driver class of java to connect to DB,please revert to me immediately following code i have used: pls correct and revert tome

import java.sql.*;
import java.io.*;
class Conc {
public static void main(String[] args) throws Exception {

//Class.forName(" JDBC Driver goes here");

Class.forName("org.postgresql.Driver");

//jdbc:postgresql://host:port/database

Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","poks","aqswdefr");

Statement stmt=con.createStatement();

  //system.out.println("Creating Table---->");
  //stmt.executeUpdate("Create table emp(eid int, ename varchar2(12))");

                System.out.println("Inserting row--->");
  stmt.executeUpdate("Insert into emp values('bbbb',2)");
  System.out.println("One row is Inserted.....");

                System.out.println("Getting data ---->");

  ResultSet rs=stmt.executeQuery("select * from emp");

  while(rs.next())
  System.out.println(rs.getInt(1)+" "+rs.getString(2));

  rs.close();
  stmt.close();
  con.close();
} //main()
} //class

Re: please checkits urgent

From

Guy Rouillier

Date:

17 July 2007, 18:11:51

durga prasad wrote:
> hi
>
>  iam durga prasad,
>
>                          iam  using Postgresql8.2 when iam trying to
> connect the driver is not working (org.postgresql.Driver) can please
> send me the driver class of java to connect to DB,please revert to me
> immediately following code i have used:   pls correct and revert tome
>

You would get more relevant responses if you told us the error you are
receiving.  Most likely, you are encountering a classpath problem.  Make
sure the PG JAR file is in your runtime classpath.  Your code below
looks fine.

>
>
>
> import java.sql.*;
> import java.io.*;
> class Conc {
>  public static void main(String[] args) throws Exception {
>
>   //Class.forName(" JDBC Driver goes here");
>
>                   Class.forName("org.postgresql.Driver");
>
>                  //jdbc:postgresql://host:port/database
>
>   Connection
> con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","poks","aqswdefr");
>
>
>
>   Statement stmt=con.createStatement();
>
>   //system.out.println("Creating Table---->");
>   //stmt.executeUpdate("Create table emp(eid int, ename varchar2(12))");
>
>                 System.out.println("Inserting row--->");
>   stmt.executeUpdate("Insert into emp values('bbbb',2)");
>   System.out.println("One row is Inserted.....");
>
>                 System.out.println("Getting data ---->");
>
>   ResultSet rs=stmt.executeQuery("select * from emp");
>
>   while(rs.next())
>   System.out.println(rs.getInt(1)+"  "+rs.getString(2));
>
>   rs.close();
>   stmt.close();
>   con.close();
>  } //main()
> } //class
>


--
Guy Rouillier