JBoss Connection Pooling

[abcdef]

I'm getting an error like this:

19:22:02,381 INFO [STDOUT] Via is null.
19:22:02,381 INFO [STDOUT] Page Source is :WrkgrpSelect
19:22:02,381 INFO [STDOUT] Action is :Search
19:22:02,382 INFO [STDOUT] PageSource is WrkgrpSelect.
19:22:02,462 INFO [STDOUT] Supplied Pool name is :jdbc/InfoCRM
19:23:26,543 INFO [STDOUT] Connection established successfully.
19:24:28,888 INFO [STDOUT] Error in executing the stored function. Error : ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []
19:24:28,890 INFO [STDOUT] Connection Closed.
19:24:28,893 INFO [STDOUT] Database connection is closed.


I'm using JBoss 3.2.0. My app uses connection pooling. I'm able to connect to the datasource. But an error like this is displayed in the log. What could be the reason?

[jonlee]

The report is coming back from Oracle. It is having trouble executing your stored procedure. Have you tested your stored procedure? Have you tested it over a normal JDBC connection?

One thing to note. The connection pool returns a WrappedConnection which may affect things if your call returns you some Oracle specific format data. However, this is the last thing to check - hopefully you are not retrieving Oracle specific data types.

[kar2000]

Well, I have a doubt in this regard - is there any means of finding in the jboss 3.0.7 server side and not in the Oracle 8 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?