Using version 3.x trying to get hibernate (JPA impl) auto ddl to work.
On startup error is ORA-00933: SQL command not properly ended
Code:
2007-07-23 13:42:07,133 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] - Running hbm2ddl schema export
2007-07-23 13:42:07,133 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] - import file not found: /import.sql
2007-07-23 13:42:07,133 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] - exporting generated schema to database
2007-07-23 13:42:07,133 DEBUG [com.mchange.v2.resourcepool.BasicResourcePool] - trace com.mchange.v2.resourcepool.BasicResourcePool@10bfe2c [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@6bcf5d)
2007-07-23 13:42:07,164 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] - drop table ACCOUNTS if exists
2007-07-23 13:42:07,211 DEBUG [com.mchange.v2.c3p0.impl.NewPooledConnection] - com.mchange.v2.c3p0.impl.NewPooledConnection@17a9f24 handling a throwable.
java.sql.SQLException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1278)
Could anyone let me know where I might start looking to resolve this?
Thanks