From robson@netalfa.com.br Mon Aug  23 20:33:15 1999
Received: from paris.netalfa.com.br ([200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id QAA09167
	for <pgsql-interfaces@postgresql.org>;
	Mon, 23 Aug 1999 16:33:15 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id RAA05472
	for <pgsql-interfaces@postgresql.org>;
	Mon, 23 Aug 1999 17:38:31 -0300 (EST)
Message-ID: <002401beeda5$d89b5d80$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>
Subject: Problem to access postgres database with jdbc using the driver on the
	server side...
Date: Mon, 23 Aug 1999 17:26:56 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0021_01BEED8C.B2F11160"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

This is a multi-part message in MIME format.

------=_NextPart_000_0021_01BEED8C.B2F11160
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello all...
I'm using a applet to access my postgres 6.5 database with jdbc...
I have a driver postgresql.jar, that when it is on my classpath =
everything works good on the page.
But when i remove it from my classpath and try call it from the applet =
tag on the html code it doesnt work and i get the error No suitable =
driver.
I'm using <applet archive=3D"postgresql.jar,Busch.jar" =
code=3D"Busch.class" codebase=3D"./java" width=3D"int" =
height=3D"int"></applet>
I'm using internet explorer 5.0 and netscape 4.6 on windows 98.
Well...what i want to do is make the page access the database using the =
driver on the server side....for anyone that open the page run the page =
correct..
I need this so much....
If anybody can help me....I would like so much...
I'm waiting answer...
Hugz...Robson !!



------=_NextPart_000_0021_01BEED8C.B2F11160
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hello all...</FONT></DIV>
<DIV><FONT size=3D2>I'm using a applet to access my postgres 6.5 =
database with=20
jdbc...</FONT></DIV>
<DIV><FONT size=3D2>I have a driver postgresql.jar, that when it is on =
my=20
classpath everything works good on the page.</FONT></DIV>
<DIV><FONT size=3D2>But when i remove it from my classpath and try call =
it from=20
the applet tag on the html code it doesnt work and i get the error <FONT =

size=3D2><U>No suitable driver</U>.</FONT></FONT></DIV>
<DIV><FONT size=3D2>I'm using &lt;applet =
archive=3D"postgresql.jar,Busch.jar"=20
code=3D"Busch.class" codebase=3D"./java" width=3D"int"=20
height=3D"int"&gt;&lt;/applet&gt;</FONT></DIV>
<DIV><FONT size=3D2>I'm using internet explorer 5.0 and netscape 4.6 on =
windows=20
98.</FONT></DIV>
<DIV><FONT size=3D2>Well...what i want to do is make the page access the =
database=20
using the driver on the server side....for anyone that open the page run =
the=20
page correct..</FONT></DIV>
<DIV><FONT size=3D2>I need this so much....</FONT></DIV>
<DIV><FONT size=3D2>If anybody can help me....I would like so =
much...</FONT></DIV>
<DIV><FONT size=3D2>I'm waiting answer...</FONT></DIV>
<DIV><FONT size=3D2>Hugz...Robson !!</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0021_01BEED8C.B2F11160--




From robson@netalfa.com.br Mon Aug  23 20:54:49 1999
Received: from paris.netalfa.com.br (paris.netalfa.com.br [200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id QAA17285
	for <pgsql-interfaces@postgresql.org>;
	Mon, 23 Aug 1999 16:54:49 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id SAA05560
	for <pgsql-interfaces@postgresql.org>;
	Mon, 23 Aug 1999 18:00:29 -0300 (EST)
Message-ID: <000d01beeda8$e9ed8a60$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.9908240116210.305-100000@helena.jens.de>
Subject: Re: [INTERFACES] Problem to access postgres database with jdbc
	usingthe driver on the server side...
Date: Mon, 23 Aug 1999 17:48:54 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I made everything....
I have put the both .jar
Everything into a .jar
Descopacted the postgresql.jar into the codebase
Descompiled the Busch.jar
Everything....nothing works....
What can be?
Oh Gosh!
[]s Robson....

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


> Hi,
>
> On Mon, 23 Aug 1999, Robson Martins wrote:
> > I'm using <applet archive="postgresql.jar,Busch.jar" code="Busch.class"
codebase="./java" width="int" height="int"></applet>
>
> I've heard a rumor that you can only have *one* jar file loaded at a time.
>
> Then you would have to unjar the postgresql jdbc in your class-files
> directory and pack everything into one jar file ..
>
> But I don't know if that's true (didn't try it myself)
>
> Regards,
>
> --
> Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507
jens@jens.de
>
>




From jens@helena.jens.de Mon Aug  23 21:05:54 1999
Received: from helena.jens.de (blanziflor.jens.de [195.158.35.49])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA20894
	for <pgsql-interfaces@postgresql.org>;
	Mon, 23 Aug 1999 17:05:54 -0400 (EDT)
	(envelope-from jens@helena.jens.de)
Received: from jens by helena.jens.de with local-esmtp (Exim 2.05 #1 (Debian))
	id 11J5Ed-00004w-00; Tue, 24 Aug 1999 01:18:47 +0000
Date: Tue, 24 Aug 1999 01:18:47 +0000 (CEST)
From: Jens Glaser <jens@helena.jens.de>
Reply-To: jens@jens.de
To: Robson Martins <robson@netalfa.com.br>
cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Problem to access postgres database with jdbc using
	the driver on the server side...
In-Reply-To: <002401beeda5$d89b5d80$1ed4d2c8@netalfa.com.br>
Message-ID: <Pine.LNX.4.05.9908240116210.305-100000@helena.jens.de>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi,

On Mon, 23 Aug 1999, Robson Martins wrote:
> I'm using <applet archive="postgresql.jar,Busch.jar" code="Busch.class" codebase="./java" width="int" height="int"></applet>

I've heard a rumor that you can only have *one* jar file loaded at a time.

Then you would have to unjar the postgresql jdbc in your class-files
directory and pack everything into one jar file ..

But I don't know if that's true (didn't try it myself)

Regards,

-- 
Jens Glaser     Am Holderstrauch 13, 36041 Fulda, 0661/9429507    jens@jens.de





From robson@netalfa.com.br Tue Aug  24 11:58:32 1999
Received: from paris.netalfa.com.br (paris.netalfa.com.br [200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA44225
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 07:58:32 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id JAA07590
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 09:04:15 -0300 (EST)
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
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

----- 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 !!




From robson@netalfa.com.br Tue Aug  24 12:26:27 1999
Received: from paris.netalfa.com.br (paris.netalfa.com.br [200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA50773
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 08:26:27 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id JAA07666
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 09:32:14 -0300 (EST)
Message-ID: <000d01beee2b$10188780$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: <002401beeda5$d89b5d80$1ed4d2c8@netalfa.com.br>
	<3774680A.541C129D@uibk.ac.at>
Subject: Re: [INTERFACES] Problem to access postgres database with jdbc using
	the driver on the server side...
Date: Tue, 24 Aug 1999 09:20:32 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

> ----- Original Message -----
> From: root <georg.ritter@uibk.ac.at>
> To: Robson Martins <robson@netalfa.com.br>
> Sent: Saturday, June 26, 1999 2:41 AM
> Subject: Re: [INTERFACES] Problem to access postgres database with jdbc
using the driver on the server > > side...
> Hi
>
> We do it the following way:
>
> We have the applet classes in say ~/applet. Then we unpacked the driver
> to this dir. It works
> perfectly.  (Perhapse you can jar it together again, I havent' tried
> this yet.)
> You then should only get the errormsg with IE5. It seems not to be
> compatible with the standard.
> We worked around this by wrapping the applet for IE  customers with the
> SUN plug in.
>
> btw.,
> "Well...what i want to do is make the page access the database using the
> driver on the server side....
> for anyone that open the page run"
> How should this work? Serverlets?
>
> If need more info you're welcome.
>
>     Georg Ritter

Hello all....Hi Georg...
Ok....I have add the postgresq.jar into my program.jar...everything is on
the same .jar and know works....but you were sure....It doesnt work on ie
5.0....But why work when the postgres is on my classpath? Why it doesnt work
only when the driver is on the server side? Well....What i'll do to make it
works on ie5? I need this working...There is any driver that works?

> How should this work? Serverlets?

I dont know....the page lists houses to sell...that it get from a
database....and i need that everybody entern on the page get it working on
any browser....But i see my actual driver wont work....i need one that
works....

Well...
I'm waiting anser....
Hugs...Robson !!




From robson@netalfa.com.br Tue Aug  24 12:41:15 1999
Received: from paris.netalfa.com.br (paris.netalfa.com.br [200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA54045
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 08:41:15 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id JAA07750
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 09:47:00 -0300 (EST)
Message-ID: <001401beee2d$204b5720$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>
	<001101beee27$2eca55e0$1ed4d2c8@netalfa.com.br>
	<37C28BC8.4CE451D3@uibk.ac.at>
Subject: Re: [INTERFACES] Problem to access postgres database with
	jdbcusingthe driver on the server side...
Date: Tue, 24 Aug 1999 09:35:17 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

> ----- Original Message -----
> From: Georg Ritter <georg.ritter@uibk.ac.at>
> To: Robson Martins <robson@netalfa.com.br>
> Sent: Tuesday, August 24, 1999 9:10 AM
> Subject: Re: [INTERFACES] Problem to access postgres database with
jdbcusingthe driver on the server   > side...
>
> I unpacked the driver to ~/applet/postgresql. (As mentioned it does not
work
> with IE,
> use the SUN plugin)
> --
> ---------------------------------------------------------------------
>   student at department of physics
>   University of Innsbruck, Austria            Georg.Ritter@uibk.ac.at
>

How is the sun plugin? How to get? How to use? Like i wanna mean....Will can
i put this plugin on the server side and everybody will can access the page
with the applet working perfectly?
I need a solution to make it works on the browsers, and without ppl needind
to get anything to make the page work!
I'm waiting answer....
Hugz...Robson !!




From robson@netalfa.com.br Tue Aug  24 14:14:38 1999
Received: from paris.netalfa.com.br (paris.netalfa.com.br [200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA71856
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 10:14:38 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from robson (robson.netlalfa.com.br [200.210.212.30] (may be
 forged))
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id LAA10084
	for <pgsql-interfaces@postgresql.org>;
	Tue, 24 Aug 1999 11:20:23 -0300 (EST)
Message-ID: <00d301beee3a$2c346e20$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: <002401beeda5$d89b5d80$1ed4d2c8@netalfa.com.br>
	<3774680A.541C129D@uibk.ac.at>
	<000d01beee2b$10188780$1ed4d2c8@netalfa.com.br>
Subject: Re: [INTERFACES] Problem to access postgres database with jdbc using
	the driver on the server side...
Date: Tue, 24 Aug 1999 11:08:41 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

> Hello all....Hi Georg...
> Ok....I have add the postgresq.jar into my program.jar...everything is on
> the same .jar and know works....but you were sure....It doesnt work on ie
> 5.0....But why work when the postgres is on my classpath? Why it doesnt
work
> only when the driver is on the server side? Well....What i'll do to make
it
> works on ie5? I need this working...There is any driver that works?
>
> > How should this work? Serverlets?
>
> I dont know....the page lists houses to sell...that it get from a
> database....and i need that everybody entern on the page get it working on
> any browser....But i see my actual driver wont work....i need one that
> works....
>
> Well...
> I'm waiting anser....
> Hugs...Robson !!

I forgot to say that when the driver is on the server side it doesnt work on
any internet explorer only netscape....and when it i on classpath work in
all browsers...