8 Replies Latest reply on Jan 20, 2009 5:48 AM by vickyk

    Connection pool leak in JBoss 3.2.5 ???

    danieldestro

      Hi all,

      Something really strage is going on here.

      We are using JBoss 3.2.5 as ou A.S., Oracle 9i (.2.0.3.0) as our D.B. and Oracle JDBC Driver version 10g release 2 (10.2.0.1.0), running on a Linux Debian 3.1 - Sarge (kernel 2.4.26-bf2.4 - no NPTL support).

      We have 3 different applications running with 3 different datasources, one for each. One of them is perfectly running, but the other two apps have some problem sometimes.

      We get this stack trace:

      WARN [JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; -
      nested throwable: (java.sql.SQLException: ORA-01017: invalid username/password; logon denied )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at ...
      caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
      at oracle.jdbc.dbaccess.DBError.throwsSqlException(DBError.java:134)
      ...


      And 2 minutes later:

      WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; -
      nested throwable: (java.sql.SQLException: ORA-01017: invalid username/password; logon denied )
      at ...


      The wierd thing is, this error is intermittent... the apps sometime work fine, sometime throw this exceptions.

      Has anyone faced something like this?

      I think it is either a problem (bug) of JBoss and/or JDBC driver, which is newer than the DB version.

      ps: we are using a newer jdbc driver because version 9i does not allow BLOBs bigger than 2,048 bytes.