0001520: MySQL init-params Not Being Applied

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001520

[Resin]

minor

always

12-20-06 14:03

01-01-07 11:17

Reporter

scruz

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.0.19

Summary

0001520: MySQL init-params Not Being Applied

Description

We noticed this problem with MySQL a couple of months ago, but I didn?t realize that the problem was Resin until now. Resin, having not applied the different driver settings, masked the problem of the MySQL server side prepared statements being broken.

Here is our database configuration from resin.conf:

  <database>
    <jndi-name>jdbc/MyDB</jndi-name>
    <driver>
      <type>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</type>
      <init-param autoReconnect="true" />
      <init-param autoReconnectForPools="true" />
      <init-param cacheResultSetMetadata="true" />
      <init-param dumpQueriesOnException="true" />
      <init-param elideSetAutoCommits="true" />
      <init-param explainSlowQueries="true" />
      <init-param failOverReadOnly="true" />
      <init-param isInteractiveClient="true" />
      <init-param jdbcCompliantTruncation="true" />
      <init-param logSlowQueries="true" />
      <init-param profileSQL="false" />
      <init-param slowQueryThresholdMillis="2500" />
      <init-param useFastIntParsing="true" />
      <init-param useServerPreparedStmts="true" />
      <init-param useTimezone="false" />
      <password>myPassword</password>
      <url>jdbc:mysql://myserver/mydb</url> [^]
      <user>myuser</user>
    </driver>
    <max-active-time>600s</max-active-time>
    <max-connections>35</max-connections>
    <max-idle-time>30s</max-idle-time>
    <max-pool-time>2400s</max-pool-time>
    <ping>true</ping>
    <ping-interval>60s</ping-interval>
    <ping-table>state</ping-table>
    <prepared-statement-cache-size>8</prepared-statement-cache-size>
    <xa>true</xa>
  </database>

All of the init-params are being overridden with the default values every time. More information on the issues can be found here:

http://www.nabble.com/MySQL-%3E5.0.18-and-Connector-J-5.0.4-weirdness-tf2827165.html [^]

I tried to attach a patch, but it won't let me.

Additional Information

Attached Files

Relationships

Notes
(0001664) scruz 12-20-06 15:07	OK, my wording was not correct in the issue description. The problem is that the init-params are never applied for ConnectionPoolDataSource and MysqlXADataSource (in Resin's DriverConfig class). The fact that the URL params are overriden by the defaults is actually a bug in the MySQL driver.

(0001666) ferg 12-20-06 15:40	server/450{0,1,2,3}

Issue History
Date Modified	Username	Field	Change
12-20-06 14:03	scruz	New Issue
12-20-06 15:07	scruz	Note Added: 0001664
12-20-06 15:07	scruz	Issue Monitored: scruz
12-20-06 15:40	ferg	Note Added: 0001666
01-01-07 11:17	ferg	Assigned To	=> ferg
01-01-07 11:17	ferg	Status	new => closed
01-01-07 11:17	ferg	Resolution	open => fixed
01-01-07 11:17	ferg	Fixed in Version	=> 3.0.23
01-01-07 11:17	ferg	Description Updated

Mantis 1.0.0rc3[^]

33 total queries executed.
27 unique queries executed.