Greetings all,

I am using Hibernate with Oracle 10 to read/write images to/from the database. I need to turn on the hibernate.jdbc.use_streams_for_binary option given the Oracle limitations. I noticed the documentation notes: "This is a JVM-level setting only." I am not sure what is meant by that.

Given that my mapping file below fails (note I also tried property name="hibernate.jdbc..."), I am assuming that it must be set elsewhere.

Based on testing I know that I can set it in Hibernate.properties, but the documentation seems to prefer the use of the XML document.

What are my options?

Thanks in advance.

Hibernate version:
2.1.6

Mapping documents:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>

<session-factory>

<property name="connection.datasource">java:comp/env/jdbc/UWGOracle</property>
<property name="show_sql">false</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="jdbc.use_streams_for_binary">true</property>

<!-- Mapping files -->
<mapping resource="Images.hbm.xml"/>

</session-factory>


</hibernate-configuration>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 10

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: