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

Roman



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
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>