2 Replies Latest reply on Jul 17, 2003 5:33 AM by kar2000

    JBoss Connection Pooling

    abcdef Newbie

      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?

        • 1. Re: JBoss Connection Pooling
          Jon Barnett Master

          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.

          • 2. Re: JBoss Connection Pooling
            kar2000 Newbie

            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?