1 / 14

Howard Chen - April 6, 2010

EGL Database Connections. Howard Chen - April 6, 2010. www.asiEGL.com. EGL Database Connections. Define JDBC Drivers DB2/400 Oracle 10g Express SQLServer 2008 Create Database Connections DB2/400 Library Oracle HR Database SQLServer Northwind Database Define Build Descriptor db Options

Download Presentation

Howard Chen - April 6, 2010

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. EGL Database Connections Howard Chen - April 6, 2010 www.asiEGL.com

  2. EGL Database Connections • Define JDBC Drivers • DB2/400 • Oracle 10g Express • SQLServer 2008 • Create Database Connections • DB2/400 Library • Oracle HR Database • SQLServer Northwind Database • Define Build Descriptor db Options • Define context.xml for Tomcat 5 and up • Additional runtime jar files • Getting data from multiple databases

  3. Define JDBC Drivers 1 of 2 JDBC Drivers: • DB2/400: jt400.jar • AS/400 toolbox for java default • Oracle: ojdbc14.jar • <version> Oracle thin driver default • SQLServer: sqljdbc4.jar • <version> SQL server JDBC driver default • Window  Preferences  Data Management  Connectivity  Driver Definitions • Highlight Driver name • Click Edit

  4. Define JDBC Drivers 2 of 2 • If EGL displays an error message that says “Unable to locate JAR” • Click “Jar List” • Click to highlight the jar file • Click “Edit JAR/Zip • Browse to the location of the jar file you downloaded and saved • Click Open. The “Unable to locate JAR” message is resolved

  5. Create Database Connections – AS400 1 of 2 • Window  Preferences  EGL  SQL Database Connections • Click New • Select “DB2 for i5/OS” • Accept the default driver name • Enter the host name, it can be an IP address or a DNS name • Enter User Name and Password • Check “Save Password” • Click Test Connection

  6. Create Database Connections – AS400 2 of 2 • Click Next • unCheck “Disable Filter” • Check “Expression” or “Selection” to select libraries • Click Finish

  7. Create Database Connections – Oracle 10g Express • Follow the same steps as described before • Optionally, you can click the triangle icon to the right of the JDBC driver name to update JDBC driver jar file

  8. Create Database Connections – SQL Server 2008 • Follow the same steps as described before • You can use 2005 Driver for SQL Server 2008 Database

  9. Define Build Descriptor DB Options 1 of 2 • Open <project>.eglbld file • From “Load DB options using Connections drop down box • Select the db connection • Enter the JNDI name • Press Ctrl-S to save

  10. Define Build Descriptor DB Options 2 of 2

  11. Context.xml for Tomcat • Put Context.xml file in <project>/WebContent/META-INF folder

  12. JAR Files for TOMCAT Runtime • DB2/400 • jt400.jar • db2jcc.jar • db2jcc_license_cisuz.jar • db2jcc_license_cu.jar • Oracle • ojdbc14.jar • activation.jar • mail.jar • SQL Server 2008 • sqljdbc4.jar C:\Program Files\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.0.101.v200811061754\driver

  13. Getting Data From Multiple Databases • Create a project for each db connection • Use Data Access Wizard to retrieve database definitions • Create Web Services for data access • Copy wsdl files to the Application Project • Use “EGL Service”  “Create EGL Client Interface” to create Web Service interfaces • Consume web services for both JSF and RUI

  14. Thank You howard.chen@asiegl.com

More Related