Hello,
I am a bit confused about schemas and cache names. In some cases they seem
synonymous, on others the appear different.
So far I have defined everything in XML configuration. To execute a query, I
get the cache [getOrCreateCache()], and then execute the query statement. When
the statement joins to another table, I prefix the cache name to the other
table. So far, so good.
Now, I want to create a table using SQL. From the doc I understand that I need
to set the schema in the query [setSchema("PUBLIC")].
Q1: Can I do this on any cache (opened)?
Q2: Is there any other use for [setSchema("PUBLIC")]?
For example, when I have the PersonCache open, can I set the schema to
OrganizationCache, so that I can query the Organization table without prefixing
the cache name?
If Q2 is yes, then Schema and CacheName seem to be synonymous for configuration
created tables.
But they are not for SQL created tables (per doc the cache name will be
SQL_{SCHEMA_NAME}_{TABLE}.
Q3: Then, is there also a "PUBLIC" cache? If yes, can I get that cache
[getOrCreateCache("PUBLIC")]?
If Q3 is no, then (presumably) I need at least one cache before I can create a
table using SQL.
Q4: In cross-cache queries, I always use CacheName as the prefix, correct?
This is really where the confusion comes from, because typically it would be a
schema that is prefixed to the table.
Thanks...
Roger
