db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject Re: Read only mode error using HSQLDB
Date Thu, 10 Nov 2005 10:01:59 GMT




Hi,

With the current information, I am at a loss to analyze the problem. The
problem is that the Torque Exception does not print the stack trace to the
wrapped SQL Exception.
Can you debug into the code and get a stack trace for the SQL Exception
which is retrown as a Torque exception ? This will provide more insight
where the error occurs.
By the way, which Torque version are you using ?

   Thomas



econroy <econroy@ECONROY.NET> schrieb am 08.11.2005 19:42:02:

> 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
>


---------------------------------------------------------------------
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