On Wed, 03 Apr 2013 22:51:49 +0200, Roman Rokytskyy <roman@...>
wrote:

> It might be the case, when you have master-detail queries in autocommit
> mode...

This error is thrown by Connection.getAutoCommit() when the reference to
the FBManagedConnection has been set to null; it is very unlikely that this
would have to do with master/detail queries in auto-commit.

Mark

>
> Am 3. April 2013 21:25:18 schrieb "hugo.larson" <hugo.larson@...>:
>>
>>
>> --- In Firebird-Java@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>> >
>> > On 2-4-2013 23:29, hugo.larson wrote:
>> > > Hello,
>> > >
>> > > I'm using FB 1.5, jaybird 2.2.2 with JBuilder Dataexpress

components.

>> > >
>> > > Anybody has a clue about this sporadic exception:
>> > >
>> > > org.firebirdsql.jdbc.FBSQLException: You cannot getAutomcommit on
>> an unassociated closed connection.
>> > > at org.firebirdsql.jdbc.AbstractConnection.getAutoCommit(Unknown
>> > > Source)
>> > > at
>> org.firebirdsql.jdbc.AbstractStatement.getSynchronizationObject(Unknown
>> Source)
>> > > at
>> org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(Unknown
>> Source)
>> > > at com.borland.dx.sql.dataset.o.f(Unknown Source)
>> > > at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
>> > > at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown
>> > > Source)
>> > > at
>> > >

com.borland.dx.dataset.StorageDataSet.refresh(StorageDataSet.class:0)

>> > > at
>> > >

com.borland.dx.sql.dataset.QueryDataSet.refresh(QueryDataSet.class:0)

>> >
>> > You will get this error if the Connection has already been closed. I
>> > have looked at the code but I don't see any obvious way for this to
>> > occur except an explicit call to close() on the connection.
>> >
>> > Mark
>> > --
>> > Mark Rotteveel
>> >
>> Hi Mark,
>>
>> Well there are two problems:
>> 1. I don't close any connection
>> 2. DataExpress components automatically opens connections, even if
>> explicitly closed.
>>
>> BR,
>> Hugo