jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edgar Vonk (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-1975) Connection timed out IO Exceptions
Date Wed, 11 Feb 2009 16:24:59 GMT
Connection timed out IO Exceptions
----------------------------------

                 Key: JCR-1975
                 URL: https://issues.apache.org/jira/browse/JCR-1975
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: jackrabbit-api, jackrabbit-core, jackrabbit-jcr-commons, jackrabbit-spi,
jackrabbit-spi-commons, jackrabbit-text-extractors
    Affects Versions: core 1.4.5
         Environment: Linux (CentOs), Oracle XE 10g, Tomcat 6, JDK 1.6, Magnolia Enterprise
3.6.3, JNDI
            Reporter: Edgar Vonk


We are running Jackrabbit 1.4.5 as part of the Magnolia Enterprise CMS. We are running into
Jackrabbit - database connection problems on some occasions. We do not understand why and
when these happen. When they do all we can do is restart Tomcat (with Magnolia) and then everything
seems to run fine again until the next time this happens.

We have looked into this issue together with Magnolia but have so far failed to come up with
a solution. We have not even been able to reproduce the issue. It only happens on our production
environment (where we have the database server on a separate machine from our two app servers).

I have also reported this issue on the Magnolia form: http://www.nabble.com/Using-Oracle-with-a-JNDI-datasource-in-Tomcat-td21114284.html

We are using a JNDI persistence manager set-up. Our Jackrabbit persistence manager configuration
looks as follows:

{code}
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
  <param name="driver" value="javax.naming.InitialContext" />
  <param name="url" value="java:comp/env/jdbc/magnolia" />
  <param name="schemaObjectPrefix" value="${wsp.name}_" />
  <param name="externalBLOBs" value="false" />
</PersistenceManager>
{code}

Our datasource in Tomcat:
{code}
	<Resource 
		name="jdbc/magnolia" 
		auth="Container" 
		type="javax.sql.DataSource"
		driverClassName="oracle.jdbc.OracleDriver" 
		url="jdbc:oracle:thin:@//CHANGEME:1521/XEXDB"
		username="CHANGEME" 
		password="CHANGEME" 
		maxActive="20" 
		maxIdle="10" 
		maxWait="-1" />
{code}

In the log files we see:
java.sql.SQLRecoverableException: Io exception: Connection timed out

I will upload the full log file excerpt. 

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


Mime
View raw message