ezoracle extension

Author Message

Amer Azzaz

Tuesday 06 December 2005 7:13:08 am

i installed the ezoracle extension. Can anyone help in how to use it ? my goal is to display data in a page and these data should be retrieved from orcale db.

what are the benefits of using ezoracle extension instead of using PHP to connect and fetch data from oracle db.

Vadym Savchuk

Tuesday 06 December 2005 7:25:37 am

Hi Amer.

"i installed the ezoracle extension. Can anyone help in how to use it ? my goal is to display data in a page and these data should be retrieved from orcale db."

First, please read INSTALL file. It explains how to install the extension and make eZ publish use Oracle.

"what are the benefits of using ezoracle extension instead of using PHP to connect and fetch data from oracle db."

eZ publish does not use database directly. Instead, the interaction is done with ezdb library providing generic database access API. ezoracle contains a driver for ezdb that makes it possible to migrate an eZ publish site to Oracle.
If your site is running on an other DBMS and you just need to execute a couple of Oracle queries, there's no need to use ezoracle.

Amer Azzaz

Tuesday 06 December 2005 7:36:29 am

If i just want to fetch some data from Oracle database for some pages on an ezpublish site. Do you advice to use ezoracle extension ? (it means i will keep mysql and connect to oracle to fetch these data only).

Vadym Savchuk

Tuesday 06 December 2005 7:51:35 am

No, I think you don't need ezoracle much in this case.

Amer Azzaz

Tuesday 06 December 2005 11:58:17 pm

ok, i won't use the ezoracle extension. Can i use ezDB class to connect to oracle DB ? if yes please could you explain how can i pass the parameters ?

Vadym Savchuk

Wednesday 07 December 2005 5:18:37 am

"ok, i won't use the ezoracle extension. Can i use ezDB class to connect to oracle DB ? if yes please could you explain how can i pass the parameters ?"

:-) Sure you can. But if you're using ezdb to connect to Oracle that implies using ezoracle as Oracle driver for ezdb.
Usage of ezdb over Oracle doesn't differ from using it over MySQL.
Please see the INSTALL file.

Amer Azzaz

Wednesday 07 December 2005 6:21:40 am

the idea is that i will still use the mysql connection as a master connection, and for a specific case i want to use the oracle driver to connect to the oracle database to retreive some data for display.

how can i configure ezdb to use the ezoracle extension to do so?

the installation guide shows how to use the oracle connection as a master database connection and not as an oxiliary connection.

thanks for your help.

Vadym Savchuk

Wednesday 07 December 2005 7:19:39 am

"the idea is that i will still use the mysql connection as a master connection, and for a specific case i want to use the oracle driver to connect to the oracle database to retreive some data for display."
Yes, I understood.

"how can i configure ezdb to use the ezoracle extension to do so?
the installation guide shows how to use the oracle connection as a master database connection and not as an oxiliary connection. "

You must pass some extra parameters to eZDB::instance() in this case.
Example:

$parameters = array( 'server' => 'localhost',
                     'user' => 'scott',
                     'password' => 'tiger',
                     'database' => 'orcl' );
$db =& eZDB::instance( 'ezoracle', $parameters, true );

$result = $db->arrayQuery( 'SELECT * FROM tab' );
foreach ( $result as $row )
    echo $row['tname'] . "\n";

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.