Forums / Developer / Enabling ezpublish with an Apache Derby database

Enabling ezpublish with an Apache Derby database

« 
Previous topic
|
Developer
|
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

eZ debug

Timing: Jan 20 2025 08:50:00
Script start
Timing: Jan 20 2025 08:50:00
Module start 'content'
Timing: Jan 20 2025 08:50:00
Module end 'content'
Timing: Jan 20 2025 08:50:00
Script end

Main resources:

Total runtime0.2170 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0070 589.0859180.8125
Module start 'content' 0.00700.0056 769.898493.8203
Module end 'content' 0.01260.2044 863.7188522.2500
Script end 0.2170  1,385.9688 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00371.7167200.0002
Check MTime0.00140.6504200.0001
Mysql Total
Database connection0.00080.391210.0008
Mysqli_queries0.164675.83421410.0012
Looping result0.00140.64191390.0000
Template Total0.204194.010.2041
Template load0.00080.384710.0008
Template processing0.203293.646310.2032
Override
Cache load0.00060.258910.0006
Sytem overhead
Fetch class attribute can translate value0.00110.526710.0011
XML
Image XML parsing0.00030.138210.0003
General
dbfile0.00411.8746200.0002
String conversion0.00000.002030.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs