Description David Hein 2010-08-27 04:37:59 EDT

Build Identifier: 20100617-1415

Hi,

I'am trying to implement the Oracle DBAdapter like in the bundle org.eclipse.net4j.db.mysql. I integrated the jdbc driver into my bundle. All works fine. Now the framework will create the tables in the database.

While executing the SQL-String

"CREATE TABLE cdo_commit_infos (commit_time NUMBER, branch_id INTEGER, user_id VARCHAR(255), comment VARCHAR(255))"

i got an exception with the message "ORA-00904: string: invalid identifier". The problem is, that the table contains the coloumn "comment". And "comment" is a reserved word in oracle. I found the defintion of this coloumn in the class CDODBSchema:

public static final IDBField COMMIT_INFOS_COMMENT = //
  COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$

Can this "comment" field be renamed to "commit_comment"?

Thank You!
David 

Reproducible: Always