Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle table column NUMBER(11,0) mapper to MySQL error #166

Closed
baisui1981 opened this issue Nov 25, 2022 · 1 comment
Closed

Oracle table column NUMBER(11,0) mapper to MySQL error #166

baisui1981 opened this issue Nov 25, 2022 · 1 comment
Labels
3.6.0-alpha bug Something isn't working

Comments

@baisui1981
Copy link
Member

Create Oracle and sink to MySQL table has an Error

  CREATE TABLE "AA" 
   (	"ID" VARCHAR2(36) NOT NULL ENABLE, 
	"PX" NUMBER(11,0), 
	 CONSTRAINT "PK_T_ZSTP_ORGAN" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   )
java.lang.IllegalStateException: col:PX{type=-5,typeName=, columnSize=-1, decimalDigits=null} colsize can not small than 1
	at com.qlangtech.tis.plugin.datax.DataxMySQLWriter$2.convertType(DataxMySQLWriter.java:215)
	at com.qlangtech.tis.plugin.datax.DataxMySQLWriter$2.access$600(DataxMySQLWriter.java:142)
	at com.qlangtech.tis.plugin.datax.DataxMySQLWriter$2$1.getMapperType(DataxMySQLWriter.java:161)
	at com.qlangtech.tis.plugin.datax.CreateTableSqlBuilder.build(CreateTableSqlBuilder.java:89)
	at com.qlangtech.tis.plugin.datax.DataxMySQLWriter.generateCreateDDL(DataxMySQLWriter.java:260)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator.generateTabCreateDDL(DataXCfgGenerator.java:307)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator.generateDataXAndSQLDDLFile(DataXCfgGenerator.java:280)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator.access$300(DataXCfgGenerator.java:52)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator$1.generateScriptFile(DataXCfgGenerator.java:150)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator.startGenerateCfg(DataXCfgGenerator.java:242)
	at com.qlangtech.tis.datax.impl.DataXCfgGenerator.startGenerateCfg(DataXCfgGenerator.java:145)
	at com.qlangtech.tis.coredefine.module.action.DataxAction.doGenerateDataxCfgs(DataxAction.java:550)
	at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.qlangtech.tis.runtime.module.action.BasicModule.execute(BasicModule.java:115)
	at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
@baisui1981 baisui1981 added bug Something isn't working 3.6.0-alpha labels Nov 25, 2022
@baisui1981
Copy link
Member Author

已经修复了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
3.6.0-alpha bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant