Results 1 to 10 of 10

Thread: Oracle SQL Developer to iSeries - JDBC Services?

  1. #1
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735

    Oracle SQL Developer to iSeries - JDBC Services?

    Howdy,

    Trying to figure out what the best way to get iSeries DB2 Data into JDE on Windows using Oracle DB (Yup, I think I wrote that write).

    On my Developer Box:
    - I can connect to the Oracle DB on the Windows Box - that is good
    - I've imported the .Jar files, that 'should' allow Oracle SQL Developer to talk to iSeries
    * I can see the "DB2" Tab in SQL Developer - and I am putting in all the 'correct' values in the right boxes (at least I think I am)
    - When I try to connect to the DB2 Database - I get, "Status : Failure -Test failed: [jcc][t4][2043][11550][3.57.82] Exception java.net.ConnectException: Error opening socket to server SiSeriesName/10.21.50.120 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001"

    I'm pretty sure the client is setup - I'm not so sure that a JDBC Service is running, or I have the JDBC Service Port - on the iSeries.

    Anyone wanna through some links or pointers? What am I missing? #LifeShouldBeSimpler?

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  2. #2
    What apps and tools are you on?

  3. #3
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735
    Re-Implementing
    - from E1 9.0, tools 9.1.5.7, DB2 on iSeries
    - To E1 9.2, Tools 9.2.x.x, Oracle on Windows

    Oracle SQL Developer should allow us to SQL data from the iSeries - just not sure what to turn on 'on the iSeries'....

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  4. #4
    Senior Member altquark's Avatar
    Join Date
    Oct 2000
    Location
    Kansas City, MO
    Posts
    2,612
    um - why are you doing this ?

    You should install Client Access onto your fat client, then create a datasource so you can see the data in the iSeries. If you want to move data from iSeries to Oracle, then use CopyTable. If you want to perform an upgrade, then you COPYTABLE the data in 9.0 format from iSeries to Oracle, and then run the conversions on the Oracle datasource to 9.2.

    Or perhaps theres another reason ?
    Jon Steel
    EnterpriseOne/SOA Technical Architect
    erpSOURCING LLC
    http://www.erpsourcing.com
    cto@spla.sh
    24/7 Assistance - (904) 382 5701

  5. #5
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735
    Jon,

    We are doing a 'Re-Implementation' - and not bringing all data across.

    An option might be to bring the tables across to a "Conversion" environment, in their entirety - but our functional folk would like that to be a 'Converted' Environment (so we can flash that data to any environment). Gee, maybe a Conversion Env and a Converted Env?...

    We are doing a lot of clean-up, and my plan is to script the changes - not just copy the whole tables.... Thus we are looking for an SQL-Type solution, where we can SQL-Script our conversion (against XRef tables)....

    AND, with all that noise being said - what do I need to 'turn on' on the iSeries, to make the JDBC connector functional?

    =D

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  6. #6
    Senior Member altquark's Avatar
    Join Date
    Oct 2000
    Location
    Kansas City, MO
    Posts
    2,612
    I don't believe you can connect SQL Developer to DB2/400 - it allows connectivity to DB2 UDB, but DB2/400 is completely different :

    SQL Developer 2.1.1 and 3.0 support connections to IBM DB2 LUW 7, 8, 9 .
    IBM DB2 iSeries and ZSeries Z/OS are not supported at this time.

    Although - connecting jDeveloper may be possible :

    http://appliedintegration.blogspot.com/2010/10/configuring-jdeveloper-11g-with-as400.html

    However, you should definitely consider using a Conversion environment - and bringing everything across in its entirety. Using a JDE Fat Client and Table Conversions (in the way I've demonstrated many times previously) is the fastest method - you'd bring your 9.0 data from the iSeries into Oracle "as is" - ie, it will correctly convert "nulls" and other data dictionary items, ready for the cleanup and scripts. Running the Table Conversions in Parallel will ensure that all the data is very QUICKLY moved across. Depending on how large your database is, and how large your largest table is. But a very fast connection on a powerful PC will likely ensure that the data is moved across in a few hours, and can be repeatedly ran throughout your reimplementation.
    Last edited by altquark; 02-16-2017 at 08:48 AM.
    Jon Steel
    EnterpriseOne/SOA Technical Architect
    erpSOURCING LLC
    http://www.erpsourcing.com
    cto@spla.sh
    24/7 Assistance - (904) 382 5701

  7. #7
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735
    What's being shared appears to be 'what needs to be done on the "client" side'.

    What/where do I need to install/configure/break-apart/set-fire-to - on the iSeries side (if anything)?

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  8. #8
    Senior Member altquark's Avatar
    Join Date
    Oct 2000
    Location
    Kansas City, MO
    Posts
    2,612
    Description

    The IBM Toolbox for Java / JTOpen is a library of Java classes supporting the client/server and internet programming models to a system running OS/400, i5/OS, or IBM i.

    JTOpenLite is a set of lightweight Java classes suitable for use on mobile devices. It provides Java application access to IBM i: DDM access, basic JDBC access, command call, program call access, etc.

    Packages are delivered by following PTF on IBM i platform:
    V7R3: SI61258
    V7R2: SI61255
    V7R1: SI61254
    Jon Steel
    EnterpriseOne/SOA Technical Architect
    erpSOURCING LLC
    http://www.erpsourcing.com
    cto@spla.sh
    24/7 Assistance - (904) 382 5701

  9. #9
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735
    AND what has to be turned on inside the iSeries OS? If JDBC is on by default - where do I confirm which port?

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  10. #10
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,735
    Using "Squirrel SQL" to test a JDBC Connection to our iSeries - I can confirm that you it is possible to connect an SQL Client to an iSeries via JDBC.

    I can also confirm that it appears Oracle SQL Developer is not formatting the connect string correctly (OSD is BROKEN).....

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.