Message-ID: <001101beee27$2eca55e0$1ed4d2c8@netalfa.com.br>
Reply-To: "Robson Martins" <robson@netalfa.com.br>
From: "Robson Martins" <robson@netalfa.com.br>
To: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
References: <Pine.LNX.4.05.9908240143090.444-100000@helena.jens.de>
Subject: Re: [INTERFACES] Problem to access postgres database with
	jdbcusingthe driver on the server side...
Date: Tue, 24 Aug 1999 08:52:45 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

----- Original Message -----
From: Jens Glaser <jens@helena.jens.de>
To: Robson Martins <robson@netalfa.com.br>
Sent: Monday, August 23, 1999 10:45 PM
Subject: Re: [INTERFACES] Problem to access postgres database with
jdbcusingthe driver on the server side...


> Hi,
>
> On Mon, 23 Aug 1999, Robson Martins wrote:
> > Everything....nothing works....
>
> You did use Class.forName to load the pgsql-driver (postgresql.Driver) ?
> (or the property jdbc.drivers, but not sure if that's possible with
> applets)
> You supplied the correct URL to getconnection ?
>
> --
> Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507
jens@jens.de
>

The code below is what i'm using on my applet, i think it works with applet,
cause work swhen the postgresql.jar is my classpath, and I have read
anything about put the driver on the server side, I dunno...

  try {
   Class.forName("postgresql.Driver");
   co =
DriverManager.getConnection("jdbc:postgresql://myhost/mydb","username","pass
word");
   st = co.createStatement();
   rs = st.executeQuery("select * from tablename");
   if (rs != null) {
    while ( rs.next() ) {
      doanything
    }
   }
   rs.close();
  }
  catch (Exception e1) {}

Well......:((
I need this so much...
Anybody help me!
Hugs..Robson !!