Hello, Actually the table was created by quoting all identifiers. I have to test such cases in the MyJSQLView application because I never know how someone will define a table.
In testing CachedRowSets for the various databases that support them, MySQL, PostgreSQL, etc. the same testing passed without the error. Now I have produced a self-contained test case that can be found at the location identified below. By using no quotes H2 does work properly. Quoting will give the error described when the identifiers are not all uppercase I suspect. This is of no consequence since after testing I decided CachedRowSets are not the way to go for creating data sets for recurring analysis. Test Case: http://dandymadeproductions.com/temp/H2_CachedRowSet.java Dana M. Proctor MyJSQLView Project Manager -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
