Topic
2 replies Latest Post - ‏2014-01-06T01:53:25Z by iyas2001
iyas2001
iyas2001
2 Posts
ACCEPTED ANSWER

Pinned topic IDMT cann't connect to Oracle

‏2013-12-24T07:55:26Z |

Hello,

I'd like to question about IDMT with Oracle.
My customer intends to use IDMT to move data from Oracle 8i to DB2 9.7. They try to connect to source Oracle 8i database, but the following error showed.
-------------------------------------------------------------------
  [2013-12-19 11.14.04.968] JDBC driver Oracle JDBC driver Version = 8.1.6.0.0  Exception in thread "AWT-EventQueue-0" java.lang.AbstractMethodError: oracle.jdbc.driver.OracleDatabaseMetaData.getDatabaseMajorVersion()I
          at ibm.DBData.getConnection(DBData.java:353)
          at ibm.IBMExtractUtilities.TestConnection(IBMExtractUtilities.java:1770)  
          at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:872)
-------------------------------------------------------------------

It looks some JDBC drivers error. They set classes12.zip or classes111.zip as JDBC drivers. I checked the following URL said support them.
https://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/
They also tried to connect via invalid userid and password, the error was the following. So they thought IDMT could reach Oracle.
-------------------------------------------------------------------
  [2013-12-19 11.09.25.734] Error connecting : oracle.jdbc.driver.OracleDriver for oracle Error Message :ORA-01017: invalid username/password; logon denied
  [2013-12-19 11.09.25.750] oracle JDBC connection problem. Please see console's output.
  java.sql.SQLException: ORA-01017: invalid username/password; logon denied
-------------------------------------------------------------------

Would you advise what they should do to work fine?

Regards.

  • nivanov1
    nivanov1
    22 Posts
    ACCEPTED ANSWER

    Re: IDMT cann't connect to Oracle

    ‏2013-12-31T15:33:30Z  in response to iyas2001

    I'd try using a more recent Oracle JDBC driver.

    • iyas2001
      iyas2001
      2 Posts
      ACCEPTED ANSWER

      Re: IDMT cann't connect to Oracle

      ‏2014-01-06T01:53:25Z  in response to nivanov1

      Hello, thank you for your reply.

      I've advised them to use more recent Oracle JDBC drivers.