The moose likes JDBC and the fly likes BLOB, iBatis & PostgreSql 8.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "BLOB, iBatis & PostgreSql 8.1" Watch "BLOB, iBatis & PostgreSql 8.1" New topic

BLOB, iBatis & PostgreSql 8.1

tomasz brymora

Joined: May 31, 2004
Posts: 22

I got lost trying to save and read an image file from a db.

I get file upload taken care of where a servlet populates a bean with the image file and other info,
but I can't get to be written to the db.

What's the best way to procede, starting with the bean?

Would this be appropriate:

Given the following table:

... waht's the correct way to make the insert?
I'm using iBatis for handling the jdbc part of the app.

... partial iBatis sqlMap:

... from what I gathered, pg uses a path to the image file for importing it, so should I store to a temp dir on
the server and feed pg the path to it?
Would the bean then require a String for the imageBody variable instead of the MultipartFile?

Am I using the datatype for this operation (oid)?

Before this I was able to store the image file in the db as 'bytea' but ran into problems trying to retrieve it:

INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
org.springframework.dao.DataIntegrityViolationExce ption: SqlMapClient operation; SQL [];
--- The error occurred in com/persistance/sqlmaps_xml/imagesSqlMap.xml.
--- The error occurred while applying a result map.
--- Check the getImageResult.
--- Check the result mapping for the 'imageBody' property.
--- Cause: org.postgresql.util.PSQLException: Bad value for type int : \377 ... rest omitted...

... so I'll appreciate any feedback you might have.
jQuery in Action, 2nd edition
subject: BLOB, iBatis & PostgreSql 8.1
Similar Threads
Insert an image file into oracle and open image file from database?(using sql)
Insert image into MySQL database
How to access resultmaps from another existing result map in iBATIS 2x
spring / ibatis issue
JDBC problem please help