pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [QUESTIONS] JDBC
13+ messages / 12 participants
[nested] [flat]
* Re: [QUESTIONS] JDBC
@ 1998-03-12 05:58 Peter T Mount <postgresdev@maidast.demon.co.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Peter T Mount @ 1998-03-12 05:58 UTC (permalink / raw)
To: Wolfgang Maron <Wolfgang_Maron@compuserve.com>; +Cc: pgsql-interfaces
[redirected to correct list]
On Wed, 11 Mar 1998, Wolfgang Maron wrote:
> Hello,
>
> I have tried to compile the JDBC driver in Postgresql-6.3 but without
> success.Linux-2.0.29. See appended file. What is to do? Can you help me?
> Thanks.
>
> Wolfgang
What version of the JDK have you got, and did you use make to compile?
--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [QUESTIONS] JDBC
@ 1998-03-12 17:10 Peter T Mount <postgresdev@maidast.demon.co.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Peter T Mount @ 1998-03-12 17:10 UTC (permalink / raw)
To: Wolfgang Maron <Wolfgang_Maron@compuserve.com>; +Cc: pgsql-interfaces
On Thu, 12 Mar 1998, Wolfgang Maron wrote:
> I have tried to compile the JDBC driver in Postgresql-6.3 but without
> > success.Linux-2.0.29. See appended file. What is to do? Can you help me?
> > Thanks.
> >
> > Wolfgang
>
> What version of the JDK have you got, and did you use make to compile?
>
> Version JDK 1.0.2pl2 SuSE distribution 4.4.1
> I have used make in the tree from postgresql-6.3
> Where must be the files for import? In my JDK tree I have not a file
> java.math or java.sql.
Sorry, but JDK1.0.2 isn't supported. You'll need JDK 1.1 or later for the
driver to work.
It's dependent on several new features like inner classes, but mainly the
JDBC API is different between the two major versions of the JDK.
The java.math and java.sql are two of several new packages that are
included in the 1.1 JDK.
--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 13+ messages in thread
* jdbc
@ 2000-01-10 17:39 EDEden@magellanhealth.com
2000-01-10 18:46 ` Re: [INTERFACES] jdbc Peter Mount <peter@retep.org.uk>
0 siblings, 1 reply; 13+ messages in thread
From: EDEden@magellanhealth.com @ 2000-01-10 17:39 UTC (permalink / raw)
To: pgsql-interfaces
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I compiled the example imageview and need to hit init_db twice to get
it to create the table. I also made my own program to create a table
thru one button and drop the same table thru another button, and it
does the same thing. I need to press the button twice to get it to
add or drop the table. Like it's not doing the commit?
-----BEGIN PGP SIGNATURE-----
Version: PGP Personal Privacy 6.5.2
iQA/AwUBOHoZZThfv8urDgXTEQJKXgCg/cN5KSj98N4/hGkM3RDFODsEyMMAoPYz
EbLG4epWD7pGmhC/7/5zOyE2
=CKoW
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [INTERFACES] jdbc
2000-01-10 17:39 jdbc EDEden@magellanhealth.com
@ 2000-01-10 18:46 ` Peter Mount <peter@retep.org.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Peter Mount @ 2000-01-10 18:46 UTC (permalink / raw)
To: EDEden@magellanhealth.com; +Cc: pgsql-interfaces
On Mon, 10 Jan 2000 EDEden@magellanhealth.com wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I compiled the example imageview and need to hit init_db twice to get
> it to create the table. I also made my own program to create a table
> thru one button and drop the same table thru another button, and it
> does the same thing. I need to press the button twice to get it to
> add or drop the table. Like it's not doing the commit?
Hmmm, it should be. I was planning (if I had time) of rewriting the
examples other than ImageViewer. I've added it to my list of things to fix
in 7.0
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 13+ messages in thread
* JDBC
@ 2000-08-11 13:37 Christian Herbert <christian@oven.com>
2000-08-11 14:15 ` Re: JDBC Rachel Greenham <rachel.greenham@enetgroup.co.uk>
0 siblings, 1 reply; 13+ messages in thread
From: Christian Herbert @ 2000-08-11 13:37 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Hi,
Could someone make an educated suggestion which JDBC driver would work best
with the PostgreSQL 7.0.2 database???
Christian HERBERT
Web Programmer
WWW.OVEN.COM
THE OLD TRUMAN BREWERY
91 BRICK LANE
LONDON E1 6QL
T: 020-7247-4778
F: 020-7247-9448
M: 07946-507-317
E: christian@oven.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: JDBC
2000-08-11 13:37 JDBC Christian Herbert <christian@oven.com>
@ 2000-08-11 14:15 ` Rachel Greenham <rachel.greenham@enetgroup.co.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Rachel Greenham @ 2000-08-11 14:15 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Christian Herbert wrote:
>
> Hi,
>
> Could someone make an educated suggestion which JDBC driver would work best
> with the PostgreSQL 7.0.2 database???
The one supplied. :-) If you have the source, go into src/interfaces/jdbc
and type "make jdbc1" or "make jdbc2"
A postgresql.jar is generated. The JDBC driver is org.postgresql.Driver.
--
Rachel
^ permalink raw reply [nested|flat] 13+ messages in thread
* RE: JDBC
@ 2000-08-11 14:08 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Peter Mount @ 2000-08-11 14:08 UTC (permalink / raw)
To: 'Christian Herbert' <christian@oven.com>; pgsql-interfaces@hub.org
The one supplied with 7.0.2?
Seriously, apart from 6.5.3, the driver thats released with the backend is
normally the better one to use.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council
-----Original Message-----
From: Christian Herbert [mailto:christian@oven.com]
Sent: Friday, August 11, 2000 2:37 PM
To: pgsql-interfaces@hub.org
Subject: [INTERFACES] JDBC
Hi,
Could someone make an educated suggestion which JDBC driver would work best
with the PostgreSQL 7.0.2 database???
Christian HERBERT
Web Programmer
WWW.OVEN.COM
THE OLD TRUMAN BREWERY
91 BRICK LANE
LONDON E1 6QL
T: 020-7247-4778
F: 020-7247-9448
M: 07946-507-317
E: christian@oven.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* jdbc
@ 2000-12-28 03:01 Wayne Davis <wfdavis@seas.upenn.edu>
2000-12-28 10:43 ` Re: jdbc Ingo Luetkebohle <ingo@blank.pages.de>
2000-12-29 01:01 ` Re: jdbc John DeSoi <desoi@icx.net>
0 siblings, 2 replies; 13+ messages in thread
From: Wayne Davis @ 2000-12-28 03:01 UTC (permalink / raw)
To: pgsql-interfaces
I'm having trouble getting the postgresql jdbc driver to work. Here's my error:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
at DBBean.<init>(DBBean.java, Compiled Code)
at DBBean.main(DBBean.java, Compiled Code)
I'm running Linux with the 1.2.2 jdk.
I'm running pgsql 7.0.2.
CLASSPATH=/usr/lib/pgsql/jdbc7.0-1.2.jar:.
Any help would be appreciated.
Wayne
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: jdbc
2000-12-28 03:01 jdbc Wayne Davis <wfdavis@seas.upenn.edu>
@ 2000-12-28 10:43 ` Ingo Luetkebohle <ingo@blank.pages.de>
1 sibling, 0 replies; 13+ messages in thread
From: Ingo Luetkebohle @ 2000-12-28 10:43 UTC (permalink / raw)
To: Wayne Davis <wfdavis@seas.upenn.edu>; +Cc: pgsql-interfaces
Did you use 'Class.forName("org.postgresql.Driver")', to preload the
driver prior to calling getConnection?
On Wed, Dec 27, 2000 at 10:01:09PM -0500, Wayne Davis wrote:
> I'm having trouble getting the postgresql jdbc driver to work. Here's my error:
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
> at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
> at DBBean.<init>(DBBean.java, Compiled Code)
> at DBBean.main(DBBean.java, Compiled Code)
>
> I'm running Linux with the 1.2.2 jdk.
> I'm running pgsql 7.0.2.
>
> CLASSPATH=/usr/lib/pgsql/jdbc7.0-1.2.jar:.
>
> Any help would be appreciated.
>
> Wayne
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: jdbc
2000-12-28 03:01 jdbc Wayne Davis <wfdavis@seas.upenn.edu>
@ 2000-12-29 01:01 ` John DeSoi <desoi@icx.net>
1 sibling, 0 replies; 13+ messages in thread
From: John DeSoi @ 2000-12-29 01:01 UTC (permalink / raw)
To: Wayne Davis <wfdavis@seas.upenn.edu>; pgsql-interfaces
At 10:01 PM -0500 12/27/00, Wayne Davis wrote:
>I'm having trouble getting the postgresql jdbc driver to work.
>Here's my error:
>java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(DriverManager.java,
>Compiled Code)
> at java.sql.DriverManager.getConnection(DriverManager.java,
>Compiled Code)
> at DBBean.<init>(DBBean.java, Compiled Code)
> at DBBean.main(DBBean.java, Compiled Code)
Maybe you had the same naming issue I found (see below).
John DeSoi, Ph.D.
-------
X-From_: desoi@icx.net Wed Dec 20 10:57:45 2000
X-Sender: desoi@mailhub.icx.net (Unverified)
Date: Wed, 20 Dec 2000 10:55:39 -0500
To: peter@retep.org.uk
From: John DeSoi <desoi@icx.net>
Subject: JDBC documentation error
Hi Peter,
I'm just getting started with postgres and JDBC. I wanted to mention
a documentation error that might cause considerable pain for other
newbies like me :)
You have:
In the first method, your code implicitly loads the driver using the
Class.forName() method. For Postgres, you would use:
Class.forName("postgresql.Driver");
In using this, my application kept crashing (of course it should have
given me an error message, but for some reason it just crashed). I
finally got things working by changing it to
Class.forName("org.postgresql.Driver");
Thanks for all your work,
John DeSoi, Ph.D.
^ permalink raw reply [nested|flat] 13+ messages in thread
* JDBC
@ 2001-01-06 17:39 Jarek <s0553@pjwstk.waw.pl>
0 siblings, 0 replies; 13+ messages in thread
From: Jarek @ 2001-01-06 17:39 UTC (permalink / raw)
To: pgsql-interfaces
I would be very hapy if I could use Serialization into postgtres db.
I have read all docs that are in distribution. More than that ... I looked at
sources of JDBC driver. Still nothing .
IS THRE ANY HELP, EXAMPLE, OR TUTORIAL ABOUT
Class Serialize ?
How to use it ?
What should be called firs Serialize.create() or new Serialize ?
I will be very thankfull for any help!
--
MS is not the answer.
MS is the question.
NO (or Linux) is the answer.
:) Jarek (:
^ permalink raw reply [nested|flat] 13+ messages in thread
* JDBC
@ 2001-03-06 15:06 Enrico Comini <algobit@algobit.com>
2001-03-06 15:11 ` Re: JDBC Peter T Mount <peter@retep.org.uk>
0 siblings, 1 reply; 13+ messages in thread
From: Enrico Comini @ 2001-03-06 15:06 UTC (permalink / raw)
To: pgsql-interfaces
I'm testing the jdbc with postgresql (I have Forte for J), but the primary
key of my table isn't visible and is impossible add, edit ecc ecc. I have
PGSQL 7.01 and use the correct driver. I have to install 7.1 ?
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: JDBC
2001-03-06 15:06 JDBC Enrico Comini <algobit@algobit.com>
@ 2001-03-06 15:11 ` Peter T Mount <peter@retep.org.uk>
0 siblings, 0 replies; 13+ messages in thread
From: Peter T Mount @ 2001-03-06 15:11 UTC (permalink / raw)
To: algobit@algobit.com, Enrico Comini <algobit@algobit.com>; +Cc: pgsql-interfaces
Quoting Enrico Comini <algobit@algobit.com>:
> I'm testing the jdbc with postgresql (I have Forte for J), but the
> primary
> key of my table isn't visible and is impossible add, edit ecc ecc. I
> have
> PGSQL 7.01 and use the correct driver. I have to install 7.1 ?
Primary Key support (in JDBC) is part of 7.1 (and was working when I looked
this morning).
Peter
--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2001-03-06 15:11 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-03-12 05:58 Re: [QUESTIONS] JDBC Peter T Mount <postgresdev@maidast.demon.co.uk>
1998-03-12 17:10 Re: [QUESTIONS] JDBC Peter T Mount <postgresdev@maidast.demon.co.uk>
2000-01-10 17:39 jdbc EDEden@magellanhealth.com
2000-01-10 18:46 ` Re: [INTERFACES] jdbc Peter Mount <peter@retep.org.uk>
2000-08-11 13:37 JDBC Christian Herbert <christian@oven.com>
2000-08-11 14:15 ` Rachel Greenham <rachel.greenham@enetgroup.co.uk>
2000-08-11 14:08 RE: JDBC Peter Mount <petermount@it.maidstone.gov.uk>
2000-12-28 03:01 jdbc Wayne Davis <wfdavis@seas.upenn.edu>
2000-12-28 10:43 ` Re: jdbc Ingo Luetkebohle <ingo@blank.pages.de>
2000-12-29 01:01 ` Re: jdbc John DeSoi <desoi@icx.net>
2001-01-06 17:39 JDBC Jarek <s0553@pjwstk.waw.pl>
2001-03-06 15:06 JDBC Enrico Comini <algobit@algobit.com>
2001-03-06 15:11 ` Peter T Mount <peter@retep.org.uk>
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