Re: Upgrading an old database
John Lussmyer <[email protected]> Thu, 8 Aug 2019 11:16:02 -0700 (PDT)
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <2054949455.73.1565288162651.JavaMail.John@BigCat> |
On Thu Aug 08 09:49:10 PDT 2019 [email protected] said: >John Lussmyer wrote: >> I'm working on upgrading our desktop application from HSQLDB 1.8 to >> 2.5. >> That's a BIG jump. >> . >> . >> java.sql.SQLSyntaxErrorException: user lacks privilege or object not >> found: STUFF And I just found the bug. In our test code. It wasn't providing a .properties file, so hsqldb created a version 2.5 one for the 1.8 database. This does NOT work properly! Once I provided a proper version 1.8 .properties file, the database is automatically upgraded correctly without error. -- Bobcats and Cougars, oh my! http://john.casadelgato.com/Pets _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user