Re: [JBoss-user] How to use Oracle BLOB/CLOBs with JBoss

2003-01-06 Thread Stephen Coy
Sorry, I can see that this paragraph is ambiguous at best. Try this: For large binary columns: i) raw byte arrays are applied directly to the database using PreparedStatement.setBinaryStream; ii) Other java types are first serialised into a byte array using a java.rmi.MarshalledObject (remember

RE: [JBoss-user] How to use Oracle BLOB/CLOBs with JBoss

2003-01-06 Thread Sacha Labourey
Thank you for the synthesis Stephen. > For binary data, JBoss stores byte array data directly to the database. > All other java types are serialised using a java.rmi.MarshalledObject, > therefore your object must be serialisable. Even for CLOB and java.lang.String?!? Cheers,

[JBoss-user] How to use Oracle BLOB/CLOBs with JBoss

2003-01-06 Thread Stephen Coy
This question seems to keep cropping up from time to time. Maybe Dain can add the following information as an addendum or something to the CMP doco. This information applies to JBoss 3.0.4 and newer. Before attempting to store LOBs in Oracle, I've found it's useful to know a few things: 1. Ora