java.lang.NoClassDefFoundError: com/mysql/jdbc/MySQLConnection and 2 hours later…

After getting the ADF BCs up, I tried creating a facelet page to display the results. Upon trying to run the page, I received a similar mysql class not found exception. After many searches and computer restarts due to wls hanging on shutdown… I have finally found the solution to

Error 500–Internal Server Error

oracle.jbo.JboException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-29000. Error message parameters are {0=java.lang.NoClassDefFoundError, 1=com/mysql/jdbc/MySQLConnection}

I tried everything from

adding the mysql jar file to proj libraries

adding to “Database: JDBC Driver Options” in preferences

adding to C:\Oracle\Middleware\wlserver_10.3\server\ext\jdbc\mysql\

adding to C:\Users\USERNAME\AppData\Roaming\JDeveloper\system11.1.2.2.39.61.83.1\DefaultDomain

No dice, and just when I was about to call it quits… came across this post:

https://forums.oracle.com/forums/thread.jspa?threadID=424970

“I found that placing the connector jar in the <jdk install>/jre/lib/ext resolved this issue for me.”

FINALLY! Got a page to show up with data! Still, very strange… I’m not sure why after all the attempts to include jar file as part of the project and in the defaultdomain it would still not be picked up!

Things I like about the new jdev:

The connections are part of the project and can be directly imported along with a fresh new checkout from svn.

Advertisements

About wesfang

www.linkedin.com/in/wesfang/ https://twitter.com/wesleyfang
This entry was posted in Uncategorized. Bookmark the permalink.

4 Responses to java.lang.NoClassDefFoundError: com/mysql/jdbc/MySQLConnection and 2 hours later…

  1. nalaka says:

    Thank you.It was really helpful.

  2. Very very very extremely helpful…. thanks again 🙂

  3. Abdul says:

    thank you very much

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s