Could not complete schema update

I recently mapped a JPA entity to a view, and encountered this error while using hibernate to update the database schema:

ORA-01702: a view is not appropriate here

[SchemaUpdate.execute] could not complete schema update

I was using the Oracle JDBC drivers 10.1.3.3 – luckily, the solution was to upgrade the drivers – when using 11.2.0.2.0 it works fine.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

ojdbc6.jar (2,152,051 bytes) – Classes for use with JDK 1.6. It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

Tagged as: hibernate, jpa, view