Subject Re: DatabaseMetaData.getTables() : Unrecognized transaction ???
Author totallkm
> > I hope it helps.
> > My guess is that it is trying to autocommit the transaction on
> > doQuery(), but I have tried with and without setting the auto-comit
> > to true and false with no effect.
>
> I'm still not able to reproduce a bug. The code that does meta-data
> queries is somewhat suspicious, but it works in all cases for me.
> Here's a simple Java application that works without any problems on my
> laptop (it is based on your code). Can you please modify it so that
> problem is reproduced?
Got it, when I tried to reproduce it, I couldn't...
So I left it alone for a while and it suddenly re-occured!
I figured it is something to do with my network settings and the dhcp
lease on my eth0. After a network change, the connection is not
possible until I restart xinetd (I run firebird from xinetd) but even
then, the code fails as described.
I am not sure why, as all other databases and services are quite happy
with the network changes, and I am using localhost (on lo - 127.0.0.1)
anyway... And why would it only fail on that method ?! All the other
calls (updates, inserts etc) are all fine!
The same code you provided fails the same way.
Mostly solved.

Thanks
Antoine