Re: please checkits urgent - Mailing list pgsql-jdbc

From Guy Rouillier
Subject Re: please checkits urgent
Date
Msg-id 469D064D.5020809@burntmail.com
Whole thread Raw
In response to please checkits urgent  ("durga prasad" <kdgprasad@gmail.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "durga prasad"
Date:
Subject: please checkits urgent
Next
From: Tonio Caputo
Date:
Subject: Index scan with like expressions