On Friday 22 November 2002 15:59, you wrote:

David

> > > Phil, can you try with the jboss connection pool max size set to 1 and
> > > see
> > > what happens? I'd expect there will be either success or a deadlock if
> > > jboss is trying to get more than one connection (i.e. a jboss bug).
> >
> > I changed the max connection pool setting to 1 in
> > firebird-service.xml, and the FK creation still failed.
>
> Since the error says the problem occurs during autocommit, I think the
> table creation was also autocommitted. I'm mystified.

I think it is a JBoss error. I created a 'standalone' java app that creates
the same tables/FK as the JBoss app, with auto commit and it does not fail.
I think JBoss is creating more that one connection somewhere. I am going to
try with the 3.2beta over the weekend and see if I can get to the bottom of
it.

> My experience is that unless I put a line in log4j.xml setting the priority
> for org.firebirdsql to INFO or higher I get more logging than I want.

Thats the problem with logging, you either get too much, or not enought!

Phil

--
Linux 2.4.4-4GB
4:27pm up 2:02, 1 user, load average: 0.20, 0.05, 0.01