Enabling ezpublish with an Apache Derby database

Next topic

Author	Message
Jeff Levitt	Friday 05 August 2005 2:39:43 pm Hi, I am interested in using an Apache Derby database (open source java database) instead of MySQL with EzPublish. The first thing I did was to modify the kernel_schema.sql statements to work with Derby syntax. That now works, but I don't know where to begin in terms of pointing EZPublish to my Derby database. I've set up my Windows environment so that PHP and Apache HTTP server both work with my Derby database, which is registered via a DB2 ODBC Lite client. Do I need to create an extension, and if so, can someone explain what it is I need to do?
Lazaro Ferreira	Saturday 06 August 2005 4:26:03 am Hi, I think you have to implement an EZPublish DB interface for Derby (assuming Derby is similar to MySQL and PostgreSQL , I mean a RDBSQL Server ) : Looking to EZP code you will find the implemented interfaces at : lib/ezdb lib/ezdbschema Then at least you have to override settings at : site.ini,dbschema.ini In site.ini look at [DatabaseSettings] like [DatabaseImplementation],[ImplementationAlias] In dbschema.ini, you will have to add support for your database in every related setting Last, I have never implemented a DB interface in EZP, but I think EZP is designed to support new SQL Databases Server via a pluging architecture, like mentioned above, exist also Oracle and MS-SQL commercial plugings , and AFAIK EZ can develop additional plugings for you (commercial stuff) Lazaro http://www.mzbusiness.com

Author

Message

Friday 05 August 2005 2:39:43 pm

Hi,

I am interested in using an Apache Derby database (open source java database) instead of MySQL with EzPublish. The first thing I did was to modify the kernel_schema.sql statements to work with Derby syntax. That now works, but I don't know where to begin in terms of pointing EZPublish to my Derby database. I've set up my Windows environment so that PHP and Apache HTTP server both work with my Derby database, which is registered via a DB2 ODBC Lite client.

Do I need to create an extension, and if so, can someone explain what it is I need to do?

Lazaro Ferreira

Saturday 06 August 2005 4:26:03 am

Hi,

I think you have to implement an EZPublish DB interface for Derby (assuming Derby is similar to MySQL and PostgreSQL , I mean a RDBSQL Server ) :

Looking to EZP code you will find the implemented interfaces at :

lib/ezdb
lib/ezdbschema

Then at least you have to override settings at :
site.ini,dbschema.ini

In site.ini look at [DatabaseSettings] like [DatabaseImplementation],[ImplementationAlias]

In dbschema.ini, you will have to add support for your database in every related setting

Last, I have never implemented a DB interface in EZP, but I think EZP is designed to support new SQL Databases Server via a pluging architecture, like mentioned above, exist also Oracle and MS-SQL commercial plugings , and AFAIK EZ can develop additional plugings for you (commercial stuff)

Lazaro
http://www.mzbusiness.com