定义Oracle数据源过程使用ServiceName连接方式导致找不到表

[baisui1981]

定义Oracle数据源之后（使用ServiceName连接方式），导致后续流程中会出现 找不到对应的表

Caused by: java.lang.RuntimeException: java.lang.RuntimeException: com.qlangtech.tis.plugin.datax.SelectedTab.getColsCandidate()
	at com.qlangtech.tis.trigger.util.JsonUtil$UnCacheString.getValue(JsonUtil.java:116)
	at com.qlangtech.tis.trigger.util.JsonUtil$1.write(JsonUtil.java:94)
	... 121 more
Caused by: java.lang.RuntimeException: com.qlangtech.tis.plugin.datax.SelectedTab.getColsCandidate()
	at com.qlangtech.tis.extension.util.GroovyShellEvaluate.eval(GroovyShellEvaluate.java:170)
	at com.qlangtech.tis.extension.util.GroovyShellEvaluate.lambda$scriptEval$0(GroovyShellEvaluate.java:130)
	at com.qlangtech.tis.trigger.util.JsonUtil$UnCacheString.getValue(JsonUtil.java:114)
	... 122 more
Caused by: java.lang.RuntimeException: TableNotFoundException{tableName='LOGMINER_TBS.STUDENT_INFO'}
	at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.getTableMetadata(BasicDataSourceFactory.java:120)
	at com.qlangtech.tis.plugin.datax.common.BasicDataXRdbmsReader.getTableMetadata(BasicDataXRdbmsReader.java:282)
	at com.qlangtech.tis.plugin.datax.SelectedTab.lambda$getContextTableCols$2(SelectedTab.java:198)
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
	at com.qlangtech.tis.extension.impl.SuFormProperties$SuFormGetterContext.getContextAttr(SuFormProperties.java:261)
	at com.qlangtech.tis.plugin.datax.SelectedTab.getContextTableCols(SelectedTab.java:196)
	at com.qlangtech.tis.plugin.datax.SelectedTab.getColsCandidate(SelectedTab.java:109)
	at com.qlangtech.tis.plugin.datax.SelectedTab$getColsCandidate.call(Unknown Source)
	at Script7.run(Script7.groovy:1)
	at com.qlangtech.tis.extension.util.GroovyShellEvaluate.eval(GroovyShellEvaluate.java:168)
	... 124 more
Caused by: TableNotFoundException{tableName='LOGMINER_TBS.STUDENT_INFO'}
	at com.qlangtech.tis.plugin.ds.DataSourceFactory.parseTableColMeta(DataSourceFactory.java:162)
	at com.qlangtech.tis.plugin.ds.DataSourceFactory.lambda$parseTableColMeta$0(DataSourceFactory.java:236)
	at com.qlangtech.tis.plugin.ds.DataSourceFactory.validateConnection(DataSourceFactory.java:94)
	at com.qlangtech.tis.plugin.ds.DataSourceFactory.parseTableColMeta(DataSourceFactory.java:235)
	at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.parseTableColMeta(BasicDataSourceFactory.java:140)
	at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.lambda$getTableMetadata$1(BasicDataSourceFactory.java:110)
	at com.qlangtech.tis.plugin.ds.DBConfig.vistDbName(DBConfig.java:127)
	at com.qlangtech.tis.plugin.ds.BasicDataSourceFactory.getTableMetadata(BasicDataSourceFactory.java:109)
	... 133 more

[baisui1981]

原因是 oracle的 tablespace_name 不能作为 db来用

SELECT tablespace_name ||'.'||  (TABLE_NAME) FROM user_tables WHERE REGEXP_INSTR(TABLE_NAME,'[\\.$]+') < 1 AND tablespace_name is not null
---改成如下即可
SELECT  (TABLE_NAME) FROM user_tables WHERE REGEXP_INSTR(TABLE_NAME,'[\.$]+') < 1 AND tablespace_name is not null