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