[jira] [Commented] (JCR-1975) Connection timed out IO Exceptions

["Palenkara, Jogesh (Contractor) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/JCR-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13021077#comment-13021077 ] 

Palenkara, Jogesh (Contractor) commented on JCR-1975:
-----------------------------------------------------

Hi jira.

Did you find any solution for your connection timeout issue. I am facing
the same issue in production.please help. My email id is
nirajcognizant@gmail.com

 

 



> 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-core
>    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
>         Attachments: jackrabbit_ioexceptionlog.txt
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira