Database Connection issues in Jdeveloper with MySQL Database

If having an issue connecting Jdeveloper with MySQL database, it may be caused by Driver. You need to download the correct driver

You may also face the following issue which also may be caused by the inappropriate driver.

Test failed: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long mysql jdeveloper
Or
Test failed: Unknown system variable 'query_cache_size'


Let's download the updated connector and configure it in JDeveloper https://www.mysql.com/products/connector/

Download JDBC Driver for MySQL

OR 
from maven repository

Click on the jar file to download the connector










Now Click on the "Test Connection" button it should work and now you're ready to roll. 

Cheers!

Comments

Post a Comment

Popular posts from this blog

Unable to create a server socket for listening on channel "Default[4]". The address 0:0:0:0:0:0:0:1 might be incorrect or another process is using port 8001: java.net.BindException: Address already in use: JVM_Bind.

Image
Tools and technologies Oracle SOA Suite 11.1.1.3.0, WebLogic 10.3.3 Windows Vista 32 bit Operating System When I was starting managedWebLogic as administrator after starting webLogic as administrator the window for managedWebLogic was disappearing, I saw the log file and found following exception, Note: log files are located at “\Oracle\Middleware\user_projects\domains\base_domain\servers\soa_server1\logs” ###<Nov 9, 2010 2:59:36 PM AST> <Error> <Server> <Adnan> <soa_server1> <DynamicListenThread[Default[4]]> <<WLS Kernel>> <> <11d1def534ea1be0:-4197085:12c30801a8c:-7ffd-0000000000000006> <1289303976834> <BEA-002606> <Unable to create a server socket for listening on channel "Default[4]". The address 0:0:0:0:0:0:0:1 might be incorrect or another process is using port 8001: java.net.BindException: Address already in use: JVM_Bind.> ####<Nov 9, 2010 2:59:36 PM AST> <Error> <Serv...
Read more

[Deployer:149164]The domain edit lock is owned by another session in exclusive mode - hence this deployment operation cannot proceed.

I faced the problem server giving me error "[Deployer:149164]The domain edit lock is owned by another session in exclusive mode - hence this deployment operation cannot proceed ." when I tried to redeploy the application on intergrated weblogic server of Oracle JDeveloper 11. I could not solved this issue even I restarted my computer. anyhow it is solved let me explain the steps which I did for it . 1. go to admin console of weblogic on my integrated weblogic the address were http://127.0.0.1:7101/console 2. login to server console by using defaul user name password which would be username:"weblogic" and password :"weblogic1". 3. on successful login check the button on your upper left corner where you can activate pending changes or discard pending changes. click on that button. issue would be solved. Regards.
Read more

ERROR: No j2ee modules detected in EAR archive. Deployment aborted. == (oracle.jdeveloper.deploy.VetoableDeployException)

Image
When I was deploying application to EAR file I was keep receiving error message from my Jdeveloper that "ERROR: No j2ee modules detected in EAR archive. Deployment aborted. == (oracle.jdeveloper.deploy.VetoableDeployException)" I am having two projects in my application 1. Model (Having ejbs) 2. ViewController To resolve this issue, go to application properties and select Deployment Edit your deployment profile Select EE modules to include in ear file Doing this solved my issue. Cheers...!
Read more