home > overview

Christopher Jones' Blog: New PDO_OCI Attributes



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).




click here to see original article or to find similar articles

 RSS DAILY HEADLINES

HEADLINES

Todd: Obamas night for the history books

Sen. Barack Obama becomes the first African-American presidential nominee of a major political party. NBC's Andrea Mitchell reports. (NBC News Web Extra)Will these nights simply be a page in the history of America or the start of a completely new chapter?  NBC Political Director Chuck Todd previews Obama's acceptance speech.


Pakistans next president: Mr. 10 Percent? (AP)

A Pakistani lawyer tears down a poster of Bhutto's widower and political successor, Asif Ali Zardari, who will run for president in the Sept. 6 election by lawmakers, during a demonstration in Islamabad, Pakistan, on Thursday, Aug. 28, 2008. Hundreds of lawyers are rallying in major Pakistani cities and disrupting traffic to pressure the government to reinstate dozens of judges fired by ex-President Pervez Musharraf. (AP Photo/Emilio Morenatti)AP - Asif Ali Zardari, the man poised to become Pakistan's next president, is still known as "Mr. 10 Percent" because of corruption allegations. Now his own lawyers say he may have suffered from mental health problems within the past year.


Automakers face conflicting safety rules worldwide (AP)

In this Aug. 2008 file photo provided by the Ford Motor Co. an assemblyman works on the Ford Fiesta in Cologne, Germany. While Ford hurries to curtail billions of dollars in losses and shift from its reliance on selling bigger vehicles with bigger profit margins, one reason why Ford says it can't get its European cars to the U.S. market before 2010 is a web of different safety regulations covering everything from the positioning of crash test dummies to the color of rear turn signals. (AP Photo/Ford Motor Co., Friedrich Stark, file)AP - It seems like an easy solution: Americans are looking for more fuel-efficient vehicles, so Ford Motor Co. is bringing over some of the small, gas-sipping cars it's been selling to Europeans for years.