dbptk-developer
dbptk-developer copied to clipboard
SIARD --> postgreSQL or MySQL: NumberFormatException for TIME-Datatype
Description: Table 6 (Employees) of the SIARD-file 0_1-3_Northwind_simple_220913_B_dbptk3.siard contains a column of the datatype TIME. Uploading this column leads to the error: RESTException: Remote exception caused by GenericException: For input string: "00.000000" caused by NumberFormatException: For input string: "00.000000" The error does not occur when the datatype TIME is replaced with CHARACTER VARYING and xs:string the metadata.xml and table6.xsd. However, this is not really a workaround, since the original datatype is lost by this.
Steps required to reproduce the bug:
- Open the 0_1-3_Northwind_simple_220913_B_dbptk3.siard into dbptk
- Send it to a MySQL or postgreSQL database
- The above mentioned error occurs.
Attach the dbptk-app.log.txt file below: dbvtk.log
The SIARD file with TIME datatype in table 6 ("Employees" table): 0_1-3_Northwind_simple_220913_B_dbptk3.zip
The SIARD file where TIME was replaced with CHARACTER VARYING: 0_1-3_Northwind_simple_220913_B_dbptk3a.zip