roger.keays wrote:
{prepstmnt 17689439 INSERT INTO FB_BLOBS (contentType, filename, size)
VALUES (?, ?, ?)
If I execute the statement manually, quoting the size token, it is okay.
Not the best example I suppose, since 'size' isn't in the default oracle
DBdictionary. The following
We've historically always taken the approach of avoiding the word
altogether, rather than escaping the word.
It certainly wouldn't be difficult to modify DBDictionary to escape
reserved words instead of avoiding them, though.
-Patrick
--
Patrick Linskey
BEA Systems, Inc.
Roger-
Can you also specify -Log=DefaultLevel=TRACE and post the output?
Specifically, it should report what all the properties are being set
to, so we can see if JoinForeignKeyDeleteAction has any setting at
all.
Also, if you specify JoinForeignKeyDeleteAction first in the list,
does
I'm amazed that I never knew that you could quote reserved column
names. I just tested on Oracle, SQL Server, and Derby, and it seems
to work for both of them.
Could you make an enhancement request at http://issues.apache.org/
jira/browse/OPENJPA so we can track this? It'd be a very
Escape sql reserved words in column names
-
Key: OPENJPA-84
URL: http://issues.apache.org/jira/browse/OPENJPA-84
Project: OpenJPA
Issue Type: Improvement
Components: sql
Update reserved words in DBDictionaries
---
Key: OPENJPA-85
URL: http://issues.apache.org/jira/browse/OPENJPA-85
Project: OpenJPA
Issue Type: Improvement
Components: sql
Reporter:
I've just finished testing the portability of an openjpa app, and thought you
all might be interested in the results. Basically, of the 9 databases I
tested the only one which I couldn't get to work was hypersonic.
The db's tested were:
Derby 10.1,
Postgres 8.1,
Postgres 7.4,
Mysql 5.0,