dbptk-developer
dbptk-developer copied to clipboard
SIARD-->postgreSQL: in case of xs:date following error occurs: RESTException: Remote exception caused by GenericExeption: caused by IlegalArgument Exception
Description:
RESTException: Remote exception caused by GenericExeption: caused by IlegalArgument Exception The error is caused by a column containing DATE-datatype values (Table 6 (Employees) in the attached SIARD-file). No such error occurs, when I convert SIARD-->Microsoft SQL, for example.
Steps required to reproduce the bug:
- Open the 0_1-3_Northwind_simple_220913_B_dbptk2b.siard into dbptk (see attached zip)
- "Send To Live DBMS" and choose postgresql.
- Check "Disable Encription". The "test connection" is successful
- Click the "Export" Button. The error message occurs.
- Check the Tables in the postgresql-db, The values of the Tables which were processed before the "Employees"-table exist. The values of the "Employees" table and the other tables do not exist.
Table 6 (Employees) contains the xs: date in Table 6 the last column is the DATE-datatype column
SIARD-file, where the DATE-datatype column in Table 6 is deleted: 0_1-3_Northwind_simple_220913_B_dbptk2a.zip
SIARD with the DATE-column, where the bug occurs. 0_1-3_Northwind_simple_220913_B_dbptk2b.zip
Attach the dbptk-app.log.txt file below. dbvtk.log