[Coefficient-users] SQL exceptions + Oracle incompatibility

[<seb...@ph...>]

When using Coefficient with mysql I constantly get sql exception after a 
long period of inactivity (similar errors to the one I had at installation 
time before the schema was updated). After a few seconds
clicking arround everything seems to work again. I have the feeling that 
mysql is closing connections and that there are not reset properly.

I also decided to test Coefficient with Oracle in order to find out if 
mysql was the responsible and actually I discovered that it is impossible 
to configure the database with Oracle due to
an identifier name issue.

See extract of the logs below.

4747 [Thread-5] INFO hbm2ddl.DatabaseMetadata  - table not found: 
COEFFICIENT_PROJECT_ATTRIBUTES_DATA
4757 [Thread-5] INFO hbm2ddl.DatabaseMetadata  - table not found: 
COEFFICIENT_PROJECT
4828 [Thread-5] INFO hbm2ddl.DatabaseMetadata  - table not found: 
hibernate_sequence
<< key: hibernate_sequence is not sequence or table
java.sql.SQLException: ORA-00972: identifier is too long

        at 
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)


Best regards,
Sebastien