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

Michael Gloegl Wed, 21 Jan 2004 02:22:47 -0800

Hi,

Try calling sessionFactory.close() at the end, and ask such questions in the user forum.

Troy McKinnon wrote:

I have tried everything to get hibernate to release the lock. No luck.
Trying to do it forcefully just gives an access denied error.

Any ideas at all how I can get past this..

The way it tands now I have to restart tomcat evertime I open a HSQL
connection.

Obviously a huge issue.

If I can't get past this soon I will have to look to an alternative for HSQL
or just not use Hibernate and do direct JDBC for this and map the objects
manually!

Hoepfully I can resolve this...

Troy

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
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel


-------------------------------------------------------
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
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

-------------------------------------------------------
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
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

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

Reply via email to