Connection pool

[silvia]

Does anyone work with sqlserver 2000 in JBoss 2.4.3? I've got a very serious problem with the connection pooling with the sqlserver 2000 jdbc driver.
I obtain a connection object, but with that connection object I can only have ONE statement object. If I want to use another statement object, I have to close the first. Otherwise, I obtain the next error:
Can't start a cloned connection while in manual transaction mode.

Thanks in advance.

[kar2000]

Well, I have a doubt in this regard - is there any means of finding in the jboss server side and not in the Oracle database server side,

how many connections are there in the pool,

how many connections are in use and

how many connections are being returned at a given point of time?