Description:
we are updating the mysql connector java 6.x+ from the Mysql connector mysql-connector-java-5.1.25-bin.
it was workig fine with Mysql connector mysql-connector-java-5.1.25-bin but has issue with mysql connector java 6.x+.
Lib:mysql-connector-java-6.0.2
server: boss-7.1.1
java detail:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\jboss-7.1.1\modules\com\mysql\main>javac -version
javac 1.7.0_75
C:\jboss-7.1.1\modules\com\mysql\main>java -version
java version "1.7.0_75"
Java(TM) SE Runtime Environment (build 1.7.0_75-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.75-b04, mixed mode)
module.xml:
locacatoin : C:\jboss-7.1.1\modules\com\mysql\main
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-6.0.2.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
Standalone.xml
<datasource jndi-name="java:jboss/datasources/someDS" pool-name="someWebDbPool" enabled="true" use-java-context="true" spy="true">
<connection-url>jdbc:mysql://127.0.0.1:3306/some?useUnicode=true&characterEncoding=utf8&dontTrackOpenResources=true</connection-url>
<driver>mysql</driver>
<pool>
<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>false</prefill>
</pool>
<security>
<user-name>root</user-name>
<password>pwd12</password>
</security>
</datasource>
<drivers>
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
persistence.xml
<persistence version="2.0"
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="someUnit">
<jta-data-source>java:jboss/datasources/someDS</jta-data-source>
<class>...</class>
<properties>
<property name="hibernate.archive.autodetection" value="class" />
<property name="jboss.entity.manager.factory.jndi.name" value="java:jboss/nwEntityManager" />
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.default_schema" value="some"/>
</properties>
</persistence-unit>
</persistence>
error:
11:42:11,809 WARN [org.jboss.modules] (ServerService Thread Pool -- 27) Failed to define class com.mysql.cj.jdbc.Driver in Module "com.mysql:main" from local module loader @4afaa1a4 (roots: C:\jboss-7.1.1\modules): java.lang.UnsupportedClassVersionError: com/mysql/cj/jdbc/Driver : Unsupported major.minor version 52.0
at java.lang.ClassLoader.defineClass1(Native Method) [rt.jar:1.7.0_75]
at java.lang.ClassLoader.defineClass(ClassLoader.java:800) [rt.jar:1.7.0_75]
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) [rt.jar:1.7.0_75]
11:42:12,355 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 27) JBAS014612: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("jdbc-driver" => "mysql")
]): java.util.ServiceConfigurationError: java.sql.Driver: Provider com.mysql.cj.jdbc.Driver not found
at java.util.ServiceLoader.fail(ServiceLoader.java:231) [rt.jar:1.7.0_75]
How to repeat:
worked fine with mysql-connector-java-5.1.25-bin.
Description: we are updating the mysql connector java 6.x+ from the Mysql connector mysql-connector-java-5.1.25-bin. it was workig fine with Mysql connector mysql-connector-java-5.1.25-bin but has issue with mysql connector java 6.x+. Lib:mysql-connector-java-6.0.2 server: boss-7.1.1 java detail: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\jboss-7.1.1\modules\com\mysql\main>javac -version javac 1.7.0_75 C:\jboss-7.1.1\modules\com\mysql\main>java -version java version "1.7.0_75" Java(TM) SE Runtime Environment (build 1.7.0_75-b13) Java HotSpot(TM) 64-Bit Server VM (build 24.75-b04, mixed mode) module.xml: locacatoin : C:\jboss-7.1.1\modules\com\mysql\main <module xmlns="urn:jboss:module:1.0" name="com.mysql"> <resources> <resource-root path="mysql-connector-java-6.0.2.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module> Standalone.xml <datasource jndi-name="java:jboss/datasources/someDS" pool-name="someWebDbPool" enabled="true" use-java-context="true" spy="true"> <connection-url>jdbc:mysql://127.0.0.1:3306/some?useUnicode=true&characterEncoding=utf8&dontTrackOpenResources=true</connection-url> <driver>mysql</driver> <pool> <min-pool-size>0</min-pool-size> <max-pool-size>100</max-pool-size> <prefill>false</prefill> </pool> <security> <user-name>root</user-name> <password>pwd12</password> </security> </datasource> <drivers> <driver name="mysql" module="com.mysql"> <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> </driver> </drivers> persistence.xml <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="someUnit"> <jta-data-source>java:jboss/datasources/someDS</jta-data-source> <class>...</class> <properties> <property name="hibernate.archive.autodetection" value="class" /> <property name="jboss.entity.manager.factory.jndi.name" value="java:jboss/nwEntityManager" /> <property name="hibernate.show_sql" value="false" /> <property name="hibernate.default_schema" value="some"/> </properties> </persistence-unit> </persistence> error: 11:42:11,809 WARN [org.jboss.modules] (ServerService Thread Pool -- 27) Failed to define class com.mysql.cj.jdbc.Driver in Module "com.mysql:main" from local module loader @4afaa1a4 (roots: C:\jboss-7.1.1\modules): java.lang.UnsupportedClassVersionError: com/mysql/cj/jdbc/Driver : Unsupported major.minor version 52.0 at java.lang.ClassLoader.defineClass1(Native Method) [rt.jar:1.7.0_75] at java.lang.ClassLoader.defineClass(ClassLoader.java:800) [rt.jar:1.7.0_75] at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) [rt.jar:1.7.0_75] 11:42:12,355 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 27) JBAS014612: Operation ("add") failed - address: ([ ("subsystem" => "datasources"), ("jdbc-driver" => "mysql") ]): java.util.ServiceConfigurationError: java.sql.Driver: Provider com.mysql.cj.jdbc.Driver not found at java.util.ServiceLoader.fail(ServiceLoader.java:231) [rt.jar:1.7.0_75] How to repeat: worked fine with mysql-connector-java-5.1.25-bin.