[Opensource] Fwd: Re: expresso setup question

[larry hamel]

the rc6 complete download shows this HSQL error when starting.  can it be fixed?  it does not cause a failure per se, but users may perceive that it does.

larry

>Larry Hamel wrote:
>>
>>
>>
>>ok, I duplicated, but I also noticed that it seems to go away, and not cause a problem even the first time.
>>
>>can you use the system?  does the error show up after you stop and run it a second time?
>>
>>larry
>>
>>At 10:56 AM 12/9/2003, you wrote:
>>  
>>>
>>>
>>>
>>>Larry,
>>>I'm having some trouble setting up Expresso on a Win2K machine. I unzipped the complete build, and was able to run ./startup.bat and login. I clicked on Setup in the left menu, then clicked on Create/Verify Database Structure, and got some errors (below).
>>>
>>>Something similar happened when I installed the example Location app and tried to restart. I tried rebooting my machine, but had the same problem.
>>>
>>>I also tried running in Resin, but got similar errors when I added a web-app entry for expresso in resin.conf.
>>>
>>>Not sure how to proceed - any ideas?
>>>
>>>Mark
>>>
>>>2003-12-09 10:47:59,531 ERROR [Thread-6] jdbc.JDBCDataObject (JDBCDataObject.jav
>>>a:855) - Error building and executing search statement
>>>com.jcorporate.expresso.core.db.DBException: com.jcorporate.expresso.core.db.DBC
>>>onnection.connect(String, String):Cant get connection to database via driver 'or
>>>g.hsqldb.jdbcDriver' and URL 'jdbc:hsqldb:D:/expresso/webapps/ROOT/WEB-INF/db/de
>>>fault/default' (no description):The database is already in use by another proces
>>>s
>>>      at com.jcorporate.expresso.core.db.DBConnection.connect(DBConnection.jav
>>>a:608)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.buildNewConnection(D
>>>BConnectionPool.java:396)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.createNewConnection(
>>>DBConnectionPool.java:445)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1043)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1156)
>>>      at com.jcorporate.expresso.core.dataobjects.jdbc.JDBCDataObject.createAn
>>>dExecuteSearch(JDBCDataObject.java:724)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5702)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:708)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5760)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:728)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.checkControlQueue(Job
>>>Handler.java:811)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.run(JobHandler.java:5
>>>21)
>>>2003-12-09 10:47:59,546 ERROR [Thread-6] dbobj.DBObject (DBObject.java:5732) - E
>>>rror performing searchAndRetrieveList
>>>com.jcorporate.expresso.core.db.DBException: com.jcorporate.expresso.core.db.DBC
>>>onnection.connect(String, String):Cant get connection to database via driver 'or
>>>g.hsqldb.jdbcDriver' and URL 'jdbc:hsqldb:D:/expresso/webapps/ROOT/WEB-INF/db/de
>>>fault/default' (no description):The database is already in use by another proces
>>>s
>>>      at com.jcorporate.expresso.core.db.DBConnection.connect(DBConnection.jav
>>>a:608)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.buildNewConnection(D
>>>BConnectionPool.java:396)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.createNewConnection(
>>>DBConnectionPool.java:445)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1043)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1156)
>>>      at com.jcorporate.expresso.core.dataobjects.jdbc.JDBCDataObject.createAn
>>>dExecuteSearch(JDBCDataObject.java:724)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5702)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:708)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5760)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:728)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.checkControlQueue(Job
>>>Handler.java:811)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.run(JobHandler.java:5
>>>21)
>>>2003-12-09 10:47:59,562 ERROR [Thread-6] utility.JobHandler (JobHandler.java:542
>>>) - JobHandler unable to start correctly
>>>com.jcorporate.expresso.core.db.DBException: com.jcorporate.expresso.core.db.DBC
>>>onnection.connect(String, String):Cant get connection to database via driver 'or
>>>g.hsqldb.jdbcDriver' and URL 'jdbc:hsqldb:D:/expresso/webapps/ROOT/WEB-INF/db/de
>>>fault/default' (no description):The database is already in use by another proces
>>>s
>>>      at com.jcorporate.expresso.core.db.DBConnection.connect(DBConnection.jav
>>>a:608)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.buildNewConnection(D
>>>BConnectionPool.java:396)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.createNewConnection(
>>>DBConnectionPool.java:445)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1043)
>>>      at com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConn
>>>ectionPool.java:1156)
>>>      at com.jcorporate.expresso.core.dataobjects.jdbc.JDBCDataObject.createAn
>>>dExecuteSearch(JDBCDataObject.java:724)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5702)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:708)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5760)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:728)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.checkControlQueue(Job
>>>Handler.java:811)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.run(JobHandler.java:5
>>>21)
>>>com.jcorporate.expresso.core.db.DBException: Nested exception message:com.jcorpo
>>>rate.expresso.core.db.DBConnection.connect(String, String):Cant get connection t
>>>o database via driver 'org.hsqldb.jdbcDriver' and URL 'jdbc:hsqldb:D:/expresso/w
>>>ebapps/ROOT/WEB-INF/db/default/default' (no description):The database is already
>>>in use by another process
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5733)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:708)
>>>      at com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
>>>bject.java:5760)
>>>      at com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
>>>ist(SecuredDBObject.java:728)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.checkControlQueue(Job
>>>Handler.java:811)
>>>      at com.jcorporate.expresso.core.utility.JobHandler.run(JobHandler.java:5
>>>21)