Re: [Coefficient-users] Coefficient with MaxDB?

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

PostgreSQL is an excellent database, but it does lack in certain areas. 
MaxDB by MySQL is open-source with a proven enterprise database track 
record, it even has an Oracle 7 compatibility mode!! The jdbc drivers 
are mature, the installation/setup process is excellent, and the 
management tools are on par with those of systems like Oracle and SQL 
Server.

Important for us was the support for UNICODE, which is first rate (our 
DB2/400 database supports UNICODE, exporting that data to MySQL didn't 
work well, but MaxDB stepped in just fine). The ability to easily setup 
hot spare servers, and support for SMP systems are also nice-to-haves 
that MaxDB offers! We've yet to touch the backup capabilities, but these 
are also available and integrated into the core system, much the same as 
SQL Server's backup capabilities.

So, not dissing' postgres at all, but MaxDB is an outstanding 
open-source database ... so good, in fact, that I'm not entirely sure 
why MySQL AB is still working on MySQL! MaxDB doesn't seem to suck up 
resources, either ... which I was rather surprised with! That's 
certainly very different from Oracle :)

Brice

Lisa Retief wrote:

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

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