RE: [ADF EMG] ADF and PL/SQL code

[John Flack]

I can tell you what we do:

We have a separate JDeveloper Application (.jws) called “Databases” (well, the actual name is more specific).  There is one Project (.jpr) for each application database.  The projects are all configured for offline database objects and database design.  We used to put these projects in the Application next to the Model and View Controller projects, but we found that different people were working on database design and PL/SQL development, and that we needed to do database releases separately from application releases.  In fact, right now I’ve got an application version 3.0 in testing that runs against the 2.1 database – we made no database changes from the database expected by the 2.1 version of the application.  When we deploy an ADF application, we specify which version of the database it expects.

 

When you have a JDeveloper project configured for offline database objects, you can generate the offline objects from the current database.  You can do your DDL and PL/SQL changes, and generate either a script to implement the changes, or generate directly to the database (we only do that for development databases, all others must go to a script).  When you generate, you can compare the offline database with the online database and generate “ALTER” commands to make the online database look like the offline database.  The tools for drawing database design diagrams and changing database elements are very good.  The PL/SQL editor is pretty much the same as the one in SQL Developer.

 

From: adf-met...@googlegroups.com [mailto:adf-met...@googlegroups.com] On Behalf Of alexander.reichman
Sent: Monday, April 15, 2013 12:10 PM
To: adf-met...@googlegroups.com
Subject: [ADF EMG] ADF and PL/SQL code

 

Hello,

We just started our first ADF development project and I have a question regarding “best practices” of deploying ADF and SQL code. We are re-developing the Forms application which was converted from forms 6i to 11g. Our current forms application patches contain the forms and SQL/PL-SQL code (Patchxxx.sql). What are the best practices for developing SQL/PL-SQL code with ADF? Should it be also separated Patchxxx.sql or can SQL code be a part ADF BC?

Thank you in advance

Alex