pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem to access postgres database with jdbc using the driver on the server side...
7+ messages / 2 participants
[nested] [flat]
* Problem to access postgres database with jdbc using the driver on the server side...
@ 1999-08-23 20:26 Robson Martins <robson@netalfa.com.br>
1999-08-24 01:18 ` Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side... Jens Glaser <jens@helena.jens.de>
1999-08-24 12:20 ` Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
0 siblings, 2 replies; 7+ messages in thread
From: Robson Martins @ 1999-08-23 20:26 UTC (permalink / raw)
To: pgsql-interfaces
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="postgresql.jar,Busch.jar" code="Busch.class" codebase="./java" width="int" height="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 !!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side...
1999-08-23 20:26 Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
@ 1999-08-24 01:18 ` Jens Glaser <jens@helena.jens.de>
1999-08-23 20:48 ` Re: [INTERFACES] Problem to access postgres database with jdbc usingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
1 sibling, 1 reply; 7+ messages in thread
From: Jens Glaser @ 1999-08-24 01:18 UTC (permalink / raw)
To: Robson Martins <robson@netalfa.com.br>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbc usingthe driver on the server side...
1999-08-23 20:26 Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
1999-08-24 01:18 ` Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side... Jens Glaser <jens@helena.jens.de>
@ 1999-08-23 20:48 ` Robson Martins <robson@netalfa.com.br>
0 siblings, 0 replies; 7+ messages in thread
From: Robson Martins @ 1999-08-23 20:48 UTC (permalink / raw)
To: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side...
1999-08-23 20:26 Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
@ 1999-08-24 12:20 ` Robson Martins <robson@netalfa.com.br>
1999-08-24 14:08 ` Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
1 sibling, 1 reply; 7+ messages in thread
From: Robson Martins @ 1999-08-24 12:20 UTC (permalink / raw)
To: pgsql-interfaces
> ----- 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 !!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side...
1999-08-23 20:26 Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
1999-08-24 12:20 ` Re: [INTERFACES] Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
@ 1999-08-24 14:08 ` Robson Martins <robson@netalfa.com.br>
0 siblings, 0 replies; 7+ messages in thread
From: Robson Martins @ 1999-08-24 14:08 UTC (permalink / raw)
To: pgsql-interfaces
> 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...
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side...
@ 1999-08-24 11:52 Robson Martins <robson@netalfa.com.br>
1999-08-24 12:35 ` Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
0 siblings, 1 reply; 7+ messages in thread
From: Robson Martins @ 1999-08-24 11:52 UTC (permalink / raw)
To: pgsql-interfaces
----- 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 !!
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side...
1999-08-24 11:52 Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
@ 1999-08-24 12:35 ` Robson Martins <robson@netalfa.com.br>
0 siblings, 0 replies; 7+ messages in thread
From: Robson Martins @ 1999-08-24 12:35 UTC (permalink / raw)
To: pgsql-interfaces
> ----- 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 !!
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~1999-08-24 14:08 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-23 20:26 Problem to access postgres database with jdbc using the driver on the server side... Robson Martins <robson@netalfa.com.br>
1999-08-24 01:18 ` Jens Glaser <jens@helena.jens.de>
1999-08-23 20:48 ` Re: [INTERFACES] Problem to access postgres database with jdbc usingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
1999-08-24 12:20 ` Robson Martins <robson@netalfa.com.br>
1999-08-24 14:08 ` Robson Martins <robson@netalfa.com.br>
1999-08-24 11:52 Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
1999-08-24 12:35 ` Re: [INTERFACES] Problem to access postgres database with jdbcusingthe driver on the server side... Robson Martins <robson@netalfa.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox