JDBC version
От | Ricardo Pardini |
---|---|
Тема | JDBC version |
Дата | |
Msg-id | 200108282041.f7SKfNf96950@postgresql.org обсуждение исходный текст |
Ответы |
Re: JDBC version
|
Список | pgsql-jdbc |
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 queries. 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 rpardini@organox.com.br
В списке pgsql-jdbc по дате отправления: