db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From econroy <econ...@ECONROY.NET>
Subject Re: Read only mode error using HSQLDB
Date Tue, 08 Nov 2005 18:42:02 GMT
Thomas Fischer wrote:

>
>
>Hi,
>
>do you have a stack trace of the exception ? This would point out where in
>LargeSelect the error occurs.
>
>      Thomas
>
>econroy <econroy@ECONROY.NET> schrieb am 07.11.2005 22:12:54:
>
>  
>
>>Hi all,
>>I am using HSQLDB for a database that is being stored on a cdrom.
>>I am using Torque 3.1.1 hsqldb 8.0. When I run the webapp where inside
>>the database properties list readonly=true
>>I get the error : ERROR org.apache.torque.util.LargeSelect -
>>org.apache.torque.TorqueException: java.sql.SQLException: The database
>>is in read only mode.
>>If I run the database in readonly=false the webapp runs fine. I can
>>connect to the database in readonly mode from DatabaseManager contained
>>in HSQLDB. I have a feeling that connecting to the database in Torque
>>still tries to lock the database and can't because it is readonly..
>>.
>>
>>Thanks,
>> Ed Conroy
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>  
>
This error is not in Large select it happens whenever Torque gets a 
connection. This is the stack trace where I use a doSelect():
The call to 
org.apache.torque.util.Transaction.beginOptional(Transaction.java:80) is 
where I am looking because HSQLDB dosen't
support transactions.

org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:717)
org.apache.torque.Torque.getConnection(Torque.java:268)
org.apache.torque.util.Transaction.beginOptional(Transaction.java:80)
org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1195)
org.abt.nsc.om.BaseBillsPeer.doSelectVillageRecords(BaseBillsPeer.java:382)
org.abt.nsc.om.BaseBillsPeer.doSelectVillageRecords(BaseBillsPeer.java:354)
org.abt.nsc.om.BaseBillsPeer.doSelect(BaseBillsPeer.java:323)
org.abt.nsc.modules.actions.SearchAction.doQuery(SearchAction.java:190)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityActionEvent.java:135)
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:78)
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:72)
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:99)
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:113)
org.apache.turbine.modules.Page.build(Page.java:53)
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:101)
org.apache.turbine.Turbine.doGet(Turbine.java:789)
org.apache.turbine.Turbine.doPost(Turbine.java:884)
javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)
org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
org.mortbay.http.HttpServer.service(HttpServer.java:954)
org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message