Building the FOD Schema in JDeveloper for ADF

JDeveloper 11g comes in built with a sample application called FOD, i.e. Fusion Order Demo. The recommendation is to navigate and experiment through this application after you have learn the basics of ADF.

The pre-requisites for installing the FOD are

1. Install the JDeveloper 11g, from here
http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html
2. Install Oracle XE Database, from here
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
3. Download the sample FOD application, from here
http://www.oracle.com/technetwork/developer-tools/jdev/index-095536.html

Follow the instruction in the URL for the FOD, and for some users the FOD will install smoothly.

However, in some cases, you may get the error similar to below
refreshSchema:

BUILD FAILED
C:\JDeveloper\demo\Infrastructure\Ant\build.xml:51: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:100: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:63: The following error occurred while executing this line:
C:\JDeveloper\demo\Infrastructure\DBSchema\build.xml:28: C:\Oracle\Middleware\jdeveloper\wlserver_10.3\server\lib not found.

Total time: 6 seconds

In order to resolve this issue, first find the JDeveloper installation location. In my case it is C:\Oracle\Middleware\jdeveloper

Next run the Ant script with Build All

Buildfile: C:\JDeveloper\demo\Infrastructure\Ant\build.xml

init:
   [javac] Compiling 1 source file to C:\JDeveloper\demo\Infrastructure\Ant\classes

setProperties:

createDatabase:

refreshSchema:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Failed to execute:       DROP USER FOD CASCADE
     [sql] java.sql.SQLSyntaxErrorException: ORA-01918: user 'FOD' does not exist

     [sql] 10 of 11 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
    [echo] Warning: An unlocked database user 'FOD' has been created, with create session, table, and sequence privileges.

createSchemaObjects:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\createFODSchemaObjects.sql
     [sql] 489 of 489 SQL statements executed successfully

createSequenceTriggers:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\createSequenceTriggers.sql
     [sql] 20 of 20 SQL statements executed successfully

populateTables:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 4 of 4 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
    [echo] Demo Options Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\AVAILABLE_LANGUAGES.sql
     [sql] 5 of 5 SQL statements executed successfully
    [echo] Available Languages Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 244 of 244 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 244 of 244 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 244 of 244 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 244 of 244 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 244 of 244 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
    [echo] Country Codes Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 66 of 66 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 66 of 66 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 66 of 66 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 66 of 66 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 66 of 66 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
    [echo] Lookup Codes Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ADDRESSES.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\DISCOUNTS_BASE.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\MEMBERSHIPS_BASE.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\SHIPPING_OPTIONS_BASE.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\SUPPLIERS.sql
     [sql] 173 of 173 SQL statements executed successfully
    [echo] Addresses, Memberships, Discounts, Shipping Options and Suppliers Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\DISCOUNT_TRANSLATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ELIGIBLE_DISCOUNTS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\MEMBERSHIP_TRANSLATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\PERSONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\SHIPPING_OPTION_TRANSLATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\WAREHOUSES.sql
     [sql] 117 of 117 SQL statements executed successfully
    [echo] Persons, Warehouses, Discount Translations, Shipping Option Translations, and Eligible Discounts Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ADDRESS_USAGES.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\CUSTOMER_IDENTIFICATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\PAYMENT_OPTIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCT_CATEGORIES_BASE.sql
     [sql] 197 of 197 SQL statements executed successfully
    [echo] Address Usages, Customer Identifications, Payment Options, Product Categories, and Orders Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\CATEGORY_TRANSLATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\CUSTOMER_INTERESTS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ORDERS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCTS_BASE.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\WAREHOUSE_STOCK_LEVELS.sql
     [sql] 425 of 425 SQL statements executed successfully
    [echo] Products, Warehouse Stock Levels, Coupon Usages, Categories, and Customer Interests Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ALTER_TABLES.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\COUPON_USAGES.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\HELP_TRANSLATIONS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\ORDER_ITEMS.sql
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\DataScripts\PRODUCT_TRANSLATIONS.sql
     [sql] 165 of 165 SQL statements executed successfully
    [echo] Coupon Usages, Product Translations, Order Items, and Help Translations Created
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\PackageScripts\user_context.sql
     [sql] 2 of 2 SQL statements executed successfully
    [echo] USER_CONTEXT Package Created

createIndexes:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\createIndexes.sql
     [sql] 2 of 2 SQL statements executed successfully
    [echo] Indexes Created

compileImagesApp:
   [mkdir] Created dir: C:\JDeveloper\demo\Infrastructure\DBSchema\classes
   [javac] Compiling 3 source files to C:\JDeveloper\demo\Infrastructure\DBSchema\classes
   [javac] Note: C:\JDeveloper\demo\Infrastructure\DBSchema\src\oracle\fodemo\share\imageloader\EnvProvider.java uses or overrides a deprecated API.
   [javac] Note: Recompile with -Xlint:deprecation for details.
   [javac] Note: C:\JDeveloper\demo\Infrastructure\DBSchema\src\oracle\fodemo\share\imageloader\EnvProvider.java uses unchecked or unsafe operations.
   [javac] Note: Recompile with -Xlint:unchecked for details.
    [copy] Copying 5 files to C:\JDeveloper\demo\Infrastructure\DBSchema\classes

populateImages:
    [java] 07-Jan-2012 19:01:08 oracle.adf.share.ADFContext getCurrent
    [java] WARNING: Automatically initializing a DefaultContext for getCurrent.
    [java] Caller should ensure that a DefaultContext is proper for this use.
    [java] Memory leaks and/or unexpected behaviour may occur if the automatic initialization is performed improperly.
    [java] This message may be avoided by performing initADFContext before using getCurrent().
    [java] For more information please enable logging for oracle.adf.share.ADFContext at FINEST level.
    [java] 07-Jan-2012 19:01:08 oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
    [java] INFO: Resource META-INF/adf-config.xml not found on the classpath.
    [java] 07-Jan-2012 19:01:08 oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
    [java] INFO: A default implementation of ADFConfig is being created for application. This can lead to unexpected results in some cases. Please add a basic META-INF/adf-config.xml to your classpath to avoid functional errors.

revokePrivs:
     [sql] Executing resource: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
     [sql] 6 of 6 SQL statements executed successfully
  [delete] Deleting: C:\JDeveloper\demo\Infrastructure\DBSchema\Scripts\SQLRunner211433687.sql
    [echo] Cleaning up database user privileges.

createDatabase:
    [echo] Database (Re)Creation Complete

buildAll:

BUILD SUCCESSFUL
Total time: 1 minute 4 seconds

Anil Passi

<< Apr 2024 >>
Mon	Tue	Wed	Thu	Fri	Sat	Sun
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

<< Apr 2024 >>

Mon

Tue

Wed

Thu

Fri

Sat

Sun

Comments

0 #1 Shreekar 2012-01-08 11:12

Happy new year Anil.... Blogging after a long time.. I hope you will be doing some more ADF articles. Keep up the good work !

Quote

0 #2 Boris 2012-05-12 11:00

Sorry I disterb you.
I'm beginner in jdeveloper and try to work with bpel there are two questions
1) how I can work with multidatabases for one app ?
2) how to start to work in jdeveloper(webl ogic) with bpel ?

Many thanks
Boris

Refresh comments list
RSS feed for comments to this post

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Search Courses