Hello Nico, I use PostgreSQL version 7.2 and my blob is saved in a bytea field. Could it be a java 1.4 problem?
Peter van der Meer Software Developer VARA Nieuwe Media -----Oorspronkelijk bericht----- Van: Nico Klasens [mailto:[EMAIL PROTECTED] Verzonden: woensdag 12 november 2003 11:06 Aan: [EMAIL PROTECTED] Onderwerp: RE: MMbase - PostgreSQL - Images problem Hello Peter, Examining the stacktrace I notice that you use the database support classes and not the storage classes. IIRC the storage classes only support the blobs on the file system. Which postgresql file are you using. Postgres71.xml or postgres72.xml? Saving blobs is different in these files. I guess the 7.3.2 version is from the driver. With the 7.3 driver you have to use the BYTEA field instead of the OID, so you are fine with that. What version of the database server are you using? We are running Web-In-A-Box on postgresql 7.2 server and 7.3.1 driver. We are using the postgres72.xml at the moment without any blob issues (The mmbase version is 1.6.3). Nico Klasens Finalist IT Group Java Specialists > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Peter van der Meer > Verzonden: dinsdag 11 november 2003 18:26 > Aan: '[EMAIL PROTECTED]' > Onderwerp: MMbase - PostgreSQL - Images problem > > > Hello everyone, > > I seem to have a problem adding images to my PostgreSQL > database with mmbase. I use PostgreSQL version 7.3.2 and the > driver for jdk1.4 which is also the installed mmbase version > (MMBase 1.6.5-Final.20030829). To store the image I use a > bytea field, not an oid. > > in the log, the following is listed before my mmbase crashes: > > > 2003-11-11 18:08:39,087 [Thread-6] INFO > context.ContextAuthorization -create on node #2131 by user: > admin (administrator) 2003-11-11 18:08:39,596 [Thread-3] > SERVICE mmbase.PAGE -Parsing JSP page: > /ceportalred/mmeditors/jsp/change_node.jsp?node_number=2131 > 2003-11-11 18:08:39,668 [Thread-3] SERVICE > builders.AbstractServletBuilder -images are served on: > /ceportalred/img.db 2003-11-11 18:08:39,673 [Thread-3] INFO > builders.ImageCaches -cached node not found, returning null > 2003-11-11 18:08:39,674 [Thread-3] SERVICE builders.Images > -getting image bytes of [2131, s(100x60)] 2003-11-11 > 18:08:40,232 [ImageConvert] SERVICE > builders.ConvertImageMagick -converted image(#9894 bytes) to > 'jpeg'-image(#1624 bytes)('[convert, -, -geometry, 100x60, > jpeg:-]') 2003-11-11 18:08:40,260 [ImageConvert] ERROR > support.PostgreSQL71 -error, could not insert record for > builder icaches current field:(8)DEF GUIName=Size > GUIType=integer Input=5 Search=5 List=5 DBname=filesize > DBType=INTEGER DBSTATE=PERSISTENT DBNOTNULL=false DBPos=7 > DBSIZE=-1 isKey=false DBDocType=null > 2003-11-11 18:08:40,260 [ImageConvert] ERROR > support.PostgreSQL71 - SQL > : INSERT INTO install_icaches (number, otype, owner, ckey, id, handle, > filesize) VALUES (?, ?, ?, ?, ?, ?, ?) > 2003-11-11 18:08:40,261 [ImageConvert] ERROR > support.PostgreSQL71 - SQLState : null 2003-11-11 > 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 - > ErrorCode: 0 > 2003-11-11 18:08:40,261 [ImageConvert] ERROR > support.PostgreSQL71 - Message : ERROR: ExecAppend: > rejected due to CHECK constraint install_icaches_id_references > > 2003-11-11 18:08:40,264 [ImageConvert] ERROR core.MMObjectBuilder > -Failure(java.lang.RuntimeException: java.sql.SQLException: ERROR: > ExecAppend: rejected due to CHECK constraint > install_icaches_id_references > ) inserting node: > prefix='',otype=2:'29',owner=1:'imagesmodule',filesize=2:'1624 > ',ckey=1:'2131 > s(100x60)',number=9:'2132',handle=4:'[EMAIL PROTECTED]',id=9:'2131' > java.lang.RuntimeException: java.sql.SQLException: ERROR: > ExecAppend: rejected due to CHECK constraint > install_icaches_id_references > > at > org.mmbase.module.database.support.PostgreSQL71.insertRecord(P > ostgreSQL71.ja > va:679) > at > org.mmbase.module.database.support.PostgreSQL71.insert(Postgre > SQL71.java:575 > ) > at > org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder. > java:414) > at > org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:176) > at > org.mmbase.module.builders.ImageRequestProcessor.processReques > t(ImageRequest > Processor.java:112) > at > org.mmbase.module.builders.ImageRequestProcessor.run(ImageRequ > estProcessor.j > ava:78) > at java.lang.Thread.run(Thread.java:536) > > 2003-11-11 18:08:40,265 [ImageConvert] ERROR > builders.ImageRequestProcessor > -java.lang.RuntimeException: java.sql.SQLException: ERROR: > ExecAppend: rejected due to CHECK constraint > install_icaches_id_references > > at > org.mmbase.module.database.support.PostgreSQL71.insertRecord(P > ostgreSQL71.ja > va:679) > at > org.mmbase.module.database.support.PostgreSQL71.insert(Postgre > SQL71.java:575 > ) > at > org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder. > java:414) > at > org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:176) > at > org.mmbase.module.builders.ImageRequestProcessor.processReques > t(ImageRequest > Processor.java:112) > at > org.mmbase.module.builders.ImageRequestProcessor.run(ImageRequ > estProcessor.j > ava:78) > at java.lang.Thread.run(Thread.java:536) > > Can someone please tell me what is wrong or what I should change? > > Thank in advance, > > > Peter van der Meer > Software Developer > > [VARA!] Nieuwe Media > Postbus 175 > 1200 AD Hilversum > http:://www.vara.nl > T +31 (0)35.67.11.383 > > Disclaimer: > De informatie verzonden met en of in dit e-mail bericht is > uitsluitend bestemd voor de geadresseerde(n). Gebruik van > deze informatie door anderen dan geadresseerde(n) is > verboden. Openbaarmaking, vermenigvuldiging, verspreiding, > en/of verstrekking van deze informatie aan derden is NIET > toegestaan. Omroepvereniging VARA staat niet in voor de > juiste en volledige overbrenging van de inhoud van een > verzonden e-mail, noch voor tijdige ontvangst daarvan. > >
