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
【问题状态】已处理
【问题处理】be conf 的 JAVA_OPTS 增加 -Doracle.jdbc.fanEnabled=false
或者升级driver到
https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc8/19.23.0.0/ojdbc8-19.23.0.0.jar
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" );