| From: Joakim Verona [mailto:[EMAIL PROTECTED]]
| Subject: using postgres jdbc driver in tomcat
|
| im using the postgress jdbc driver in tomcat, with the poolman
| connection pooling package.
|
| it works well, but there is a strange limit on the lengths of texts
| that are possible to insert, i can only insert about 8k long
| texts using the setString function.
The current production version of Postgres has a compile-time upper limit
(of 8k) on how big a table row can be. To store things bigger than that
without splitting them up, you will need to use "large objects". For more
details, search the Postgres manuals for "large objects", but be warned that
the current Postgres JDBC driver only implements a handful of methods in the
JDBC API (enough to get the job done, but only just), and even the JDBC
large object examples in the manual use API methods that are not implemented
(i.e., don't believe what the manual says you can do, you have to test Test
TEST).
