[bugfix][plugin][rdbms] 1.DataBaseType should not be call set method，so that the driver is error when rdbmsreader to rdbmswriter 2.hive jdbc don't support method(Timestamp getTimestamp(int columnIndex, Calendar cal)) 3.DataBaseType add vertica driver #1188
Conversation
1.DataBaseType should not be call set method，so that the driver is error when rdbmsreader to rdbmswriter 2.hive jdbc don't support method(Timestamp getTimestamp(int columnIndex, Calendar cal)) 3.DataBaseType add vertica driver
| @@ -50,7 +50,15 @@ public enum DataBaseType | |||
| Sybase("sybase", "com.sybase.jdbc4.jdbc.SybDriver"), | |||
| Databend("databend", "com.databend.jdbc.DatabendDriver"), | |||
| Access("access","net.ucanaccess.jdbc.UcanaccessDriver"), | |||
There was a problem hiding this comment.
We cannot list all the database JDBC driver classes in this class. For drivers not specified in this class, you can resolve this by specifying the driver configuration item in the job configuration file. For more details, please refer to https://wgzhao.github.io/Addax/latest/reader/rdbmsreader/
There was a problem hiding this comment.
Because the setDriverClass method of the DataBaseType enum class can cause errors from rdbmsreader to rdbmswriter, I have to add drivers for as many database types as possible.
| @@ -272,7 +272,12 @@ protected Column createColumn(ResultSet rs, ResultSetMetaData metaData, int i) | |||
| return new DateColumn(rs.getDate(i)); | |||
|
|
|||
| case Types.TIMESTAMP: | |||
| return new TimestampColumn(rs.getTimestamp(i, Calendar.getInstance())); | |||
| if(!"org.apache.hive.jdbc.HiveDriver".equals(this.dataBaseType.getDriverClassName())){ | |||
There was a problem hiding this comment.
In the hivereader plugin, you can achieve specific handling for reading the Timestamp type by overriding the createColumn method. You can refer to the implementation in the following link for guidance:https://github.com/wgzhao/Addax/blob/master/plugin/reader/postgresqlreader/src/main/java/com/wgzhao/addax/plugin/reader/postgresqlreader/PostgresqlReader.java
There was a problem hiding this comment.
Because it needs to be encapsulated into a unified script, hivereader will not be used, but rdbmsreader will be used instead
[bugfix][plugin][rdbms]
1.DataBaseType should not be call set method，so that the driver is error when rdbmsreader to rdbmswriter
2.hive jdbc don't support method(Timestamp getTimestamp(int columnIndex, Calendar cal))
3.DataBaseType add vertica driver