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

These statements are issued by Hibernate. They may be unnecessary. The
JDBC logger is showing the exceptions but Hibernate must be catching and
ignoring them.

Fred

On Thu, Feb 7, 2013, at 13:41, stephaneeybert wrote:
> 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
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
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