1 / 22

Web Forms: The Great Leap Forward

Web Forms: The Great Leap Forward. A P Clarke. AGENDA. The application The migration process This web stuff The migrated application Questions. The Application. The starting point. Government agency regulatory authority issuing licences Core business system Richly-featured:

nuwa
Download Presentation

Web Forms: The Great Leap Forward

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Forms:The Great Leap Forward A P Clarke

  2. AGENDA • The application • The migration process • This web stuff • The migrated application • Questions Oracle World 2003 - #36625

  3. The Application Oracle World 2003 - #36625

  4. The starting point • Government agency • regulatory authority • issuing licences • Core business system • Richly-featured: • Third party workflow • Post Office Address validation • Complex technical calculations • Integration with MS Word and Excel • Developer 1.6.1 Oracle World 2003 - #36625

  5. Host OLE2 ORA_FFI OLEContainers Desktop drives Client/Server architecture Database Oracle World 2003 - #36625

  6. Host ORA_FFI OLE2 unix Web-deployed architecture Database Oracle World 2003 - #36625

  7. Going back to the application… • The following features will not work with web deployment… • Third party workflow • Address validation • D2KWUTIL • Calls to .DLL and .EXE files • Integration with MS Word • Production of Excel spreadsheets • Upload files • Reading registry …without making changes • This is not an upgrade, it is a migration Oracle World 2003 - #36625

  8. The Migration Process Can we build it? Yes we can! …er, sort of Oracle World 2003 - #36625

  9. Forms 4.5 to 9i Forms • Conversion • Migration Wizard • Forms Builder • OTN Web Site • Remember to start OC4J! • Icons: .ICO bad, .GIF good Oracle World 2003 - #36625

  10. Reports 2.5 to 9i Reports • Pretty straightforward • RUN_PRODUCT is de-supported in 9i Forms • RUN_REPORT_OBJECT • WEB.SHOW_DOCUMENT Oracle World 2003 - #36625

  11. unix Porting to Unix • Watch out for : • case sensitivity • embedded file names • directory separators • O9iDS is less usable on Unix • Not supported on terminal emulators Oracle World 2003 - #36625

  12. Workflow move to Java API Address validation move to new product File upload Forms demo PJC OLE Intergration JACOB D2KWUTIL calls ??? ORA_FFI calls ??? HOST ??? TEXT_IO ??? Client interaction Oracle World 2003 - #36625

  13. This Web Stuff Zounds! This web stuff is harder than it looks. If only I had a handy utility to do all the tough stuff for me. But where to find it? Oracle World 2003 - #36625

  14. Oracle Beta Pre-Production software Client side versions of old favourites CLIENT_HOST CLIENT_TEXT_IO CLIENT_OLE2 CLIENT_GET_FILE_DIR CLIENT_TOOL_ENV CLIENT_WIN_API_ENVIRONMENT New features WEBUTIL_FILE_TRANSFER WEBUTIL_HOST WEBUTIL_C_API WEBUTIL_CLIENTINFO WEBUTIL_BROWSER All straight PL/SQL calls Introducing WebUtil Oracle World 2003 - #36625

  15. Limitations of WebUtil • Uses Pluggable Java Components • Require PJC instantiations • Not useable in many triggers • Use timers • Can only use in Forms, not Reports or Menus • Create one-off Forms • Cannot get a Windows handle • Not always the best approach • CLIENT_TEXT_IO • CLIENT_OLE2 Oracle World 2003 - #36625

  16. So, do I have to become a Java head? • Must know how Java CLASSPATH works • ORA_JAVA requires some familiarity with: • classes • inheritance • May need to write your own Java class Oracle World 2003 - #36625

  17. Running on O9iAS • Current client/server apps now need O9iAS • licensing • administration • Getting this wrong can kill your project • Complex configuration • Need experienced O9iAS admin • Q: What killed the Reports Server? • A: Permissions on the /tmp directory Oracle World 2003 - #36625

  18. The Migrated Application Oracle World 2003 - #36625

  19. Migrated functionality • Through ORA_JAVA • Third party workflow • Address validation • Through WEBUTIL_C_API • Complex technical calculations • Terrain mapping • Through CLIENT_OLE2 • Integration with MS Word • Production of Excel spreadsheets • Through WEBUTIL miscellaneous • Upload files • Read registry Oracle World 2003 - #36625

  20. Lost functionality • Help files • Using Notepad to edit items • Performance • Using Forms to launch apps • Using timers instead of W-N-F-I • CLIENT_OLE2 time lag • IDENTIFIED EXTERNALLY • DLL transactions Oracle World 2003 - #36625

  21. Intangible benefits • Supported platform • Easier deployment • Standardisation of third party products Oracle World 2003 - #36625

  22. Any questions? andrew.clarke@logicacmg.com Oracle World 2003 - #36625

More Related