HSQLDB

Hi, here I will put any information relating to HSQLDB.

Error: java.sql.SQLException: The table's data source for has not been defined in statement Error Code -48
Generally, the HSQLDB is telling you the truth. This issue can come about when there is no file associated with the table you are trying to write to. If you are using a TEXT table, you might need to remember to execute the following SQL (or otherwise define the data source when getting this error), try the following:

Syntax:
SET TABLE <table name> SOURCE "<location of file>;fs=<Delimiter>"

Example:
SET TABLE Countries SOURCE "C:\home\hsqldb\countries\countriesDATA;fs=|"

Also, it would be advised to read up on hsqldb user guide, especially chapter 6 of the doco.

Comments