News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Christopher Jones' Blog:
New PDO_OCI Attributes
September 19, 2007 @ 09:37:00

Christopher Jones talkes about some updates that he's made to the default PDO functionality of PHP, adding in a few things like pre-fetching and methods to get the details of the database server you're using.

After PHP 5.2.4 shipped and a new release cycle began, I merged a couple of enhancements to PDO_OCI attribute handling. Specifically I added $dbh->getAttribute() support for ATTR_SERVER_VERSION, ATTR_SERVER_INFO, ATTR_CLIENT_VERSION and. ATTR_AUTOCOMMIT. At the moment these are only available in the PHP snapshots on http://snaps.php.net/. Let me know if there are any issues so they can be resolved before the next PHP release.

He gives examples of two things - the pre-fetching functionality, allowing for better optimization for a query, and the transaction management features, making it as simple as a try{} block to test the commit and rollback if needed.

He also mentions other properties/attributes included in the new release - ATTR_PERSISTENT, ATTR_TIMEOUT, ATTR_ORACLE_NULLS, ATTR_CASE and ATTR_ERRMODE, ATTR_SERVER_VERSION and ATTR_CLIENT_VERSION (the last two have examples).

0 comments voice your opinion now!
pdo oci oracle attribute prefetching transaction namagement pdo oci oracle attribute prefetching transaction namagement


blog comments powered by Disqus

Similar Posts

Alison Holloway's Blog: A new version of the Underground PHP and Oracle Manual coming soon

Kae Verens' Blog: Book Review: Learning PHP Data Objects

Wez Furlong's Blog: Background/batch/workflow processing with PDO::PGSQL

Davey Shafik's Blog: Debugging PDO Prepared Statements

Zend Developer Zone: Zend Releases Zend Platform 2.2 and Zend Core for Oracle


Community Events





Don't see your event here?
Let us know!


release podcast tips bugfix developer api threedevsandamaybe language symfony opinion community laravel deployment introduction series list interview zendserver framework library

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework