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

Claus Köll commented on JCR-4579:
---------------------------------

If i change the Code in org.apache.jackrabbit.core.util.db.ConnectionFactory 
the maven build fails with
{code:java}
 maven-bundle-plugin:4.2.1:baseline (default) @ jackrabbit-data ---
[INFO] Baseline Report - Generated by Apache Felix Maven Bundle Plugin on 
2020-06-10T15:42Z based on Bnd - see http://www.aqute.biz/Bnd/Bnd
[INFO] Comparing bundle jackrabbit-data version 2.21.2-SNAPSHOT to version 
2.20.1
[INFO]
[INFO]   PACKAGE_NAME                                       DELTA      CUR_VER  
  BASE_VER   REC_VER    WARNINGS
[INFO] = ================================================== ========== 
========== ========== ========== ==========
[INFO]   org.apache.jackrabbit.core.config                  unchanged  2.13.5   
  2.13.5     2.13.5     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.core.data                    unchanged  2.15.0   
  2.15.0     2.15.0     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.core.data.db                 unchanged  2.13.6   
  2.13.6     2.13.6     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.core.data.util               unchanged  2.13.5   
  2.13.5     2.13.5     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.core.fs                      unchanged  2.13.5   
  2.13.5     2.13.5     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.core.fs.local                unchanged  2.13.5   
  2.13.5     2.13.5     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO] * org.apache.jackrabbit.core.util.db                 minor      2.13.5   
  2.13.5     2.14.0     Version increase required
[INFO]      < class org.apache.jackrabbit.core.util.db.ConnectionFactory
[INFO]          + field SYSTEM_PROPERTY_POOL_PREPARED_STATEMENTS
[INFO]              + access final
[INFO]              + access static
[INFO]              + constant 
org.apache.jackrabbit.core.util.db.driver.datasource.poolPreparedStatements
[INFO]              + return java.lang.String
[INFO] 
-----------------------------------------------------------------------------------------------------------
[INFO]   org.apache.jackrabbit.data.core                    unchanged  2.13.5   
  2.13.5     2.13.5     -
[INFO] 
-----------------------------------------------------------------------------------------------------------
[ERROR] org.apache.jackrabbit.core.util.db: Version increase required; detected 
2.13.5, suggested 2.14.0{code}
[~reschke] do you know what i have to do ? I'm not familiar with osgi versions. 
Thanks !

> In rare situations we see "Closed Statement; nested exception is 
> java.sql.SQLException: Closed Statement"
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: JCR-4579
>                 URL: https://issues.apache.org/jira/browse/JCR-4579
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-data
>            Reporter: Claus Köll
>            Assignee: Claus Köll
>            Priority: Major
>
> We are using a DriverDataSource and in really rare situations we see 
> following exception
> {code:java}
> Closed Statement; nested exception is java.sql.SQLException: Closed Statement 
> {code}
> The DriverDataSource uses the commons-dbcp library to create a 
> BasicDataSource.
> The old commons-dbcp is also using a fairly old version of commons-pool.
> After researching a valid fix can be is to disable the pooling of 
> PreparedStatements.
> As a quick fix i would define a SystemProperty to disable the pooling. We 
> have a really high load and we see no performance impacts.
> As a future fix we can update to a actual dbcp2 version.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to