using large objects with jdbc/odbc
От | John Thorhauer |
---|---|
Тема | using large objects with jdbc/odbc |
Дата | |
Msg-id | 39A15037.96FC0076@phoenixcolor.com обсуждение исходный текст |
Список | pgsql-interfaces |
I am successfully using large objects in postgres with the latest version of postgtres and the latest jdbc driver (thanks to a lot of help from this list :-)) However, I need to make sure that my table is accessible from both jdbc and odbc drivers. I need to make sure that programs that utilize the odbc driver for postgres can also access large object data in the same table that the jdbc driver is accessing the data. So I thought that I would have to define the large object field as type 'lo' instead of 'oid'. But then jdbc wont recognize it. So I tried defining a type in the org.postgres.Field.java of 'lo' as VARBINARY and also tried it as INTEGER, hoping that the driver would then recognize the type of lo in the table but it did not work and I get the following error: Attribute 'fieldA' is of type 'lo' but expression is of type 'int4' Any ideas on this? Is it possible to even do this or should I go back to the drawing board? Thanks, John -- ******************************** ** John Thorhauer ** jthorhauer@phoenixcolor.com ********************************
В списке pgsql-interfaces по дате отправления: