How to add ADF source code in JDeveloper 12c ?

Problem

I want to have ADF source code available in my project.

Solution
  • Open service request ticket at My Oracle Support and ask to provide you a source code for ADF. Oracle staff will provide you a security code and a link to download a zip file.
  •  Open JDeveloper, select Tools -> Manage Libraries... 
    • Click Libraries tab
    • Select folder User
    • Click New
    • Select Source Path on the right pane then click Add Entry... 
    • Point to zip file received from Oracle

  • Add defined library to particular project
    • Right click on project folder and select Properties
    • Select Libraries and Classpath on the left pane
    • Click Add Library on the right pane
    • Point to previously defined ADF source code library which should be available in User folder
  • You should be able to access ADF source classes now!
JDeveloper version 12.1.3.0.0




I get JBO-25200: Application module is not connected to a database exception. What can be the reason?

Problem

Time to time "JBO-25200: Application module is not connected to a database" exception is raised while browsing ADF application

Solution

Tune ADF application module by disabling "Support Dynamic JDBC Credentials".


However this solution may not work in your case, depends on the root cause.

Comment

If I understand this option correctly, it is needed only when application users must access DB using their personal credentials, but not one used for app in general. From my experience the latter approach is used usually (single DB user is created for app to access data). Thus this option is not necessary to be selected, especially when it involves additional lifecycles. And they make us problems like described above :)

Documantation about this application module option tell us:
Enables additional pooling lifecycle events to allow developer-written code to change the database credentials (username/password) each time a new user session begins to use the application module. This feature is enabled by default (true), however this setting is a necessary but not sufficient condition to implement the feature. The complete implementation requires additional developer-written code.

ADF version 12.1.3.0.0