ADF - MYSQL JDBC connection issue.

ADF JDBC Error:

java.lang.ClassCastException: com.mysql.jdbc.JDBC4Connection cannot be cast to oracle.jdbc.OracleConnection
    at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5534)
    at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:5329)
    at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1167)
    at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6838)
    at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:298)
    at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:329)
    at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
    at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:600)
    at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:417)
    at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9053)
    at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4606)
    at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2536)
    at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2346)
    at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3245)
    at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:571)
    at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:504)
    at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:499)
    at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:517)
    at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:867)
    at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:222)
    at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:945)
    at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:646)
    at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:612)
    at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:446)

Solution:

To resolve this issue, select the SQL Platform to SQL92 when creating the entity objects and associations. SQL92 is the SQL standard platform to connect to MySQL database.  The default selection of Oracle should be used when connecting to Oracle Database.

Please note:  This is a one time setup. This option will not be available to view or modify after the selection is made. Check out the below screenshot for details.

Enjoy and have fun !