Hello

Select statements are under transaction control as any other statement, although usually transactions are only used to group
update/insert/delete statements.

Which version of the driver do you use?. In the last two weeks there are some updates to the driver code that solves problems like
the one you have. If you can, please get an updated version from CVS.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "Carsten Schäfer" <ca_schaefer@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, May 28, 2002 8:36 AM
Subject: Re: [Firebird-Java] ResourceException


I ' ve forget to mention it.
This exception happen with a Prepared select-Statement.
(when i call prepareStatement)
When i do selects i normally does not do anything with commit or autocommit.
So why does this happen ?

gruse
Carsten

----- Original Message -----
From: <Stephen.Thompson@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, May 28, 2002 8:29 AM
Subject: RE: [Firebird-Java] ResourceException


Hello,

It looks like it. It could also be you have setAutocommit set as true.

Regards,

Stephen.

-----Original Message-----
From: Carsten Schäfer [mailto:ca_schaefer@...]
Sent: 28 May 2002 07:29
To: firebird-java@yahoogroups.com
Subject: [Firebird-Java] ResourceException


Hi,
>from time to time i get the following Exception in my log file:
java.sql.SQLException: ResourceException: javax.resource.ResourceException:
local transaction active: can't begin another
at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:878)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:78)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:186)

Does this mean that i have forget to commit a update/insert - statement that
i 've startet before.

gruse
Carsten




To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


-
------------------------------------------------------------------------------------------

Copyright material and/or confidential and/or privileged information may be contained in this e-mail and any attached documents.
The material and information is intended for the use of the intended addressee only. If you are not the intended addressee, or the
person responsible for delivering it to the intended addressee, you may not copy, disclose, distribute, disseminate or deliver it to
anyone else or use it in any unauthorised manner or take or omit to take any action in reliance on it. To do so is prohibited and
may be unlawful. The views expressed in this e-mail may not be official policy but the personal views of the originator. If you
receive this e-mail in error, please advise the sender immediately by using the reply facility in your e-mail software, or contact
postmaster@.... Please also delete this e-mail and all documents attached immediately.
Many thanks for your co-operation.

BMW Financial Services (GB) Limited is registered in England and Wales under company number 01288537.
Registered Offices : Europa House, Bartley Way, Hook, Hants, RG27 9UF
------------------------------------------------------------------------------------------


To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/