Re: generate sql from entity modeler in Eclipse
Re: generate sql from entity modeler in Eclipse
- Subject: Re: generate sql from entity modeler in Eclipse
- From: Guido Neitzer <email@hidden>
- Date: Sun, 18 Nov 2007 20:10:45 -0700
On 18.11.2007, at 18:44, Theodore Petrosky wrote:
CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT
SETVAL('maintable_seq', (SELECT MAX(theoid) FROM
maintable));
Notice the table name is not quoted so postgresq1 will
fold the name to lower case. the next line deletes the
table and fails:
DROP TABLE EOF_TMP_TABLE;
again because it is not quoted... Where should I send
the information about this bug?
To the Wonder list - or in that case to me is okay too.
I'd have to take a closer look at that, but what I don't understand
from your example: if in both cases the table name is not quoted, it
should not be a problem as the conversion to lowercase happens in both
cases. I'm not using pk generation but I'm pretty sure that it would
work if either both cases or none is quoted.
The problem might be, that I have no idea how to tell Entity Modeler
to use a project property (like for enabling identifier quoting for
SQL generation). It is definitely possible to set
com
.webobjects.jdbcadaptor.PostgresqlExpression.enableIdentifierQuoting =
true
and have the quoting available during application runtime.
Nevertheless that shouldn't matter for the example sql you gave.
Mike, is there a way to inject a property into SQL generation from
Entity Modeler?
cug
_______________________________________________
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