Re: Using log4jdbc gives a "user lacks privilege or object not found"

Hello,

Here is more on the error message if that gives some hint...

2013-02-07 13:55:53,506 DEBUG  [DriverManagerDataSource] Creating new JDBC
DriverManager Connection to [jdbc:log4jdbc:hsqldb:mem:db_integration]
2013-02-07 13:55:53,513 DEBUG  [sqlonly] 
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:421)
2. alter table admin_module drop constraint FKEB79195CD69CB436
2013-02-07 13:55:53,538 ERROR  [sqlonly] 
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:421)
2. alter table admin_module drop constraint FKEB79195CD69CB436
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found:
PUBLIC.ADMIN_MODULE
  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
  at net.sf.log4jdbc.StatementSpy.executeUpdate(StatementSpy.java:694)
  at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:421)
  at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:396)
  at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:269)
  at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:219)
  at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:372)
  at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
  at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
  at
org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)

Caused by: org.hsqldb.HsqlException: user lacks privilege or object not
found: PUBLIC.ADMIN_MODULE
  at org.hsqldb.error.Error.error(Unknown Source)
  at org.hsqldb.error.Error.error(Unknown Source)
  at org.hsqldb.SchemaManager.getUserTable(Unknown Source)
  at org.hsqldb.ParserDDL.compileAlterTable(Unknown Source)
  at org.hsqldb.ParserDDL.compileAlter(Unknown Source)
  at org.hsqldb.ParserCommand.compilePart(Unknown Source)
  at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
  at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  at org.hsqldb.Session.execute(Unknown Source)

Kind Regards,





--
View this message in context: http://hsqldb.10974.n7.nabble.com/Using-log4jdbc-gives-a-user-lacks-privilege-or-object-not-found-tp1775p3829.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb