Arjunt...... - Mailing list pgsql-general

hi!
Everybody.

I have written a code to connec to  postgre sql
databse.But i am geting some error.

import java.sql.*;
import java.util.*;
import java.lang.*;



public class LoginPage {
  public static void main(String[] args)
  {
    Connection conn;
    try
    {

    Class.forName("org.postgresql.Driver");
      String url =
"jdbc:postgresql://localhost:5432/test";
      conn = DriverManager.getConnection(url,
"postgres", "viwotec");


      Statement s = conn.createStatement();
      ResultSet r = s.executeQuery("select
oid,id,name,password from myschema.login");
      while( r.next() )
      {


        int id = r.getInt(2);
        System.out.println("Row " + id + ":");

           int oid = r.getInt(2);
        System.out.println("Rowoid " + oid + ":");

/*String nam = r.getString();
        System.out.println("Name of the person" + nam
+ ":");

    String pass = r.getString();
        System.out.println("Password you entered was"
+ pass + ":"); */

      }
      s.close();
      conn.close();
    }
    catch( Exception e )
    {
      e.printStackTrace();
    }
  }
}


and the error is
java.lang.ClassNotFoundException:
org.postgresql.Driver
        at
java.net.URLClassLoader$1.run(URLClassLoader.java:199)
        at
java.security.AccessController.doPrivileged(Native
Method)
        at
java.net.URLClassLoader.findClass(URLClassLoader.java:187)
        at
java.lang.ClassLoader.loadClass(ClassLoader.java:289)
        at
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
        at
java.lang.ClassLoader.loadClass(ClassLoader.java:235)
        at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:141)
        at LoginPage.main(LoginPage.java:14)

please tell me solution for this...How i can load the
driver and where

--- Shachar Shemesh <shachar@lingnu.com> wrote:

> pwbyrne@hotmail.com wrote:
>
> >Hi,
> >
> >I'm looking for details, or tools about porting a
> full Ms Sql Server
> >2000 database to Postgres on Linux.
> >
> >Is this possible?  We have the whole nine yards,
> stored procedures,
> >triggers, and all.
> >
> >Is there a way to automate this process?
> >
> >Thanks
> >
> >
> Totally automate - no.
>
> There are tools to help you along, however. They
> are not as complete as
> I would like them, and I need lots of help in
> maintaining the site. It's
> located at http://pgfoundry.org/projects/sql2pg/,
> but there are
> currently no released files. In CVS, however, you
> will find a perl
> script that translates the exported database
> description from MS SQL to
> a more-or-less PG friendly format. Also you will
> find there support for
> two data types - varcharci (case insensitive) and
> utinyint (1 byte
> unsigned integer).
>
> Any help with maintaining this project would be
> greatly appreciated.
>
> I do have a few questions for you. What drivers do
> you currently use to
> access your database? Do you use the stored
> procedure's ability to
> return more than one result?
>
>                 Shachar
>
> --
> Shachar Shemesh
> Lingnu Open Source Consulting ltd.
> http://www.lingnu.com/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
>       subscribe-nomail command to
> majordomo@postgresql.org so that your
>       message can get through to the mailing list
> cleanly
>




__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo