This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "BLOB, iBatis & PostgreSql 8.1" Watch "BLOB, iBatis & PostgreSql 8.1" New topic
Author

BLOB, iBatis & PostgreSql 8.1

tomasz brymora
Greenhorn

Joined: May 31, 2004
Posts: 22
Greetings!

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.
 
 
subject: BLOB, iBatis & PostgreSql 8.1
 
Similar Threads
How to access resultmaps from another existing result map in iBATIS 2x
Insert image into MySQL database
spring / ibatis issue
JDBC problem please help
Insert an image file into oracle and open image file from database?(using sql)