hello i am using JBoss jboss-4.0.5 and i commented the default value of hibernate.hbm2ddl.auto = create in persistence.properties and set it in the persistence.xml file as hibernate.hbm2ddl.auto = update.
My tables already exist in the database. I dont want to to create new tables everytime the application is deployed on the JBoss. But now when i deploy my application on JBoss with the value of hibernate.hbm2ddl.auto set to 'update' i get the following exception: | 09:54:18,483 WARN [JDBCExceptionReporter] SQL Error: 1031, SQLState: 42000 | 09:54:18,483 ERROR [JDBCExceptionReporter] ORA-01031: insufficient privileges | | 09:54:18,483 ERROR [SchemaUpdate] could not complete schema update | org.hibernate.exception.SQLGrammarException: could not get table metadata: CUSTOMERS | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) | at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100) | at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:878) | at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140) | at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314) | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1218) | at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:688) | at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence. | java:127) | at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:264) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | | | Please help! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4002604#4002604 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4002604 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
