Hi,
> Actually the table was created by quoting all identifiers
Yes. In fact, all column and table names are quoted in *all* statements,
except in the statement that fails. Why don't you quote the column names
there as well? Or don't quote the column names everywhere?
DROP TABLE IF EXISTS "key_table5"
CREATE TABLE "key_table5" ("name" VARCHAR(30) DEFAULT '' NOT NULL, "color"
VARCHAR(10) NOT NULL, "price" DOUBLE DEFAULT NULL, PRIMARY KEY ("color"));
INSERT INTO "key_table5" ("name", "color", "price") VALUES ('bike', 'blue',
100.0)
Select Query: SELECT "name", "color", "price" FROM "key_table5"
org.h2.jdbc.JdbcSQLException: Column "NAME" not found; SQL statement:
INSERT INTO TEST.PUBLIC."key_table5" (name, color, price) VALUES (?, ?, ?)
[42122-176]
Regards,
Thomas
On Wed, Apr 2, 2014 at 11:03 PM, <[email protected]> wrote:
> 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.
>
--
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.
