Re: Upgrading an old database

John Lussmyer <[email protected]> Thu, 8 Aug 2019 07:47:28 -0700 (PDT)
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <1331980133.71.1565275648622.JavaMail.John@BigCat>
On Thu Aug 08 06:51:06 PDT 2019 [email protected] said:
>Hello JohnWithout seeing the entire .script file, it's difficult to say for certain why access to the STUFF object throws exception.  Is "STUFF" a real name or simply a placeholder?  Regardless, you might try further qualifying the name, e.g. PUBLIC.STUFF, to see if it helps.  Also, can you access the object in SQLTool when using SA account? These steps may give clues as to the root cause.I cannot comment on your other questions.Good luck,Andrew Richardson 

In this case "STUFF" is just another table, created the same way as the one in the snippet I gave: (about 20 tables later in the script)
CREATE MEMORY TABLE STUFF(...

I'll experiment with SQLTool to see what I can find.


--

Worlds only All Electric F-250 truck! http://john.casadelgato.com/Electric-Vehicles/1995-Ford-F-250

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user