[OPENJPA-933] Database version detection in MySQLDictionary is not reliable

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2.0, 1.3.0, 2.0.0-M2
• Fix Version/s: 1.3.0, 2.0.0-M2
• Component/s: jdbc, sql
• Environment: MySQL 5.1.30, Linux
• Assignee: Milosz Tylenda
• Reporter: Milosz Tylenda
• Created: 21/Feb/09 08:24
• Updated: 09/Mar/10 18:31
• Resolved: 18/Apr/09 12:59

Description

The database version detection code assumes the version string always looks like "4.1.3-nt" whereas currently a MySQL on Linux reports itself as "5.1.30". This causes an exception catch and a fallback to default values (in particular supportsXMLColumn stays false). Also, the code could take advantage of JDBC 3 methods that return version numbers.

I will provide a patch.