Ready, steady, go: I just caught news from OTN: 11g for Linux is out. It is downloadable from here.
On the PHP front: the OCI8 and PDO_OCI8 extensions work with it but because library names have changed to 11.1, the install script needs to be updated. I will merge a build patch for this very soon to PHP's CVS. Until then try this hack patch:
- Edit ext/oci8/config.m4 and ext/pdo_oci/config.m4 and change occurrences of 10.1 to 11.1
- rm -rf config.cache configure
- ./buildconf --force
- Re-run your configure and make commands.
Update: this entry was reposted with a URL change to the download link.
Update 2: This morning I merged updated config.m4's for OCI8 and PDO_OCI. They will ship with PHP 5.2.4 and in PECL OCI8 1.2.4.
Comments (5)
Hi Jones,
Thanks for your news. I am very interested in cached statement and connection pooling support in PHP 5.2.4 because our website is powered by Oracle Ent 10g and PHP 5.2.3. It is deadly slow. But with I have read so far in your blog, I believe that there is much improvement coming up in the next Oracle and PHP versions.
However, I am not sure that how much upgrading from Oracle 10g to 11g costs us to have connection pooling support in PHP 5.2.4. I would be grateful if you could point me to the right page that I can get that information.
Thanks
Posted by pcdinh | August 10, 2007 2:20 AM
Posted on August 10, 2007 02:20
great news!
do you have any hint about a possible future Xpress edition release
Posted by Gaetano Giunta | August 10, 2007 4:39 AM
Posted on August 10, 2007 04:39
@pcdinh: I'm interested in talking more with you about your site and what you want to achieve - see "About" for my details. Regarding features, 11g connection pooling support is not part PHP 5.2.4; the PHP OCI8 extension code for this is still under development but maybe you would like to evaluate it? Statement caching has been part of OCI8 for the last couple of years but a bug fix in PHP 5.2.4 improves it. Result caching in 11g is a SQL and DB feature (i.e. not related to the OCI8 extension code or to any specific PHP version) which will be available when you use Oracle 11g.
@Gaetano: no hints yet.
Posted by Christopher Jones | August 10, 2007 3:32 PM
Posted on August 10, 2007 15:32
The description of the tgz says that you just type ./configure. There is no configure script. How do I generate it from config.m4?
I can see that you are trying to make this simple and useful. The problem is that when A+B+C+D gets you 95% of the way there, the last 5% can be a bitch. Next time, update the docs to include a note about the config.m4 (something like 'by the way, you can't just type configure anymore, you have to generate it with m4 (see link for how to do this)')
Thank you so very much.
Posted by Jason Livesay | July 3, 2008 5:45 PM
Posted on July 3, 2008 17:45
That sounds like a doc suggestion that should be logged at http://pecl.php.net/bugs/report.php?package=oci8
Please include what you have downloaded and what you are trying to install onto.
If have general questions not related to this blog entry, the best place to ask them is at http://forums.oracle.com/forums/forum.jspa?forumID=178
Posted by Chris Jones | July 3, 2008 8:04 PM
Posted on July 3, 2008 20:04