MySQL Bugs: #84311: java.lang.ClassCastException: com.sun.proxy.$Proxy35 cannot be cast to com.mysql

Bug #84311	java.lang.ClassCastException: com.sun.proxy.$Proxy35 cannot be cast to com.mysql
Submitted:	22 Dec 2016 8:01	Modified:	22 Jan 2017 8:19
Reporter:	Vijay Kumar	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / J	Severity:	S1 (Critical)
Version:	5.1.37	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Hi Team,

we are mysql cluster based environment to have failover connection establishment through jboss datasource configuration.

jboss configuration:

jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true|jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true|jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true

The below exception is being thrown,

java.lang.ClassCastException: com.sun.proxy.$Proxy35 cannot be cast to com.mysql.jdbc.ConnectionImpl
        at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.wrapConnection(MysqlXADataSource.java:74)
        at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:61)
        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:505)
        ... 33 more

Can you please let us know know details to get out of this, as very important.?
i have observed the mysql doc on connection string,
https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-propertie...

request to please correct me where did it go wrong to throw exception (as mentioned above).

Thank you.

How to repeat:
Jboss configuration as

jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true|jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true|jdbc:mysql://<dbhostname>:3306/unicore?autoReconnect=true&characterEncoding=UTF-8&rewriteBatchedStatements=true

and then

Hello Vijay,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps, sample test case etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".