[opencms-dev] OpenCMS and Informix

[Alexander Kandzior]

João,

you are right about the "broker" architecture. 

In essence, there is a "generic" DB package wich has classes with
methods that call SQL queries that are mostly ANSI SQL compliant.
Individual packages for specific DB's just extend the classes and
overload a couple of mehtods where queries or other handling is DB
specific. Usually, only about 10% or less of the generic stuff is
overloaded.

However, this part of the system is currently re-designed and quite some
things have already changed or will change in the next 2 months. You
might check out the CVS HEAD to get an impression. 


Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

> -----Original Message-----
> From: opencms-dev-admin at opencms.org 
> [mailto:opencms-dev-admin at opencms.org] On Behalf Of João Silva
> Sent: Thursday, June 05, 2003 12:48 AM
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] OpenCMS and Informix
> 
> 
> Hello again
> 
> Thank you for your prompt response Nicolas. I believe I've 
> mislead the 
> question, and I should put it now in another terms:
> 
> The problem is that I've read somewhere - in the mailing list 
> archives 
> - that opencms has a few brokers (mysql, mssql and oracle, I believe) 
> in order to communicate with the database backend, via jdbc 
> interface. 
> So, what if I wanted to use Informix (or another database)? Should I 
> start working on a resource broker? If so, where to start (any 
> documentation on that)? Or by the other hand, don't worry 
> about it and 
> do as you said?
> 
>   The question here is at the moment I can't get my hands on 
> an Informix 
> database, so I must decide more or less blindly on this matter.
> 
> Thank you for your help
> João Silva
> 
> 
> On Wednesday, June 4, 2003, at 03:59 PM, Nicolas Delsaux wrote:
> 
> > On Wed, 04 Jun 2003 15:45:02 +0100, João Silva 
> <jonms at mac.com> wrote:
> >
> >> Hi all!
> >>
> >> I've got this question: what do I need to do to make OpenCMS work
> >> with an Informix database?
> >> I know this is a bit technical post, and I'm a newbie on 
> this, so any 
> >> help on this matter will be appreciated.
> >
> > Hi João,
> > in fact, your question is a more general question on how to replace
> > mySQL with Informix in a J2EE application. Let's regard a 
> very quick 
> > howto: - add the informix jdbc driver to the archive of your 
> > application
> > - change the content from your config files to use Informix 
> instead of 
> > mySQL (change the URL used for JDBC connection and change 
> the driver 
> > name)
> > - update scripts to reflect differences between mySQL and 
> Informix SQL 
> > dialects
> > and pray ;-)0
> >>
> >> Thank you
> >> João Silva
> >
> > my 2 pieces
> >
> >
> > --
> > Nicolas Delsaux
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
> > visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
>