5 Replies Latest reply on Aug 22, 2012 2:14 PM by 460076

    How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC

    Maximiliano García
      Hi,

      I'm trying to connect OWB 11.2.0.2 with DB2 V6R1 for AS/400 system through JDBC.

      According to this guide (http://download.oracle.com/docs/cd/E11882_01/owb.112/e10582/jdbc_connection.htm#CHDGHFBG), OWB expected as DB2 Driver file the db2jcc.jar.
      But, JTOpen files are jt400.jar and jt400Native.jar. When I copy these files in OWB_HOME/lib/ext and after I try to create one Native DB2 Location, a message appears indicating that isn't finding db2jcc.jar.

      Can we help me explaining how to I install/use JTOpen in OWB?

      Thanks!

      García Maximiliano.
        • 1. Re: How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC
          David Allan-Oracle
          Hi

          You can copy your JAR files to owb/lib/ext and ensure when you create the location for your DB2 instance using JTOpen that you put the correct driver name - for example com.ibm.as400.access.AS400JDBCDriver then you must ensure the URL is a valid DB2 JTOpen URL.

          Cheers
          David
          • 2. Re: How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC
            Maximiliano García
            Hi David, thanks for your upgrade!

            The connection is working now, and I created one template mapping reading one table from QGPL schema in AS/400, and I'm trying to deliver these data to an target table in a Oracle Module.

            This mapping validate and generate ok, but when i'm trying to deploy this, an error message appears:

            I have set default agent, and test successfully, then I create a new mapping under code template module. When I deploy the mapping, I got following erros:

            {0}CCA-1102: Error encountered while retrieving deployment strategy oracle.wh.jrt.client.deploy.strategy.JSR88DeploymentStrategy.
            Caused by: oracle.wh.jrt.client.deploy.DeploymentException oracle.wh.jrt.client.deploy.DeploymentException: oracle.wh.jrt.client.deploy.DeploymentException: CCA-1107: Deployment failed because deployment configuration for application CT_MAPPING-REP_OWNER-MIS-MY_PROJECT-MÓDULO_DE_CORRESPONDENCIA_1-CORRESPONDENCIA_1--JRT is not available.
            Caused by: java.lang.NullPointerException null

            Unfortunately, I can not find any information about errors from Internet.

            Anybody can help me?
            • 3. Re: How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC
              460076
              Hi David,

              I'm looking for a solution to this problem. I follow your instructions and try with many kind of drivers, but I still I can't see the tables structure in the OWB.

              I'd appreciate your help.

              Regards.
              • 4. Re: How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC
                David Allan-Oracle
                Hi

                Tell me more about what you are doing, versions connecting to and what error you are hitting.


                Best start a new thread, it was by chance I checked this out.
                Cheers
                David
                • 5. Re: How to connect OWB 11.2.0.2 with DB2 V6R1 (AS/400) with JTOpen through JDBC
                  460076
                  Hi David,
                  We are trying to get a connection to db2 on a as400. What ever we try jtopen etc we fail.
                  We can make a connection to the DB2 database but we cannot see any table at all.
                  I used your tcl script as the sample but I just can see the schemas but not tables .
                  OMB+> source g:/Data_work/IBM_jdbc/jdbc_info_1.tcl
                  Schema: XXX
                  Schema: XXX
                  Schema: XXX
                  Schema: XXX
                  Schema: XXX
                  Schema: XXX
                  Schema: XXX
                  OMB+>
                  set driver "com.ibm.as400.access.AS400JDBCDriver"
                  set connect "jdbc:as400://XX.XX.X.XX;naming=sql;errors=full;date format=iso"
                  set username "XXX"
                  set pass "XXX"
                  I also tried with this driver DSClients--jdbc_sqlj-9.7.0.1 IBM Data Server Driver for JDBC and SQLJ V9.7 Fix Pack 1
                  I copy this two files db2jcc.jar db2jcc4.jar and keep the files db2jcc_license_cu.jar, db2jcc_license_cisuz.jar
                  I change your tcl script
                  set driver "com.ibm.db2.jcc.DB2Driver"
                  set connect "jdbc://73.37.0.42;naming=sql;errors=full;date format=iso"
                  set username "XXX"
                  set pass "XXX"

                  C:\owb11g\owb\bin\win32>OMBPlus.bat c:\jdbc_info_db2.tcl
                  java.sql.SQLException: No suitable driver

                  But I get this error, I and tried with the Design Center, and I can connect but I can’t see the tables.
                  Thanks for your help.

                  Edited by: Nandex on 22-08-2012 09:43 AM