Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <16995080.post@talk.nabble.com>
Date: Thu, 1 May 2008 14:47:42 -0700 (PDT)
From: Dinkar Rao <dinkar.d91411118@gmail.com>
To: dev@openjpa.apache.org
Subject: Colon used for table's scheme qualification in Informix
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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.