Hello,

I'm new to this forum and need help with Oracle Blobs ans hibernate 3.1.2 .
I ran my application with great success over one year using hibernate 3.0.2, yesterday I uppdated to 3.1.2 and got problems with Oracle Blobs.

INFO [main] (SettingsFactory.java:77) - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
INFO [main] (SettingsFactory.java:78) - JDBC driver: Oracle JDBC driver, version: 9.2.0.5.0
INFO [main] (Dialect.java:103) - Using dialect: org.hibernate.dialect.OracleDialect

The code snippet to create a blob is :

oracle.sql.BLOB blob=oracle.sql.BLOB.createTemporary(dbcon.getSession().connection(),false,oracle.sql.BLOB.DURATION_CALL);

dbcon.getSession() returns a hibernate Session object.

When I run the application and try to store data in the blob I get the following error:

java.lang.ClassCastException: $Proxy0
at oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnection.java:5174)
at oracle.sql.BLOB.createTemporary(BLOB.java:776)


Is there someone who can help me.

THX
Ralf