【已解决】2.1.3 catalog 连接 Oracle 出现报错,2.1.2 还是正常的

Viewed 70

2.1.2 的时候 catalog 连接 Oracle (版本 12C)是没有问题的 但是 2.1.3 连接报错

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = (1.1.3.1)[CANCELLED]UdfRuntimeException: Initialize datasource failed: 
CAUSED BY: PoolInitializationException: Failed to initialize pool: ONS configuration failed
CAUSED BY: IllegalArgumentException: ONS configuration failed
CAUSED BY: NoServersAvailable: Server time out
2 Answers

oracle 表结构如下

-- auto-generated definition
create table PURORDER
(
    ORDICODE                  VARCHAR2(32) not null
        constraint PURORDER_PK
            primary key,
    ORDCODE                   VARCHAR2(64) not null,
    SHEETCODE                 VARCHAR2(20) not null,
    OUTORDERCODE              VARCHAR2(64),
    MENUDWID                  VARCHAR2(64),
    JCODE                     VARCHAR2(32),
    ORDTYPE                   VARCHAR2(4),
    PAYMODE                   VARCHAR2(4),
    PAYCOND                   VARCHAR2(4),
    SHIPMODE                  VARCHAR2(2),
    SENDMODE                  VARCHAR2(2),
    PURODATE                  DATE,
    PAYMODEDETAIL             VARCHAR2(255),
    PROICODE                  VARCHAR2(32),
    PROCODE                   VARCHAR2(64),
    PURREQICODE               VARCHAR2(32),
    PURREQCODE                VARCHAR2(64),
    FCODE                     VARCHAR2(4),
    RERATE                    NUMBER(17, 8),
    UERATE                    NUMBER(17, 8),
    CGTYPE                    VARCHAR2(4),
    EXTDWID                   NUMBER(5),
    DATASOURCE                VARCHAR2(4),
    CCODE                     VARCHAR2(20),
    BCODE                     VARCHAR2(32),
    VPREPARE                  VARCHAR2(16),
    PREDATE                   DATE,
    STATUS                    VARCHAR2(4),
    TERMMODELCODE             VARCHAR2(20),
    WFPERFORMDATE             DATE,
    SADDRTO                   VARCHAR2(255),
    FCY                       NUMBER(19, 4),
    RMB                       NUMBER(19, 4),
    USD                       NUMBER(19, 4),
    COMURMB                   NUMBER(19, 4),
    RFQICODE                  VARCHAR2(32),
    RFQCODE                   VARCHAR2(64),
    PCONICODE                 VARCHAR2(32),
    PCONCODE                  VARCHAR2(64),
    SALORDICODE               VARCHAR2(32),
    SALORDCODE                VARCHAR2(64),
    PAYCYCLE                  NUMBER(5),
    INVICODE                  VARCHAR2(32),
    FLAGS                     NUMBER(5),
    ODATE                     DATE,
    CONSIGNDATE               DATE,
    RDATE                     DATE,
    SUBSCRIBEDATE             DATE,
    CONSIGNDATEF              DATE,
    ISNEWOLDCCODE             VARCHAR2(2),
    RATIFYDESC                VARCHAR2(2000),
    SHEETDESC                 VARCHAR2(2000),
    SHEETMODIFYFLAGS          NUMBER(5),
    REMARK                    VARCHAR2(3000),
    MODIFYDATE                DATE,
    GCODETYPE                 VARCHAR2(4),
    MODIFYDESC                CLOB,
    FINANCEFINIS              NUMBER(5),
    SYSAUTOMAKE               NUMBER(5),
    FIRSTFLAGS                NUMBER(5),
    VERDATE                   DATE,
    GOODSBATCH                VARCHAR2(4),
    TRADETYPE                 VARCHAR2(4),
    TRADEMODE                 VARCHAR2(8),
    BUSIMODE                  VARCHAR2(4),
    BUSITYPE                  VARCHAR2(4),
    HTYPE                     VARCHAR2(8),
    PICODE                    VARCHAR2(32),
    PCODE                     VARCHAR2(64),
    BOPPICODE                 VARCHAR2(32),
    BOPPTCODE                 VARCHAR2(64),
    PNAME                     VARCHAR2(255),
    EXPIRYDATE                DATE,
    SIGNSITE                  VARCHAR2(100),
    ACCESSORIES               LONG RAW,
    SCOPESECODE               VARCHAR2(16),
    VOCATIONCODE              VARCHAR2(16),
    CONTSOURCE                VARCHAR2(4),
    ZEROSTOCK                 VARCHAR2(4),
    BACKODATE                 DATE,
    BACKOKFLAGS               NUMBER(5),
    PRICETERM                 VARCHAR2(32),
    ISSHAREBCODE              NUMBER(5),
    PAYMODEDESC               VARCHAR2(255),
    SHIPLIMDESC               VARCHAR2(255),
    INSURANCETERM             VARCHAR2(50),
    SHAREBCODE                VARCHAR2(1000),
    PROJECTSOURCE             VARCHAR2(4),
    PUTONTYPE                 VARCHAR2(8),
    PUTONDATE                 DATE,
    PROCESSMODE               VARCHAR2(4),
    AGEBAILRATE               NUMBER(17, 8),
    AGEBAILREMARK             VARCHAR2(255),
    SHIPMODEDESC              VARCHAR2(50),
    APPCUSTPORT               VARCHAR2(20),
    APPCUSTPORTDESC           VARCHAR2(100),
    ORIGPORT                  VARCHAR2(16),
    ORIGPORTDESC              VARCHAR2(100),
    TARGPORT                  VARCHAR2(256),
    TARGPORTDESC              VARCHAR2(100),
    SHIPDATEFROM              DATE,
    SHIPDATETO                DATE,
    MARKDESC                  VARCHAR2(300),
    TRAFFLAGS                 NUMBER(5),
    OVERSHIPRATE              NUMBER(12, 8),
    SHORTSHIPRATE             NUMBER(12, 8),
    CCODETRUST                VARCHAR2(20),
    AGRMODE                   VARCHAR2(4),
    AGRMB                     NUMBER(19, 4),
    AGUSD                     NUMBER(19, 4),
    AGFCY                     NUMBER(19, 4),
    AGQTYCOUNT                NUMBER(16, 4),
    AGRATE                    NUMBER(19, 8),
    AGFCODE                   VARCHAR2(4),
    AGRERATE                  NUMBER(17, 8),
    AGUERATE                  NUMBER(17, 8),
    SUPPLYTYPE                VARCHAR2(8),
    RATECOMMISIONB            NUMBER(17, 8),
    AGFLAGS                   VARCHAR2(4),
    NEEDDOC                   CLOB,
    NEEDLGUARANTEE            CLOB,
    NEEDCONDITIONS            CLOB,
    LGUSED                    VARCHAR2(2),
    USEQUOTA                  VARCHAR2(2),
    NEEDDOC2                  CLOB,
    NOCUSTINUSD               NUMBER(19, 4),
    OTHERCUSTINUSD            NUMBER(19, 4),
    CONSIGNINUSD              NUMBER(19, 4),
    CUSTOMINUSD               NUMBER(19, 4),
    USD2                      NUMBER(19, 4),
    USD3                      NUMBER(19, 4),
    SHIPINUSD                 NUMBER(19, 4),
    CUSTINUSD                 NUMBER(19, 4),
    SELLUSD                   NUMBER(19, 4),
    PROFITRMB                 NUMBER(19, 4),
    SALRMB                    NUMBER(19, 4),
    SALCOSTRMB                NUMBER(19, 4),
    GOVPUR                    VARCHAR2(8),
    IMPORTTYPE                VARCHAR2(8),
    USDRERATE                 NUMBER(17, 8),
    GOODSDESC                 VARCHAR2(100),
    MANUFACTURER              VARCHAR2(100),
    AGECONTCODE               VARCHAR2(64),
    LONGCONTICODE             VARCHAR2(32),
    LONGCONTCODE              VARCHAR2(64),
    QUALITY                   VARCHAR2(16),
    PACKING                   VARCHAR2(16),
    SRICODE                   VARCHAR2(32),
    SRCODE                    VARCHAR2(64),
    MFCODEMODE                VARCHAR2(2),
    INSUREMODFCY              NUMBER(17, 8),
    INSURERATEFCY             NUMBER(17, 8),
    INSUREMOD                 NUMBER(17, 8),
    INSURERATE                NUMBER(17, 8),
    FREIGHTUSD                NUMBER(19, 4),
    FREIGHTRMB                NUMBER(19, 4),
    FREIGHTFCY                NUMBER(19, 4),
    FREIGHTUSDMUPRIC          NUMBER(19, 4),
    INSUREUSD                 NUMBER(19, 4),
    INSURERMB                 NUMBER(19, 4),
    INSUREFCY                 NUMBER(19, 4),
    NOTERMMODE                VARCHAR2(2),
    NOTERMDOC                 BLOB,
    SALFCODE                  VARCHAR2(4),
    SALRERATE                 NUMBER(17, 8),
    SALUERATE                 NUMBER(17, 8),
    SALUSD                    NUMBER(19, 4),
    SALFCY                    NUMBER(19, 4),
    FUTUREDATE                DATE,
    MATURECODE                VARCHAR2(8),
    SUCCRATE                  NUMBER(6, 4),
    PAYGOODSSETTLE            VARCHAR2(2),
    DIANZHIRMB                NUMBER(19, 4),
    DIANZHIEXPIRYDATE         DATE,
    FINALLYCCODE              VARCHAR2(20),
    FINALLYCNCODE             VARCHAR2(8),
    THEGOODSBCODE             VARCHAR2(255),
    PROJPCODE2                VARCHAR2(8),
    PROJPCODE5                VARCHAR2(8),
    DATAFROMZB                VARCHAR2(2),
    PICODE2                   VARCHAR2(32),
    PCODE2                    VARCHAR2(64),
    UNITEBIDDER               VARCHAR2(255),
    CCODECOR                  VARCHAR2(20),
    EXTENDCCODE               VARCHAR2(20),
    EXTENDCTYPE               VARCHAR2(8),
    AGMODEDESC                VARCHAR2(255),
    TXTREMARK                 CLOB,
    INSUREDATE                DATE,
    INSUREORG                 VARCHAR2(100),
    INSURERESULT              VARCHAR2(100),
    INSURERATIFIER            VARCHAR2(50),
    RISKBUYFCY                NUMBER(19, 4),
    RISKDISCOUNTRATE          NUMBER(17, 4),
    RISKBUYORG                VARCHAR2(100),
    RISKKEEPREPARFCY          NUMBER(19, 4),
    RISKREPARATRATE           NUMBER(17, 4),
    RISKKEEPORG               VARCHAR2(100),
    RISKOTHERMODE             VARCHAR2(100),
    CREDITICODE               VARCHAR2(32),
    CREDITCODE                VARCHAR2(64),
    RISKSUMRMB                NUMBER(19, 4),
    RISKTYPE                  NUMBER(5),
    CREDITRMB                 NUMBER(19, 4),
    RISKBUYRMB                NUMBER(19, 4),
    RISKKEEPREPARRMB          NUMBER(19, 4),
    RISKOTHERFCY              NUMBER(19, 4),
    RISKOTHERRMB              NUMBER(19, 4),
    ISCORPORATION             VARCHAR2(2),
    TERMMODIREMARK            CLOB,
    TRADEMODE2                VARCHAR2(8),
    POSTCODE                  VARCHAR2(32),
    ADDR                      VARCHAR2(255),
    CONTACT                   VARCHAR2(32),
    TELEPHONE                 VARCHAR2(250),
    MOBIL                     VARCHAR2(15),
    FAX                       VARCHAR2(32),
    EMAIL                     VARCHAR2(250),
    INSURANCEOWNER            VARCHAR2(16),
    PACKDESC                  VARCHAR2(255),
    SHIPDATEDESC              VARCHAR2(255),
    SPECIALCLAUSES            VARCHAR2(255),
    NCODE                     VARCHAR2(8),
    QUALITYSTANDARD           VARCHAR2(255),
    INOUTMODE                 VARCHAR2(4),
    INSURANCERATE             NUMBER(6, 2),
    INSURANCERISKS1           VARCHAR2(20),
    INSURANCERISKS2           VARCHAR2(255),
    ORIGINPLACE               VARCHAR2(255),
    BOPPCODE                  VARCHAR2(64),
    GAINRMB                   NUMBER(19, 4),
    PURCCODEFLAG              VARCHAR2(2),
    HANDCONDDESC              VARCHAR2(255),
    HANDCONDOK                VARCHAR2(2),
    HANDCONDOKDATE            DATE,
    FUNDTYPE                  VARCHAR2(50),
    CONREMARK                 VARCHAR2(255),
    ITEMREMARK                VARCHAR2(255),
    CONTCODEDESC              VARCHAR2(255),
    CCODEFLAG                 VARCHAR2(2),
    PURPAYFLAG                VARCHAR2(2),
    CCODEAPPLEVEL             VARCHAR2(4),
    QUANTUM                   NUMBER(19, 4),
    DATEQUANTUM               NUMBER(19, 4),
    BUSIAPPLEVEL              VARCHAR2(4),
    ADVICEQUANTUM             NUMBER(19, 4),
    ADVICEDATEQUANTUM         NUMBER(19, 4),
    APPRAISEDATE              DATE,
    REQQUANTUM                NUMBER(19, 4),
    REQDATETUM                NUMBER(19, 4),
    BUSISCORE                 NUMBER(19, 6),
    DLSCORE                   NUMBER(19, 6),
    DXSCORE                   NUMBER(19, 6),
    SYNTHETICALSCORE          NUMBER(19, 6),
    ORDERTYPE                 VARCHAR2(4),
    CONFIRMQUANTUM            NUMBER(19, 4),
    CONFIRMDATEQUANTUM        NUMBER(19, 4),
    CONFIRMBY                 VARCHAR2(255),
    CONFIRMWCODE              VARCHAR2(16),
    CONFIRMDATE               DATE,
    ISCONFIRM                 VARCHAR2(2),
    FUNDSOURCE                VARCHAR2(16),
    OTTCODE                   VARCHAR2(255),
    BCSLIST                   NUMBER(5),
    MRPFLAGS                  NUMBER(5),
    AGETOZYFLAGS              NUMBER(5),
    OTTICODE                  VARCHAR2(32),
    SETTLEBUSIMODE            VARCHAR2(4),
    CHARGETYPE                VARCHAR2(4),
    AGTAXFLAGS                NUMBER(5),
    STDECLARE                 NUMBER(5),
    MCOPYFLAGS                NUMBER(5),
    ORIGINTYPE                VARCHAR2(2),
    STOCKUPMODE               VARCHAR2(2),
    PLUSRATE                  NUMBER(19, 12),
    PRODUCTPURTYPE            VARCHAR2(4),
    PLANID                    VARCHAR2(64),
    PLANOUTERID               VARCHAR2(64),
    MRPGENFLAGS               NUMBER(5),
    ADDTAXMODE                VARCHAR2(2),
    BCREDIT                   VARCHAR2(2),
    VERSIONID                 VARCHAR2(32),
    INVICODECC                VARCHAR2(32),
    INTERESTRMB               NUMBER(19, 4),
    INTERESTRATE              NUMBER(19, 8),
    INTBLCRMB                 NUMBER(19, 4),
    INURECONDITION            VARCHAR2(255),
    FINISREASON               VARCHAR2(255),
    INTBLCUSD                 NUMBER(19, 4),
    INTBLCFCY                 NUMBER(19, 4),
    GROUPSFTMRPICODE          VARCHAR2(250),
    GROUPSFTMRPCODE           VARCHAR2(250),
    MRPBCODE                  VARCHAR2(32),
    SERVICESTYPE              VARCHAR2(8),
    AGCALCRMB                 NUMBER(19, 4),
    AGMODE                    VARCHAR2(250),
    PACKINGKIND               VARCHAR2(255),
    PAYCONDITION              VARCHAR2(255),
    SHEETCODEREQUIRE          VARCHAR2(255),
    CONRACTTYPE               VARCHAR2(4),
    PAYDESC                   CLOB,
    SHEETTYPE                 VARCHAR2(4),
    RMBPERUSD                 NUMBER(19, 4),
    FINISHDATE                DATE,
    ISLCODE                   VARCHAR2(32),
    SLCODE                    VARCHAR2(64),
    MATOUTDATE                DATE,
    SALORDCODE1               VARCHAR2(64),
    INBUSIPROP                VARCHAR2(4),
    PURAUTOGENFLAGS           NUMBER(5),
    SUBMITDATE10              DATE,
    JXMODE                    VARCHAR2(10),
    CKRATE                    NUMBER(6, 4),
    DKRATE                    NUMBER(6, 4),
    JXQSDATE                  DATE,
    JXZJDATE                  DATE,
    SHARERATE                 NUMBER(19, 12),
    DELAYREASON               CLOB,
    BORDCODE                  VARCHAR2(4),
    BIDDOCUMENTVER            VARCHAR2(4),
    ACKNOWLEDGEMENT           VARCHAR2(4),
    WRONGMISS                 VARCHAR2(4),
    BCONSISTENCY              VARCHAR2(4),
    BLANGUAGE                 VARCHAR2(4),
    BVERSION                  VARCHAR2(4),
    BREVIEW                   VARCHAR2(4),
    CONTRACTRISK              VARCHAR2(4),
    ASSISTANT                 VARCHAR2(4),
    REMARK1                   CLOB,
    AGRNATURE                 VARCHAR2(4),
    AFFIXTYPE                 VARCHAR2(4),
    AFFIX                     VARCHAR2(1000),
    UPTIME                    DATE,
    BNEEDRECORD               VARCHAR2(4),
    APPROVALREA               VARCHAR2(255),
    APPROVALDATE              DATE,
    MARKEDFLAG                VARCHAR2(4),
    SUBNAME                   VARCHAR2(100),
    TEMPLATETYPE              VARCHAR2(4),
    TEMPLATE                  VARCHAR2(1000),
    TENDERSOUR                VARCHAR2(4),
    BIDDINGICODE              VARCHAR2(32),
    BIDDINGCODE               VARCHAR2(64),
    BIDPACKAGEICODE           VARCHAR2(32),
    BIDPACKAGECODE            VARCHAR2(64),
    TENDERCCODE               VARCHAR2(20),
    BIDDATE                   DATE,
    BIDFCODE                  VARCHAR2(4),
    BIDFCY                    NUMBER(19, 4),
    TENDERTYPE                VARCHAR2(4),
    TENDER                    VARCHAR2(1000),
    TENDERSIDE                VARCHAR2(20),
    TEMPLATEUPTIME            DATE,
    TENDERUPTIME              DATE,
    LATERGOODDATE             DATE,
    BIDINFORMICODE            VARCHAR2(32),
    BIDINFORMCODE             VARCHAR2(64),
    CONTRACTNAME              VARCHAR2(255),
    DELIVERYDESC              VARCHAR2(2000),
    WARRANTYDESC              VARCHAR2(2000),
    PAYMENTDESC               VARCHAR2(2000),
    DUTYOFFICER               VARCHAR2(16),
    SEGMENT                   VARCHAR2(4),
    TESTID                    VARCHAR2(32),
    TESTQUESTIONICODE         VARCHAR2(32),
    TESTTASKTYPE              VARCHAR2(4),
    TEACHERSTUDENTTYPE        VARCHAR2(4),
    TESTNUMBER                VARCHAR2(32),
    CURTEACHERBCODE           VARCHAR2(32),
    XD_OUTORDCODE             VARCHAR2(128),
    XD_CNAME                  VARCHAR2(200),
    XD_LATEBILLDATE           DATE,
    XD_LATEARRIDATE           DATE,
    XD_LATEPAYDATE            DATE,
    XD_YNTAILSETTLE           VARCHAR2(8),
    XD_TAILSETTLEDATE         DATE,
    XD_SETTLETERM             VARCHAR2(2000),
    XD_YNUSESX                VARCHAR2(8),
    XD_YNAMOUNTPRE            VARCHAR2(32),
    XD_PRICTYPE               VARCHAR2(32),
    XD_POIPRICONTICODE        VARCHAR2(32),
    XD_POIPRICONTCODE         VARCHAR2(64),
    XD_INDEXDATE              VARCHAR2(6),
    XD_ARRIVALDATE            DATE,
    XD_MYCOMPFLAG             VARCHAR2(8),
    XD_PLEDGESCALE            NUMBER(17, 4),
    XD_PLEDGEFCY              NUMBER(19, 4),
    XD_YNMYCOMPFREINS         VARCHAR2(8),
    XD_PIRSALTYPE             VARCHAR2(32),
    XD_STOCKTYPE              VARCHAR2(32),
    XD_YNSMALLPROJECT         VARCHAR2(8),
    XD_YNLONGORDERBUSI        VARCHAR2(8),
    XD_LSSDEPFCY              NUMBER(19, 4),
    XD_LSSDEPDATE             DATE,
    XD_LSSDEPYNMYCOMPPAY      VARCHAR2(8),
    XD_PERDEPFCY              NUMBER(19, 4),
    XD_PERDEPDATE             DATE,
    XD_PERDEPYNMYCOMPPAY      VARCHAR2(8),
    XD_AGREEMENTICODE         VARCHAR2(32),
    XD_AGREEMENTCODE          VARCHAR2(64),
    XD_COMMCCODE              VARCHAR2(32),
    XD_COMMNAME               VARCHAR2(200),
    XD_YNLITIGATION           VARCHAR2(8),
    XD_LITIGATION             DATE,
    XD_LITIGATIONVPREPARE     VARCHAR2(20),
    XD_LITIGATIONPREDATE      DATE,
    XD_LITIGATIONREMARK       VARCHAR2(1000),
    XD_TRADEFORM              VARCHAR2(20),
    XD_LATEDELIVERYDATE       DATE,
    XD_LATEOPAYDATE           DATE,
    XD_SXICODE                VARCHAR2(32),
    XD_SXCODE                 VARCHAR2(64),
    XD_OUTSALORDCODE          VARCHAR2(64),
    XD_YNAMOUNTCRE            VARCHAR2(32),
    XD_PAYTERM                VARCHAR2(2000),
    XD_MODIFYTYPE             VARCHAR2(8),
    XD_CLOSESTATUS            VARCHAR2(12),
    XD_CLOSEDATE              DATE,
    XD_DEFAULTDATE            DATE,
    XD_FUNDINTANNRATE         NUMBER(17, 8),
    XD_DISCINTANNRATE         NUMBER(17, 8),
    XD_FALLPRIFCY             NUMBER(19, 4),
    XD_FALLPRIREMARK          VARCHAR2(255),
    XD_FALLPRIYNMYCOMPPAY     VARCHAR2(8),
    REQUESTITEMICODE          VARCHAR2(32),
    REQUESTITEMCODE           VARCHAR2(64),
    KEPTBCODE                 VARCHAR2(64),
    XD_LSSDEPRATE             NUMBER(17, 4),
    XD_PERDEPRATE             NUMBER(17, 4),
    XD_FALLPRIRATE            NUMBER(17, 4),
    XD_SELFTRADE              VARCHAR2(8),
    XD_SELFTRADECODE          VARCHAR2(64),
    XD_TRADETYPE              VARCHAR2(64),
    XD_PURTYPE                VARCHAR2(4),
    XD_SLADDR                 VARCHAR2(200),
    GCODE                     VARCHAR2(26),
    XD_FAXFLAG                VARCHAR2(12),
    XD_FAXDATE                DATE,
    XD_ORIGINALFLAG           VARCHAR2(12),
    XD_ORIGINALDATE           DATE,
    PGCODE                    VARCHAR2(26),
    XD_ORIGINALREMARK         VARCHAR2(1024),
    CQUOTANO                  VARCHAR2(64),
    CQUOTACODE                VARCHAR2(64),
    CQUOTAICODE               VARCHAR2(64),
    CCODEQUOTA                VARCHAR2(12),
    XD_CONTRACT_TYPE          VARCHAR2(10),
    XD_IS_PAPER_APPROVAL      VARCHAR2(10),
    XD_IS_URGENT              VARCHAR2(10),
    PICODEX                   VARCHAR2(32),
    XD_BUSINESS_TYPE          VARCHAR2(20),
    XD_IS_OWN                 VARCHAR2(4),
    XD_INITFLAG               NUMBER(5),
    XD_APPROVAL               VARCHAR2(10),
    SCODE                     VARCHAR2(64),
    XD_IS_RN                  VARCHAR2(10),
    XD_ORIGPORT               VARCHAR2(256),
    XD_TARGPORT               VARCHAR2(256),
    XD_ARBICOUN               VARCHAR2(12),
    PQCTDATE                  DATE,
    AGREEMENTTYPE             VARCHAR2(4),
    AGREEMENTCLASS            VARCHAR2(4),
    XD_ISDAYOCUR              VARCHAR2(10),
    XD_LJHTJE                 VARCHAR2(24),
    APPROVAL_LENGTH           VARCHAR2(24),
    XD_INDEXM                 VARCHAR2(6),
    XD_ISPROCESS              VARCHAR2(2),
    XD_ISFKJLSP               VARCHAR2(4),
    XD_ISPASSNODE             VARCHAR2(130),
    XD_PRTYPE                 VARCHAR2(20),
    XD_PASS                   VARCHAR2(4),
    XD_COMPINFO               VARCHAR2(100),
    ATP_ID                    VARCHAR2(32),
    ATP_CONTRACT_CODE         VARCHAR2(32),
    XD_CQUOTANOTE             VARCHAR2(64),
    XD_TOTAMOUNT              NUMBER(19, 4),
    XD_PASSBCODE              VARCHAR2(16),
    XD_PASSDATE               DATE,
    XD_ZYHX                   VARCHAR2(2),
    XD_ZYHXBCODE              VARCHAR2(16),
    XD_ZYHXDATE               DATE,
    XD_TJBHX                  VARCHAR2(2),
    XD_TJBHXBCODE             VARCHAR2(16),
    XD_TJBHXDATE              DATE,
    XD_OPEN                   DATE,
    XD_OPEOPLE                VARCHAR2(24),
    XD_CLOSE                  DATE,
    XD_CPEOPLE                VARCHAR2(24),
    XD_OPENMASK               VARCHAR2(1000),
    XD_CQUOTACODE             VARCHAR2(100),
    XD_CQUOTAICODE            VARCHAR2(100),
    XD_FILEFLAG               VARCHAR2(12),
    XD_FILEDATE               DATE,
    XD_ISWHITE                VARCHAR2(100),
    XD_TOBEFILED              VARCHAR2(12),
    XD_TOBEFILEDDATE          DATE,
    XD_ENDFILEDDATE           DATE,
    XD_RISKFILED              VARCHAR2(12),
    XD_RISKFILEDDATE          DATE,
    XD_RISK                   VARCHAR2(12),
    XD_TRANSFER               VARCHAR2(12),
    XD_TRANSFERDATE           DATE,
    XD_ENDTRANSFER            VARCHAR2(12),
    XD_ENDTRANSFERDATE        DATE,
    XD_AGREEMENT              VARCHAR2(8),
    XD_PTYPE                  VARCHAR2(2),
    XD_LOGISTICSCODE          VARCHAR2(64),
    XD_LOGISTICSIICODE        VARCHAR2(64),
    LOGISTICSICODE            VARCHAR2(64),
    LOGISTICSCODE             VARCHAR2(64),
    XD_ISBUSINESS             VARCHAR2(4),
    XD_CCODE_GROUP_MONEY      NUMBER(19, 2),
    COOPTYPE                  VARCHAR2(4),
    COOPBUSI                  VARCHAR2(4),
    DC                        NUMBER(5),
    COOPSTATUS                VARCHAR2(4),
    COOPFLAG                  NUMBER(5),
    COOPRATE                  NUMBER(19, 6),
    XD_QTYSTDTYPE             VARCHAR2(20),
    XD_QUALITYSTDTYPE         VARCHAR2(20),
    XD_ISNEEDPLAN             VARCHAR2(4),
    XD_CONTRACT_TYPE_ZT       VARCHAR2(10),
    XD_HANDERR                NUMBER(5),
    XD_CONTRACT_TYPE_YC       VARCHAR2(10),
    IS_TOPAYREQUEST           VARCHAR2(50),
    INNERCCODE                VARCHAR2(32),
    INNERNO                   VARCHAR2(32),
    XD_IS_TRANSIT             VARCHAR2(4),
    XD_CLPAYDATE              DATE,
    ARCPERSON                 VARCHAR2(20),
    XD_FWHTID                 VARCHAR2(60),
    XD_BORROWSTATUS           VARCHAR2(10),
    XD_BORROWSTATUS_DATE      DATE,
    XD_SIGNSTATUS             VARCHAR2(4),
    XD_SIGNDATE               DATE,
    XD_FW_PREAPPROVALOPINIONS VARCHAR2(2000),
    XD_USESEAL_COUNT          NUMBER(10)
)
/

create index PURORDER_BCODE
    on PURORDER (BCODE)
/

create index PURORDER_BJCODE
    on PURORDER (BCODE, JCODE)
/

create index PURORDER_CONFIRMQUANTUM
    on PURORDER (CONFIRMQUANTUM)
/

create index PURORDER_FINANCEFINIS
    on PURORDER (FINANCEFINIS)
/

create index PURORDER_JCODE
    on PURORDER (JCODE)
/

create index PURORDER_PICODE
    on PURORDER (PICODE)
/

create index PURORDER_PREDATE
    on PURORDER (PREDATE)
/

create index PURORDER_SHEETCODE
    on PURORDER (SHEETCODE)
/

create index PURORDER_STATUS
    on PURORDER (STATUS)
/


catalog语句

CREATE CATALOG `jdbc_oracle_pro` PROPERTIES ( "user" = "user", "type" = "jdbc", "password" = "*XXX", "jdbc_url" = "jdbc:oracle:thin:@12.16.18.3:1521:orcl", "driver_url" = "ojdbc8.jar", "driver_class" = "oracle.jdbc.driver.OracleDriver", "create_time" = "2024-03-04 15:00:41.434", "connection_pool_max_size" = "1000", "checksum" = "ebb69c8de3a83c08846b3fd47836ff15" );