aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Postgres. . .the other white meat" Watch "Postgres. . .the other white meat" New topic
Author

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


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

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 frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Andrew Shafer
Ranch Hand

Joined: Jan 19, 2001
Posts: 338

Parmeet,
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: http://aspose.com/file-tools
 
subject: Postgres. . .the other white meat