Log exerpt while retrieving image from a bytea in PostgreSQL 7.2.1

[Andr� van Toly]

Hi,

While retrieving an image from MMBase using PostgreSQL 7.2.1 and the
new driver jdbc7.2dev-1.2.jar i got the following errors in our log.

2002-08-01 17:30:47,262 INFO  module.database.support.PostgreSQL71
getShortedByte.?  - gonna excute the followin query: SELECT handle
FROM install_images WHERE number = 1713
2002-08-01 17:30:47,264 ERROR module.database.support.PostgreSQL71
getShortedByte.?  - could not retrieve the field :handle of
object(1713) of type : images
2002-08-01 17:30:47,265 ERROR module.database.support.PostgreSQL71
getShortedByte.?  - Bad Integer
GIF89a(\000(\000\367\0001\377\377\377\377\377\377\377\377\377 etc.
etc.

I altered the type mapping in config/databases/postgresql71.xml to:

  <type-mapping mmbase-type="BYTE">bytea</type-mapping>

       Table "install_images"
    Column    |  Type   | Modifiers
-------------+---------+-----------
  number      | integer | not null
  otype       | integer | not null
  owner       | text    | not null
  title       | text    | not null
  description | text    | not null
  handle      | bytea   | not null
  itype       | text    | not null

i'm sorry, my messages always seem to come in pairs ;-)

---Cheers, Andr�
--

Andr� van Toly
CMS Developer for ilse media b.v.
[EMAIL PROTECTED]
+31-(0)20-8404559