Re: [Springframework-developer] Hibernate Spring and HSQLDB - locking issue

[<tri...@tr...>]

Troy,

I don't think you should issue a "SHUTDOWN" while using Hibernate or Spring. 
Let the framework handle the lifecycle of the database connections.  I think
it's a matter of picking the correct datasource configuration to use.  

Are you currently using connection pooling?  That would keep the connection open
and leave the lock file ou there.  Since you are not using a "Server" instance
of HSQL, you are limited to that single connection that will stay open until the
connection pool or Tomcat is shut down.

If you absolutely have to run HSQL in "Standalone" mode then you can't use
connection pooling.  For a Spring configured datasource you should use
"DriverManagerDataSource".

Thomas

Quoting Troy McKinnon <Tro...@ho...>:

> I can't get Hibernate to disconnect from the database once it is connected.
> It creates a HSQLDB.lck file and I have to terminate the Tomcat before I can
> access it again.
> 
> I have tried: (With no luck..)
> 
> 
>   try {
>             Configuration cfg = new
> Configuration().configure("/hibernate-HSQLDB.cfg.xml");
>             SessionFactory sessions = cfg.buildSessionFactory();
>             Long user = new Long(0);
>             AuditInterceptor aii = new AuditInterceptor(user);
>             session = sessions.openSession(aii);
>             sw.start();
>             list = session.find("from " + table + " in class " +
> StringUtils.capitalise(table));
>             // Edited by tmckinnon: 20-Jan-2004 03:56:27 PM PST
>             // trying to get HSQLDB lck to release...
>             if(session != null && session.isOpen()) {
>                 Connection con = session.connection();
>                 Statement st = con.createStatement();
>                 st.execute("SHUTDOWN COMPACT");
>                 con.commit();
>                 st.close();
>                 con.close();
>                 logger.trace("Shut down HSQLDB session!");
>                 session.disconnect();
>                 if(session != null) session.close();
>             }
>              hibernate.push(list.toArray(new Object[list.size()]), clazz);
>         } catch(Exception e) {
>             throw e;
>         } finally {
>             try {
>                 if(session != null && session.isOpen()) {
>                     logger.trace("Closing CSV session!");
>                     session.disconnect();
>                     if(session!=null) session.close();
>                 }
>             } catch(Exception e) {
>                 logger.trace("Error trying to close session");
>                 throw e;
>             }
>         }
> 
> 
> 
> 
> 
> but just get:
> 
> 16:20:06,032  WARN [http8100-Processor4]
> net.sf.hibernate.util.JDBCExceptionReporter:38 - SQL Error: -33, SQLState:
> null
> 16:20:06,032 ERROR [http8100-Processor4]
> net.sf.hibernate.util.JDBCExceptionReporter:46 - Access is denied in
> statement [SHUTDOWN COMPACT]
> 16:20:06,042 ERROR [http8100-Processor4]
> net.sf.hibernate.util.JDBCExceptionReporter:38 - Cannot close connection
> java.sql.SQLException: Access is denied in statement [SHUTDOWN COMPACT]
>  at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
>  at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
>  at org.hsqldb.jdbcConnection.execute(Unknown Source)
>  at org.hsqldb.jdbcConnection.rollback(Unknown Source)
>  at
> com.mchange.v2.c3p0.impl.C3P0PooledConnection.reset(C3P0PooledConnection.jav
> a:251)
>  at
> com.mchange.v2.c3p0.impl.C3P0PooledConnection.access$000(C3P0PooledConnectio
> n.java:35)
>  at
> com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandl
> er.doSilentClose(C3P0PooledConnection.java:531)
>  at
> com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandl
> er.invoke(C3P0PooledConnection.java:636)
>  at com.mchange.v2.c3p0.impl.$Proxy0.close(Unknown Source)
>  at
> net.sf.hibernate.connection.C3P0ConnectionProvider.closeConnection(C3P0Conne
> ctionProvider.java:40)
>  at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:275)
>  at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3299)
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>