Re: [Coefficient-users] Coefficient with MaxDB?

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

Read the license carefully though - if used for commercial apps you have to pay
license fees.

Quoting Brice Ruth <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.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Coefficient-users mailing list
> Coe...@li...
> https://lists.sourceforge.net/lists/listinfo/coefficient-users
>