Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
ibbenz opened this issue Sep 28, 2022 · 0 comments
Open

Comments

@ibbenz
Copy link

ibbenz commented Sep 28, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: No status
Development

No branches or pull requests

1 participant