openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dinkar Rao <>
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,

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).

View this message in context:
Sent from the OpenJPA Developers mailing list archive at

View raw message