JavaJDBCAdaptor quoted identifier?
JavaJDBCAdaptor quoted identifier?
- Subject: JavaJDBCAdaptor quoted identifier?
- From: PA <email@hidden>
- Date: Sat, 27 Nov 2004 11:52:42 +0100
Hello,
Is there a way to tell the JavaJDBCAdaptor to systematically quote SQL
identifiers?
For example, EOModeler will generate the following SQL for a given
entity:
CREATE TABLE EFCurrency (_oid bytea NOT NULL, _versionOID bytea NOT
NULL, id varchar(32) NOT NULL);
Some databases will convert such unquoted SQL identifiers to lowercase
(e.g. Postgres will morph _versionOID into _versionoid).
How to tell the JDBCAdaptor to generate the following SQL instead:
CREATE TABLE "EFCurrency" ("_oid" bytea NOT NULL, "_versionOID" bytea
NOT NULL, "id" varchar(32) NOT NULL);
Note that all the identifiers are now appropriately quoted. In the case
of Postgres, quoting the identifiers will preserve their case
sensitivity.
The same applies for regular EOSQLExpression. I would like to have it
quoted as well:
SELECT "_oid", "_versionOID", "id" FROM "EFCurrency" WHERE "_oid" = ?
In other words, how to tell the JavaJDBCAdaptor to use the appropriate
quotation policy based on the information provided by
java.sqlDatabaseMetaData (getIdentifierQuoteString,
supportsMixedCaseQuotedIdentifiers, etc) so mixed case identifiers are
always preserved if the underlying database supports it?
TIA.
Cheers,
PA.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden