Gegenstand
Ab Version APEX 3.2.x ist es möglich Oracle Forms Dialoge in XML in das Meta Repository von APEX zu laden, um im Anschluss diese Forms Dialoge in eine APEX Applikation zu migrieren. Dieser Ansatz soll genutzt bzw. verifiziert werden, um mit einem Code-Generator Oracle ADF - Applikationselemente zu generieren.
Ansatz
- Konfiguration APEX
- Update auf APEX 3.2.x
- Import eines Forms – Dialoges
- Analyse der extrahierten Meta-Informationen zu Forms
- Erstellen von Code-Generator - Templates für ADF
Komponenten
| | Bereich | Komponente |
| | TELDE | OES, JDK, Database |
| | APEX 3.2.1 | Download |
Umsetzung
| Bereich | Gegenstand |
| Putty | Action: Start Putty |
| | Action: Open Save Session telde.local als oracle |
| | |
| Configure APEX | login as: oracle
oracle@192.168.234.140's password:
Last login: Wed Oct 7 21:03:55 2009 from 192.168.234.1
[oracle@telde ~]$ . ./setDb1Env.sh Aktuelle Oracle Umgebung:
Oracle-Home: /u01/app/oracle/product/11.1.0/db_1
Oracle-SID: orcl
[oracle@telde ~]$ cd $OH/apex/
[oracle@telde apex]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 7 21:05:11 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @apxconf PORT
----------
8080 Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value. Enter a password for the ADMIN user [] welcome1
Enter a port for the XDB HTTP listener [ 8080] 8090
...changing HTTP Port PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Session altered. ...changing password for ADMIN PL/SQL procedure successfully completed. Commit complete. SQL> alter user anonymous account unlock; User altered. SQL>exit |
| | |
| Test | http://www.telde.local:8090/apex/apex_admin |
| 
|
| | Input Username: admin
Input Password: welcome1
Choose: Login |
|  |
| | Input Enter Current Password: welcome1
Input Enter New Password: welcome1
Input Confirm New Password: welcome1
Choose: Apply Changes
Choose: Return
Login again :) |
| | |
| Create Workspace |  |
| | Choose: Manage Workspaces / Create Workspace |
| | 
Input Workspace Name: telde
Choose: Next |
| | 
Input Schema Name: apex_telde
Input Password: welcome1
Choose: Next |
| | 
Input Administrator Password: welcome1
Input First Name: telde
Input Last Name: admin
Input Email: admin@telde.local
Choose: Next |
| | Choose: Create
Choose: Done
Choose: Login |
| | |
| Login to APEX Workspace |  |
| | Input Workspace: telde
Input Username: admin
Input Password: welcome1
Choose: Login |
| | |
| Update to APEX 3.2.x | [oracle@telde 3.2.x]$ cd /u01/product/oracle/database/3.2.x/ [oracle@telde 3.2.x]$ unzip apex_3.2.1.zip [oracle@telde 3.2.x]$ cd apex [oracle@telde apex]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 7 23:12:45 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @apexins SYSAUX SYSAUX TEMP /i/ : Upgrade completed successfully no errors encountered.
-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:01:02.67
...End of install if runtime install
...create null.sql
timing for: Development Installation
Elapsed: 00:13:42.70 SQL> exit |
| Install German Language | [oracle@telde apex]$ export NLS_LANG=GERMAN_GERMANY.AL32UTF8
[oracle@telde apex]$ cd builder/de/
[oracle@telde de]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Mi Okt 7 23:15:29 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter session set current_schema = APEX_030200;
SQL> @load_de.sql
. ____ ____ ____ ____
. / \ | \ /\ / | /
.| || / / \ | | |
.| ||--- ---- | | |--
.| || \ / \ | | |
. \____/ | \/ \ \____ |____ \____
.
. Application Express Hosted Development Service Installation.
.........................................................
Install Application Express applications : ...done
Adjust instance settings PL/SQL procedure successfully completed. SQL> exit |
| Install Style and Images | [oracle@telde apex]$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 7 23:32:52 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @apxldimg PL/SQL procedure successfully completed. Enter value for 1: /u01/product/oracle/database/3.2.x
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/u01/product/oracle/database/3.2.x/apex/images' Directory created. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Commit complete. timing for: Load Images
Elapsed: 00:02:42.12 Directory dropped. SQL> exit |
| Test | http://www.telde.local:8090/apex |
| |  |
Anmerkung
Next Step – Import eines Forms Dialoges in Form eines XML – Datei.
Keine Kommentare:
Kommentar veröffentlichen