Re: Where do I find help on HSQLDB
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Tony, > So having ported my data from MySQL to OOo Base, I now need to get my macros > working. There are apparently some differences here, since what used to work > with MySQL/ODBC now fails. > > Specifically, I an getting 'table not found in statement' when trying to > retrieve, though the table name is definitely correct. I have tried various > permutations without success. > > Is there some place where differences are documented? Not that I know. One known problem is that HSQLDB is more nitpicking about case: If your SQL statements contain table/column names, you should quote them, else the HSQLDB query engine internally translates them to UPPER CASE, and then doesn't find them, because your real table/column names are probably MixedCase. There's an issue for this, but I don't have the number at hand. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -