This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Postgres. . .the other white meat Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Postgres. . .the other white meat" Watch "Postgres. . .the other white meat" New topic

Postgres. . .the other white meat

Andrew Shafer
Ranch Hand

Joined: Jan 19, 2001
Posts: 338

Does anybody have any experience working with PostgreSQL?
The "other" open source DB. . .

rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
I have worked with PostgreSQL.
The first problem I ran into was that Postgres has an arcane limit of 8k of data per row. The other - its "serial" data type (the equivalent of MySQL's auto_increment) creates a "sequence" which does not get dropped when its parent table is dropped. So if you try to re-create the table, you'll get a name conflict for this sequence. A lot of new users would be confused by this, so Postgres loses a couple points for that.Postgres' sequence (auto_increment value) does not get reset when you import data, causing all new inserts to fail.

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
Some of the traditional limitations of PostgresSQL are not really there any more. I was intrigued by this article I read recently which compares it surprisingly favourably with mySQL.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Andrew Shafer
Ranch Hand

Joined: Jan 19, 2001
Posts: 338

What version were you using? How long ago?
I'm just curious
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
I managed to get Postgresql installed and running on my RedHat6.2 machine. I want to connect to it using servlets from my Win98 machine running Tomcat. What I have done is to place a copy of the jdbc6.5-1.2.jar file in the Win98 machine and set the classpath to point to it. Start the servlet to make the connection.
However I got a SQL exception message from Tomcat saying:-
can't find class for driver: org.postgresql.Driver.....
I am very sure the classpath was set correctly. I got the same message when I tried to connect to the database in the RedHat6.2 machine (also using servlet and running Tomcat).
Any pointers?
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
Just to add...
I have actually managed to connect to Postgresql a couple of months back using the same technique described above.
I have not touched it for a couple of months and somehow it does not work now.
I agree. Here's the link:
subject: Postgres. . .the other white meat
It's not a secret anymore!