Oracle Database

FreeTrial

How do I used editor with an Oracle database. For datatables itself I completed that easily since the server side processing could be easily accomplished using the information provided on the page.

Can I modify the staff.php, used in the serverside processing example, and modify it to use an oracle database? If not how can I write my own code to get it to do so?

allan

Do you have the Oracle PDO drivers installed? If so, simply set the type option in the config.php file to be Oracle.

If you don't then you would need to use a user space PDO driver - there are some instructions about this if you look in Database/Drivers/Oracle/Query.php.

It is worth noting that Editor's Oracle interface is beta.

Allan

FreeTrial

Ah, thank you for quick response. I have a WAMP setup and after comparing PDO vs the OCI8 drivers I'll have to use the pdo-via-oci8 for laravel beacsue we use CLOBS often (It was an old post maybe this is supported now?)

How would I install pdo-via-oci8? Do I just add the contents of pdo-via-oci8-master.zip\pdo-via-oci8-master\src\yajra\Pdo to the driver\oracle folder? if not I'll read the two classes and hammer on it for a bit. Should be able to get it to work

Unfortunately jajra only posted installation instructions for Laravel

allan

Yes, - the way I've done it myself is to include the yajra classes in the same directory as the Editor Oracle drivers, and at the top of Query.php ass include_once( ... ) for the various files. Include the exception file first, then the statement file and finally the Oci8 file.

The Editor libraries should automatically detect it and use them from there.

Interested to know how you get on with it! The Oracle driver is in production use by a few other customers, but I don't use Oracle dbs much myself, so feedback is always welcome.

Allan