8 Replies Latest reply on Jul 7, 2015 5:39 AM by Chandrasekaran Gautam

    Error faced while getting the VDB Metadata using the ODBC Driver

    Chandrasekaran Gautam Newbie

      The issue is occurring in a specific scenario for an oracle source model.

       

      Consider the following table in oracle-

      Name Null? Type

      ----------------------------------------- -------- ----------------------------

      CUSTOMER_ID NOT NULL NUMBER

      CUST_FIRST_NAME NOT NULL VARCHAR2(20)

      CUST_LAST_NAME NOT NULL VARCHAR2(20)

      CUST_STREET_ADDRESS1 VARCHAR2(60)

      CUST_STREET_ADDRESS2 VARCHAR2(60)

      CUST_CITY VARCHAR2(30)

      CUST_STATE VARCHAR2(2)

      CUST_POSTAL_CODE VARCHAR2(10)

      PHONE_NUMBER1 VARCHAR2(25)

      PHONE_NUMBER2 VARCHAR2(25)

      CREDIT_LIMIT NUMBER(9,2)

      CUST_EMAIL VARCHAR2(30)

       

      Customer_ID is a NUMBER type column with Scale and precision as undefined.

      In this case the oracle jdbc driver returns the Scale as 38 and precision as 2147483647and the following function ((4 + (65536 * t1__1."Precision")) + t1__1.Scale) exceeds the Integer Max Value.

      This results in an exception while Querying the VDB metadata using the ODBC driver.