[opencms-dev] new bee

[Christian Sell]

how are you going to deal with autoincrement columns, which you use in the
current DB schema? Some DBMS (e.g., IBM DB2) dont directly support those.

Have you ever considered to move your DBMS access to an object-relational
mapping tool? I can recommend Castor (www.exolab.org), which is open source,
and already quite stable. As far as I now Castor would be able to take care
of key generation issues as well.


-----Original Message-----
From: Alex Kandzior <alex at opencms.com>
To: 'opencms-dev at www.opencms.com' <opencms-dev at www.opencms.com>
Date: Freitag, 19. Mai 2000 14:55
Subject: RE: [opencms-dev] new bee


>> Theoretically, all you would need is a JDBC driver, which
>> could be the JdbcOdbcbridge in the case of Access.
>> However, much of the data access code in OpenCMS still looks
>> pretty MySQL-specific.
>
>If we proceed on schedule we will have the mySQL specific stuff eliminated
>in about 2 weeks. We could also produce setup scripts for different
>databases (that is easy because a modelling tool is used for the DB
design).
>The new structure will be ANSI 92 compatible and therefore will run on any
>ANSI SQL compatible database. Theoretically, that is :-)
>
>Best Regards,
>
>Alex.
>
>-----------------------
>Alexander Kandzior
>OpenCms Group
>mailto:alex at opencms.com
>
>Download OpenCms at http://www.opencms.com
>
>
>