Howard chen april 6 2010
Download
1 / 14

Howard Chen - April 6 - PowerPoint PPT Presentation


  • 384 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Howard Chen - April 6' - Melvin


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Howard chen april 6 2010 l.jpg

EGL Database Connections

Howard Chen - April 6, 2010

www.asiEGL.com


Egl database connections l.jpg
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


Define jdbc drivers 1 of 2 l.jpg
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


  • Define jdbc drivers 2 of 2 l.jpg
    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


    Create database connections as400 1 of 2 l.jpg
    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


    Create database connections as400 2 of 2 l.jpg
    Create Database Connections – AS400 2 of 2

    • Click Next

    • unCheck “Disable Filter”

    • Check “Expression” or “Selection” to select libraries

    • Click Finish


    Create database connections oracle 10g express l.jpg
    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


    Create database connections sql server 2008 l.jpg
    Create Database Connections – SQL Server 2008

    • Follow the same steps as described before

    • You can use 2005 Driver for SQL Server 2008 Database


    Define build descriptor db options 1 of 2 l.jpg
    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



    Context xml for tomcat l.jpg
    Context.xml for Tomcat

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


    Jar files for tomcat runtime l.jpg
    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


    Getting data from multiple databases l.jpg
    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


    Slide14 l.jpg

    Thank You

    [email protected]


    ad