I've been experimenting with some versions of PostgreSQL JDBC trying to find 
a version that suits the our application:

1) It has to support portuguese characters (like αινσϊ etc) directly in SQL 
2) It is desiderable that it supports SQL statements longer than 8k.

Unfortunately the only version I found that seems to address both problems 
above (version 7.1-1.2 from jdbc.postgresql.org) seems to be broken in 
relation to data types (not gone deeper into that, yet).

Anyway what I would like to ask is if there is a way to use "Large Object" 
code to overcome statement length restrictions in the 7.0 series drivers 
(which work ok except for that). A detail is that I use FUNCTIONs for 
performing INSERT/UPDATE (as if the FUNCTION was a "stored procedure", that 
does UPDATE or INSERT when appropriate):

SELECT registerData('my_primary_key', 'a very very long text string')

Is there a way I can do that using

PreparedStatement ps = conn.prepareStatement("SELECT registerData(?,?)");
ps.SetString(1, "my_primary_key");
ps.SetString(2, "a very very very very long string");

That way I could use a more stable driver with long datasets.
Is it possible? Are the LOB functions stable?
Thanks a lot!

Ricardo Pardini

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to