Re: [Coefficient-users] SQL exceptions + Oracle incompatibility

[Thomas F. <tfo...@us...>]

On Thu, 2005-02-10 at 11:33 +0100, sebastien wrote:
> 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 agree with your diagnostic - seems like a logical conclusion. We
should definitely take a look at ways of solving the problem (although
this issue may need to be solved within hibernate itself).

> 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. 
> ...

Yip, I've seen this. Ironic: in the last major overhaul of coefficient,
all the table names were changed to make the data model cleaner and
easier to follow. One of the things done was to prepend "COEFFICIENT_"
to many of the core tables. However, as a result of this, it seems some
of them have become too long for some RDBMS to handle. Anyone know
whether it's possible to configure the max identifier length for Oracle?

As soon as I have some spare time (and the motivation :) I'll change the
tables to use shorter names, and put up a new release.




-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.