[Coefficient-users] Coefficient with MaxDB?

[Brice R. <br...@fi...>]

I'd like to use Coefficient with MaxDB by MySQL (formerly SAPDB), as it 
is a more robust enterprise database, compared to vanilla MySQL. 
However, Coefficient doesn't appear to support the SAPDB dialect that 
Hibernate supports. MaxDB does have an ORACLE SQL compatibility mode, 
but it is Oracle 7 compatibility, not Oracle 9. I've tried running 
Coefficient against MaxDB both with and without Oracle SQL mode enabled 
... and I get varying degrees of success. I can get pretty far w/o 
Oracle SQL mode, but I cannot create a project. If I enable Oracle SQL 
mode, I can create a project, but the admin cannot approve it (output 
columns too long).

(Note: if I enable Oracle SQL mode from the get-go, I get a series of 
exceptions thrown when I try to save the installation parameters 
presented by the first screen, when Coefficient is first installed, my 
previous success w/ Oracle SQL mode involved switching to this mode 
*after* initial setup of tables and such)

Is there any work going on to make Coefficient more compatible with 
MaxDB? Is this something that could be easily done by me? I'm pretty 
proficient with SQL, in general.

I'm quite excited about Coefficient in general - looks like its a pretty 
savvy system, I just really don't want to go back to vanilla MySQL!!

Thanks,

-- 
Brice D. Ruth
Sr. IT Analyst
Fiskars Brands, Inc.