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 15 2025 02:13:51
Script start
Timing: Jan 15 2025 02:13:51
Module start 'content'
Timing: Jan 15 2025 02:13:52
Module end 'content'
Timing: Jan 15 2025 02:13:52
Script end

Main resources:

Total runtime1.0423 sec
Peak memory usage6,144.0000 KB
Database Queries184

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0122 684.4688214.7734
Module start 'content' 0.01230.8934 899.24221,756.6250
Module end 'content' 0.90570.1366 2,655.8672631.8984
Script end 1.0423  3,287.7656 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00730.6963210.0003
Check MTime0.00150.1417210.0001
Mysql Total
Database connection0.00580.552710.0058
Mysqli_queries0.955091.62451840.0052
Looping result0.00160.15791810.0000
Template Total1.002596.220.5013
Template load0.00380.360220.0019
Template processing0.998895.820520.4994
Template load and register function0.00150.140710.0015
states
state_id_array0.00140.130710.0014
state_identifier_array0.00120.118020.0006
Override
Cache load0.00330.3208170.0002
Sytem overhead
Fetch class attribute can translate value0.00160.158030.0005
Fetch class attribute name0.00440.423720.0022
XML
Image XML parsing0.00070.068830.0002
class_abstraction
Instantiating content class attribute0.00000.001020.0000
General
dbfile0.00140.1344150.0001
String conversion0.00000.000630.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs