#18 Oracle 9i - 10g

[Shadow_x99]

In reference to an issue regarding Oracle 9i and/or 10g, there is an issue concerning a column named 'comment' of the table 'history'.

'comment' is an oracle keyword and therefore, JTrac cannot be used on an Oracle Database. An easy solution could be prefix all columsn and/or tables with something unique ( 'jt_' for example ) so that no columns and/or tables ever equals a sql keywords.

Here is a small patch for the hibernate configuration file that would achieve the correct result and allow JTrac to run on any database.

However, it may cause some pain to some users because the database will need to be update massively (every column and/or every table name changed).

[Shadow_x99]

Logged In: YES
user_id=2097578
Originator: YES

File Added: jtrac.hbm.xml.patch

[Shadow_x99]

Hibernate File

[Shadow_x99]

Logged In: YES
user_id=2097578
Originator: YES

File Added: jtrac.hbm.xml.patch

[Shadow_x99]

Logged In: YES
user_id=2097578
Originator: YES

Uploaded a new version of the patch which fix a minor issue with an hibernate-generated order-by.

[Peter Thomas]

Logged In: YES
user_id=523749
Originator: NO

Thanks for the patch. Posting a reference to the bug:

http://sourceforge.net/tracker/index.php?func=detail&aid=1629019&group_id=162983&atid=825941

Please note that JTrac works on Oracle 11g with no issues.