fix the issue. precision was ignored because getObject returns Time object, which is converted to String later on and precision is removed.
@@ -112,8 +112,13 @@ class TVP {
Object[] rowData = new Object[colCount];
for (int i = 0; i < colCount; i++) {
try {
+ if (java.sql.Types.TIME == sourceResultSet.getMetaData().getColumnType(i + 1)) {
+ rowData[i] = sourceResultSet.getTimestamp(i + 1);
+ }
+ else {
rowData[i] = sourceResultSet.getObject(i + 1);
}
+ }
catch (SQLException e) {
throw new SQLServerException(SQLServerException.getErrString("R_unableRetrieveSourceData"), e);
}
