[jboss-user] [JBoss Seam] - Re: Deploying in 4.0.3SP1 AS results in empty tables, how to

[rabbiaqaswar]

hello

i am using JBoss jboss-4.0.5 and as suggested i commented the default value of hibernate.hbm2ddl.auto = create and set it in the persistence.xml file as hibernate.hbm2ddl.auto = update.

My tables already exist in the database. 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=4002593#4002593

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4002593