How store a big file in postgresql without breaking the EJB

[rpa_rio]

Hi,

I need to store a big file in my postgresql table using my entity bean deployed in JBOSS, what's the best way? When i try to use oid the driver says "expression of type bytea", and when i use bytea as collumn type the driver says "expression of type oid".
What can i do?

Thanks for any answer,

Rogério

[rpa_rio]

I found the solution, i created a SessionBean and put all PostgreSQL specific code there to store the file.

[tbech]

SQL in SessionBean is spagethi code (or at least anti-pattern). Use Entity Bean for it.
Mapping for PostgreSQL is:

<java-type>java.lang.Object</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>BYTEA</sql-type>


Did you try such field in entity?
(I use String and TEXT for very long texts and works perfectly)