Re: [Coefficient-users] Coefficient with MaxDB?

[Lisa R. <lis...@sa...>]

Hi,

I run coefficient against PostgreSQL and that works great. I am 
surprised that the SAPDB dialect does not work, since hibernate is used 
and thus anything that hibernate supports coefficient will support too, 
right? I am not one of the developers though, so I will let them answer 
properly.

I just don't understand why anyone would not be using PostgreSQL ;-)

Lisa

Brice Ruth wrote:

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