I’m creating a new topic, because issues from the last one were resolved and I was able to import a csv file sucessfully. I am very grateful for assistance and I was able to learn how to use Base for importing files. However, I ran into another issue when trying to import second file.
For completeness sake, I’m linking my previous topic: Base: Importing data from a csv file
Continuing from there, I’ve created a new database, selected a text source and linked it to a folder with one csv file with 1 065 552 data rows and one row containing headers. It created a linked database with that table sucessfully and I wanted to copy its data into my embedded HPSQL database. I opened both Base files, opened the table with data to be appended, selected them all, copied them and clicked paste in the context menu of the destination table. I linked the columns together in the Copy wizard and when I confirmed the operation, the Base got busy for a while (cursor changed to the one indicating activity) and following error appeared:
SQL state: S1000
Error code: 40
S1000 General error java.lang.NullPointerException in statement [INSERT INTO “Jumps” ( “OriginSystem”,“DestinationSystem”,“JumpType”,“Cost”) VALUES ( ?,?,?,?)]
What can that mean?