Bug #50544 velidationquery, wrong example in manual

• Submitted: 22 Jan 2010 13:18
• Modified: 2 Feb 2010 17:05
• Reporter: Tonci Grgin
• Status: Closed
• Category: Connector / J Documentation
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Tony Bedford
• CPU Architecture: Any

[22 Jan 2010 13:18] Tonci Grgin

Description:
On page http://dev.mysql.com/doc/refman/5.1/en/connector-j-usagenotes-j2ee.html we have following code snippet:
   <parameter>
      <name>validationQuery</name>
      <value>SELECT 1</value>
    </parameter>

Although this works we have introduced one significant change to this in c/J 5.1.3. Ping changes described in http://lists.mysql.com/announce/482:
  Specifying a "validation query" in your connection pool that starts with
  "/* ping */"
  _exactly_ will cause the driver to instead send a ping to the server and return a fake result set (much lighter weight), and when using aReplicationConnectio n or a LoadBalancedConnection, will send the ping across all active connections.

How to repeat:
See manual.

Suggested fix:
Add description of new validation query.

[25 Jan 2010 6:51] Tonci Grgin

See Bug#50432 for example.

[2 Feb 2010 17:05] Tony Bedford

Thanks for the feedback. The documentation XML sources have been updated accordingly.