We updated JDBC version 4.0 to current version.
Our target is to get Excel files updated before our program ends.
I found in your FAQs that including xls file name in the connection URL, the file is updated when closing the connection.
It could solve some or the process cases, when the file name is known at configuration time.
As we also process unknown Excel files, we can't include their names in URL and need to execute the FLUSH DATABASE database_name instruction.
When executing this instructions we get both in our program and in Squirrel an error:
Error: Failed to flush database recepcionMateriales.xlsx.
What is the reason for the message?
I would appreciate some guidance about using FLUSH DATABASE also.
Thank you in advance
Invalid catalog name
>As we also process unknown Excel files, we can't include their names in URL and need to execute the FLUSH DATABASE database_name instruction.
Yeah. What's your JDBC url and FLUSH sql?
In my Squirrel example URL is: "jdbc:excel:///C:/ETL/Entrada/"
and the SQL statement is: "flush database recepcionmateriales"
FYI, before running FLUSH I executed successfully the following statement:
"select * from recepcionmateriales.detalle"
java.sql.SQLException: Failed to flush database test.xls.
Failed to flush database test.xls.
You should add delayedClose=0 connection property.