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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
