0001520: MySQL init-params Not Being Applied

1520

minor

always

12-20-06 14:03

01-01-07 11:17

Reporter:

scruz

Platform:

Assigned To:

ferg

OS:

Priority:

normal

OS Version:

Status:

closed

Product Version:

3.0.19

Product Build:

Resolution:

fixed

Projection:

none

ETA:

none

Fixed in Version:

3.0.23

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.

Steps To Reproduce:

Additional Information:

Relationships

Attached Files:

Mantis - Resin
Viewing Issue Advanced Details

ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1520		minor	always	12-20-06 14:03	01-01-07 11:17

Reporter:	scruz	Platform:
Assigned To:	ferg	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.0.19
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none	Fixed in Version:	3.0.23

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.
Steps To Reproduce:
Additional Information:
Relationships
Attached Files: