This site has been archived and you can no longer log in or post new messages. For up-to-date community resources please visit ezplatform.com

eZ Community » Forums » eZ Publish 5 Platform » Oracle support in 5
expandshrink

Oracle support in 5

Oracle support in 5

Thursday 02 August 2012 10:48:52 am - 12 replies

Hi guys!

When do you think we will see Oracle support for eZ Publish 5? We are starting a project in mid September with a planned release early January, so we are thinking about doing this on an eZ 5 install. It is early, and probably a bit risky, but we just gotta jump into it, right? blunk.gif Emoticon 

The customer wish to run this on his existing Oracle setup, so we have a little issue there, as I saw that ezp5 currently only supports MySQL and Postgres.

Kristian

Thursday 02 August 2012 12:30:38 pm

The world is unfortunately working against you:

. eZP 5 connects to the "legacy" storage engine using the ZetaComponents DB classes

. which are in turn based on PDO

. the Oracle PDO driver is known for basically sucking (it lacks most of the nice features found in the oci driver, and Oracle never seemed to really care about it)

. which makes complete/spotless Oracle support in eZP5 harder than it was in eZP4 (and even then it was sometimes a bit of a rough ride)

Thursday 02 August 2012 12:40:39 pm

Does this mean there will be no support for oracle in ezp5+.

Thanks for clarification...

Thursday 02 August 2012 1:15:38 pm

Quote from Patrick Kaiser :

Does this mean there will be no support for oracle in ezp5+.

Thanks for clarification...

eZ Publish 5+ will have Oracle support by the mean of a dedicated Storage Engine, but it will most likely come after 5.0 and as a separate bundle. Target is more 5.1.

Friday 03 August 2012 4:53:59 pm

As Jérôme mentioned it can be supported via own Storage Engine, but it can also be supported in Legacy Storage Engine by means of extending eZ\Publish\Core\Persistence\Legacy\EzcDbHandler and implement all PDO functions like done in Doctrine DBAL or by means of forking Legacy Storage Engine and refactor it to use Doctrine DBAL over Zeta Database Component.

But unless there is interest in the Community to get started on such a project soon, then I wouldn't expect 5.x stack (Public API, REST API 2.0 & eventually Editorial Interface) to support Oracle anytime soon.

Saturday 04 August 2012 11:49:08 am

Thanks for the feedback.

I will try to convince the customer to run this on MySQL or Postgres, but I wonder if you have any thoughts about the posibility of migrating an install from MySQL to Oracle when eZP 5 has stable Oracle support. Easy?

Kristian

 

Sunday 30 September 2012 10:23:54 pm

Hi Kristian

I wanted to better understand the Oracle need from you. I have worked with customers using Oracle and eZ. What are the drivers for the customer using Oracle? What are there main reasons for using it?

Tony

Sunday 21 October 2012 10:04:37 am

What about Enterprise users?

Are there any that use eZP on Oracle?

How will eZ Systems provide support for them if they discontinue support for Oracle in eZP 5?

Sunday 21 October 2012 9:57:53 pm

Existing Enterprise customers on Oracle(yes, there are some) will be able to upgrade to 5.0, but only use fully the Legacy Stack.

As for migrating between Mysql and Oracle in the future, it will probably be easier than it currently is, via usage of the REST api plumbing

Monday 22 October 2012 7:35:41 am

The reply has been removed because of violation of forum rules.

Monday 22 October 2012 10:03:52 am

Quote from Mavko Žmak - Žmale :

What about Enterprise users?

Are there any that use eZP on Oracle?

How will eZ Systems provide support for them if they discontinue support for Oracle in eZP 5?

We will most likely have a dedicated storage engine for that. Moreover, we'll more than probably switch from ezcDatabase to Doctrine DBAL, which supports Oracle via oci8 driver out of the box (but it will probably not be supported for Oracle, it's more for compatibility).

Saturday 27 October 2012 8:42:56 pm

Quote from Jérôme Vieilledent :
Quote from Mavko Žmak - Žmale :

We will most likely have a dedicated storage engine for that. Moreover, we'll more than probably switch from ezcDatabase to Doctrine DBAL, which supports Oracle via oci8 driver out of the box (but it will probably not be supported for Oracle, it's more for compatibility).

Any predictions on when will this be implemented?

Sunday 28 October 2012 12:00:53 pm

If it gets accepted to the roadmap: Somewhere between December this year and December next year happy.gif Emoticon

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from