Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Message-ID: <349378840.526521267111768045.JavaMail.jira@brutus.apache.org>
Date: Thu, 25 Feb 2010 15:29:28 +0000 (UTC)
From: =?utf-8?Q?C=C3=A9dric_Chantepie_=28JIRA=29?= <jira@apache.org>
To: dev@jackrabbit.apache.org
Subject: [jira] Commented: (JCR-2520) [JBoss] No ManagedConnections
 available / JCA max connection (session)
In-Reply-To: <1055044199.526331267111408094.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/JCR-2520?page=3Dcom.atlassian.j=
ira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D128383=
78#action_12838378 ]=20

C=C3=A9dric Chantepie commented on JCR-2520:
---------------------------------------

Connection conn =3D null;
PreparedStatement stmt =3D null;

try {
  InitialContext ctx =3D new InitialContext();
  DataSource ds =3D (DataSource) ctx.lookup("java:/MyJcrPmDS"); // datasour=
ce used as PersistenceManager in repository.xml

  conn =3D ds.getConnection(); successful

  stmt =3D conn.prepareStatement("SELECT * FROM default_bundle");

  stmt.executeQuery(); // successful
} catch (Exception e) {
  e.printStackTrace(); // None exception occurs
} finally {
  if (stmt !=3D null) {
    try {
      stmt.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }

  if (conn !=3D null) {
    try {
      conn.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

> [JBoss] No ManagedConnections available / JCA max connection (session)
> ----------------------------------------------------------------------
>
>                 Key: JCR-2520
>                 URL: https://issues.apache.org/jira/browse/JCR-2520
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-jca
>    Affects Versions: 2.0.0
>         Environment: JBoss 4.2.3.GA, PostgreSQL 8.x
>            Reporter: C=C3=A9dric Chantepie
>
> It seems that with Jackrabbit JCA 2.0.0 deployed on JBoss 4.2.3.GA, "only=
" 20 session can be opened at the same time.
> When trying to open the 21th session, I get the following exception :
> 15:49:16,047 ERROR [STDERR] Caused by: javax.resource.ResourceException: =
No ManagedConnections available within configured blocking timeout ( 30000 =
[ms] )
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.I=
nternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.ja=
va:303)
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.J=
BossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool=
.java:575)
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.B=
aseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.T=
xConnectionManager.getManagedConnection(TxConnectionManager.java:330)
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.B=
aseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
> 15:49:16,047 ERROR [STDERR]     at org.jboss.resource.connectionmanager.B=
aseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnect=
ionManager2.java:849)
> 15:49:16,047 ERROR [STDERR]     at org.apache.jackrabbit.jca.JCARepositor=
yHandle.login(JCARepositoryHandle.java:72)
> 15:49:16,047 ERROR [STDERR]     ... 28 more
> I don't see this limit / max count in Jackrabbit JCA configuration. I've =
checked whether it comes from underlying PersistenceManager.
> Persistence manager is postgresql bundle one from JNDI (with javax.naming=
.InitialContext as driver).
> But JBoss JMX console displayed it still have available connection to use=
d database whereas Jackrabbit JCA keep throwing exception.
> Moreover I'm still able to use underlying datasource to get a JDBC connec=
tion and execute a PreparedStatement ("SELECT * FROM default_bundle" as tes=
t).
> So as I think underlying datasource/persistence manager is ok, there may =
be a trouble with Jackrabbit JCA.

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.