[
http://www.jahia.org/jira/browse/JAHIA-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Khaled Tlili reopened JAHIA-2101:
---------------------------------
> Enabling PreparedStatement pooling using DBCP causes errors
> -----------------------------------------------------------
>
> Key: JAHIA-2101
> URL: http://www.jahia.org/jira/browse/JAHIA-2101
> Project: Jahia Content Management Server
> Issue Type: Bug
> Components: Installation and Environment (J2EE, Apache,...)
> Affects Versions: 5.0 SP2
> Environment: Jahia 5.0.2
> MySQL 5,
> MySQL Connector/J 3.1.7, 3.1.14, 5.0.6
> Tomcat 5.5
> Jahia 1.5.0_12
> Commons DBCP 1.2.2
> Reporter: Sergiy Shyrkov
> Assignee: Khaled Tlili
> Fix For: 5.0 SP3
>
> Attachments: error-stack-1.txt, error-stack-2.txt
>
>
> Enabling pooling for prepared statements causes errors (see
> error-stack-1.txt, error-stack-2.txt)
> Pooling was enabled for the "jdbc/jetspeed" datasource using the following
> attributes:
> poolPreparedStatements="true" maxOpenPreparedStatements="50"
> I.e. complete configuration for the datasource:
> <Resource name="jdbc/jetspeed" auth="Container"
> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
> type="javax.sql.DataSource" username="jahia" password="jahia"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/jahia-vodafone?useUnicode=true&characterEncoding=UTF-8"
> defaultAutoCommit="true"
> maxActive="100" maxIdle="30" maxWait="10000"
> poolPreparedStatements="true" maxOpenPreparedStatements="50"/>
> The equivalent C3P0 configuration does not has this issue (see CONE-36,
> JAHIA-2100):
> <Resource name="jdbc/jetspeed" auth="Container"
> factory="org.apache.naming.factory.BeanFactory"
> type="com.mchange.v2.c3p0.ComboPooledDataSource"
> driverClass="com.mysql.jdbc.Driver"
> jdbcUrl="jdbc:mysql://localhost/jahia-vodafone?useUnicode=true&characterEncoding=UTF-8"
>
> user="jahia" password="jahia"
> minPoolSize="2" maxPoolSize="100" initialPoolSize="2"
> acquireIncrement="3"
> maxStatements="100" maxStatementsPerConnection="20" />
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://www.jahia.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
jira_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/jira_list
