I am having some strange issues with retrieving a blob field.
I am using an Oracle9i DB with the oci8(not thin) JDBC driver. I am also at
OJB 1.0.1.
There are two parts to this problem.
1) When I go to access my object containing a blob field using
getObjectByIdentity(), it fails the first time, but succeeds on subsequent
calls. If I restart the server - again it fails the first time - and success
afterwards.
2) When I go to search for any of these objects containing this blob field, it
fails every time.
The failure exception is as follows:
org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException:
ORA-00932: inconsistent datatypes: expected - got BLOB
at java.lang.Throwable.<init>(Throwable.java)
at
org.apache.commons.lang.exception.NestableRuntimeException.<init>(NestableRuntimeException.java:111)
at
org.apache.ojb.broker.OJBRuntimeException.<init>(OJBRuntimeException.java:40)
at
org.apache.ojb.broker.PersistenceBrokerException.<init>(PersistenceBrokerException.java:69)
at
org.apache.ojb.broker.PersistenceBrokerSQLException.<init>(PersistenceBrokerSQLException.java:37)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:318)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:183)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1808)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1333)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(PersistenceBrokerImpl.java:1320)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(DelegatingPersistenceBroker.java:322)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuery(DelegatingPersistenceBroker.java:322)
Repository field descriptor:
<field-descriptor
name="exportFile"
column="EXP_FILE"
jdbc-type="BLOB"
/>
Class definition:
protected byte[] exportFile;
I have changed this blob field to a CLOB field and it was successfully storing
and retrieving up to 10 Meg of data...but alas I cannot use CLOB as the data I
am wishing to store is binary information!
If someone could point me in the right direction, I would be immensely grateful!
Thanks much,
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
