Problem:
Recently in making use of Geotools to import SHP files into an Oracle table, a problem was found when an Oracle table name was underlined when the import failed, the question code line: Dsoracle.getfeaturewriterappend (oracletable, Transaction.auto_commit); Dsoracle for Org.geotools.data.DataStore type Object
Solution:
Online access to Data discovery is ORACLE11 Java package OJDBC version of the problem, maven search Ojdbc found the latest version as
POM Configuration:
<!--HTTPS://MVNREPOSITORY.COM/ARTIFACT/OJDBC/OJDBC--
<dependency>
<groupId>ojdbc</groupId>
<artifactId>ojdbc</artifactId>
<version>14</version>
</dependency>
However, thelatest version of ORACLE11G's ojdbc should be OJDBC6
POM Configuration:
<!--HTTPS://MVNREPOSITORY.COM/ARTIFACT/CN.GUOYUKUN.JDBC/ORACLE-OJDBC6--
<dependency>
<groupId>cn.guoyukun.jdbc</groupId>
<artifactId>oracle-ojdbc6</artifactId>
<version>11.2.0.3.0</version>
</dependency>
So I'm going to update the OJDBC jar package to the Oracle-ojdbc6-11.2.0.3.0.jar version, OK.
Geotools The table name is underlined when importing SHP files to an Oracle database