3 Replies Latest reply: May 14, 2013 5:41 PM by vladodias RSS

    unable to poll the table from DB Adapter

    972017
      Hi,

      Here i am unable to poll the table from DB Adapter, table haveing a total 40colums .
      If table have 30 colums then it will fine and DB Adpter working good .but i am unable to poll the more then 30 colums tables .please help me on this issue requsting you....

      Thanku,
      Ram
        • 1. Re: unable to poll the table from DB Adapter
          vladodias
          Hi,

          I've never heard about a limitation on DbAdapter regarding the number of columns... A problem with one of the columns' type is more likely...

          Please share the table description of one of the tables that it's not being able to poll...

          Cheers,
          Vlad
          • 2. Re: unable to poll the table from DB Adapter
            972017
            Hi vladodias ,

            thanku for replying ,this my table description please look into below table


            CREATE TABLE "SIEBEL"."CX_CON_INT_TABLE"
            ( "CUSTOMER_NO" VARCHAR2(13 BYTE),
            "FIRST_NAME" VARCHAR2(105 BYTE),
            "MIDDLE_NAME" VARCHAR2(105 BYTE),
            "LAST_NAME" VARCHAR2(105 BYTE),
            "CUSTOMER_NAME" VARCHAR2(105 BYTE),
            "DATE_OF_BIRTH" DATE,
            "E_MAIL" VARCHAR2(255 BYTE),
            "FAX" VARCHAR2(105 BYTE),
            "UDF_4" VARCHAR2(150 BYTE),
            "FULL_NAME" VARCHAR2(105 BYTE),
            "RESIDENT_STATUS" VARCHAR2(15 BYTE),
            "CUSTOMER_PREFIX" VARCHAR2(30 BYTE),
            "SEX" VARCHAR2(20 BYTE),
            "E_TELEPHONE" VARCHAR2(105 BYTE),
            "P_NATIONAL_ID" VARCHAR2(105 BYTE),
            "PASSPORT_NO" VARCHAR2(20 BYTE),
            "PPT_ISS_DATE" DATE,
            "PPT_EXP_DATE" DATE,
            "LEGAL_GUARDIAN" VARCHAR2(105 BYTE),
            "UDF_5" VARCHAR2(150 BYTE),
            "RECORD_STAT" VARCHAR2(10 BYTE),
            "NATIONALITY" VARCHAR2(3 BYTE),
            "CUSTOMER_CATEGORY" VARCHAR2(10 BYTE),
            "CUSTOMER_TYPE" VARCHAR2(1 BYTE),
            "ROW_ID" NUMBER,
            "CON_SINCE_DT" DATE,
            "CON_MARITAL_STATUS" VARCHAR2(20 BYTE),
            "CON_SPOUSE_NAME" VARCHAR2(105 BYTE),
            "CON_ID_TYPE" VARCHAR2(30 BYTE),
            "CON_EXT_ID" VARCHAR2(25 BYTE),
            "ORGANIZATION" VARCHAR2(100 BYTE),
            "CUSTOMER_SEG" VARCHAR2(10 BYTE),
            "AML_REQUIRED" VARCHAR2(1 BYTE),
            "TELEPHONE" VARCHAR2(105 BYTE)
            ) SEGMENT CREATION IMMEDIATE
            PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
            STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
            PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
            TABLESPACE "S_DATA" ;

            This my .JCA File

            <adapter-config name="EcoDBReadAdpter" adapter="Database Adapter" wsdlLocation="EcoDBReadAdpter.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">

            <connection-factory location="eis/db/ecoxproduct" UIConnectionName="siebelDB" adapterRef=""/>
            <endpoint-activation portType="EcoDBReadAdpter_ptt" operation="receive">
            <activation-spec className="oracle.tip.adapter.db.DBActivationSpec">
            <property name="DescriptorName" value="EcoDBReadAdpter.CxContactIntTable"/>
            <property name="QueryName" value="EcoDBReadAdpterSelect"/>
            <property name="MappingsMetaDataURL" value="EcoDBReadAdpter-or-mappings.xml"/>
            <property name="PollingStrategy" value="DeletePollingStrategy"/>
            <property name="PollingInterval" value="5"/>
            <property name="MaxRaiseSize" value="1"/>
            <property name="MaxTransactionSize" value="10"/>
            <property name="NumberOfThreads" value="1"/>
            <property name="ReturnSingleResultSet" value="false"/>
            </activation-spec>
            </endpoint-activation>

            </adapter-config>

            Thanku,
            ram

            Edited by: 969014 on May 14, 2013 3:42 AM
            • 3. Re: unable to poll the table from DB Adapter
              vladodias
              "***" VARCHAR2(20 BYTE),
              You don't have a column named "***", do you? Assuming that the above is not the real column name, but omitted for some reason, I don't see any reason why DbAdapter won't be able to poll from that table...