I am running Hibernate under JBoss 4.0.4 GA platform, on a Oracle 9.2.0.1 database.

When my persistence.xml auto value is set to 'update' and no tables exist in my schema an Oracle error is generated when I start up the JBoss server or redeploy: ORA-01031 insufficient privileges

If I change the setting to 'create', all my tables generate fine with no error. If I subsequently change the setting back to 'update' with tables already in the database, the error does *not* occur, and I am able to update and add new tables without any errors.

The same 'update' setting running against SQLServer, incidentally, works fine even when the database has no tables.

Has anyone else run into this issue or have any recommendations?

Below is my persistence.xml. Please note the dialect is set for Oracle9.


<?xml version="1.0" encoding="UTF-8"?>
<persistence>
<persistence-unit name="ods">
<jta-data-source>java:/OracleDS</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect "/>
</properties>
</persistence-unit>
</persistence>