Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID 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[^]
Copyright © 2000 - 2005 Mantis Group
33 total queries executed.
27 unique queries executed.
Powered by Mantis Bugtracker