dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

SIARD --> postgreSQL or MySQL: NumberFormatException for TIME-Datatype

Open ibbenz opened this issue 2 years ago • 0 comments

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:

  1. Open the 0_1-3_Northwind_simple_220913_B_dbptk3.siard into dbptk
  2. Send it to a MySQL or postgreSQL database
  3. 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

ibbenz avatar Sep 28 '22 12:09 ibbenz