openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dinkar Rao <dinkar.d91411...@gmail.com>
Subject Colon used for table's scheme qualification in Informix
Date Thu, 01 May 2008 21:47:42 GMT

Hi Folks, 

In the Informix dictionary, there's a line:

catalogSeparator = ":";

with a comment saying that Informix uses colon as the catalog separator.
This causes JPA to produce statements like this:

CREATE TABLE myschema:mytable (a int);

This does not work with Informix IDS 10 because in IDS, the schema qualifier
separator is not any different from the default, which is "." . 

The correct IDS syntax is CREATE TABLE myschema.mytable (a int);

Colons are used in Informix, but only to qualify schemas with databases,
e.g.

CREATE TABLE mydatabase:myschema.mytable (a int);

Even so, in IDS, I cannot reference a table created under a different
database from the current connection if either database is logged. 

Would anyone know why the catalogSeparator was set to ":" in the Informix
dictionary ? Colon is NOT the separator between the schema and table in the
fully qualified name for IDS (or XPS).

Thanks,
Dinkar
-- 
View this message in context: http://www.nabble.com/Colon-used-for-table%27s-scheme-qualification-in-Informix-tp16995080p16995080.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.


Mime
View raw message