Planet i

I’d like to address questions about DB2 support in Zend Framework 2.x. Because I helped create the IBM i-friendly DB2 adapter for Zend Framework 1.x, I’m following the development of a similar adapter for ZF2.

Q. Does ZF 2 include an adapter for DB2?
A. ZF 2.0 does not, but read on.

Q. When will a DB2 adapter be included in ZF 2.x?
A. Rumor says ZF 2.1 or 2.2. I plan to discuss it with the Zend Framework team at ZendCon in a week or two (late October, 2012).

Q. Does Alan’s IBM i-friendly DB2 adapter for Zend Framework 1.x work in 2.x?
A. No. Because ZF’s Zend_Db equivalent in 2.x works differently than in 1.x, my 1.x component will not work in 2.x.

Q. When will you know more?
A. I’ll know more after ZendCon, so probably late October/early November. I plan to spend time with the db adapter team at the conference. We’ll discuss the needs of IBM i users, such as support for driver-specific features, including library lists.

Q. Help! I must use ZF2 now.
A. You can still use the underlying functions in the ibm_db2 driver (db2_connect, db2_exec, etc.). I know one person creating his own bare-bones adapter based on these. For most people, though, it’s best to wait for the official announcement.

I’ll update this blog post after ZendCon.

Read the original at Alan Seiden's PHP and IBM i Resources.

I’d like to address questions about DB2 support in Zend Framework 2.x. Because I helped create the IBM i-friendly DB2 adapter for Zend Framework 1.x, I’ve followed the development of a similar adapter for ZF2.

(updated January 30, 2013, upon the release of ZF 2.1)

Q. Does ZF 2 include an adapter for DB2?
A. Yes! Starting with ZF 2.1, which was released today.

Q. Is Alan’s IBM i-friendly DB2 adapter for Zend Framework 1.x needed in 2.x?
A. No. Because ZF’s Zend_Db equivalent in 2.x works differently than in 1.x, my 1.x component is not needed in 2.x.

Q. Does ZF 2.1′s DB2 adapter work with IBM i?
A. Yes! Please try it and provide feedback to the ZF team.

Read the original at Alan Seiden Consulting: PHP and IBM i Expertise.

I’ve started a consulting firm dedicated to helping companies attain superior results with PHP, Zend Framework, IBM i, and related technologies such as Zend Server, DB2, and the new PHP toolkit.

We will provide guidance and best practices, training, mentoring, troubleshooting, performance help, team building, speaking, writing, and advocacy.

My first speaking engagement with my new company will be the OCEAN conference on July 20, 2012, in Southern California. Hope to see some of you there.

Thanks for your support. I will be available starting July 2 after a short vacation. I look forward to working with you.

Alan

Read the original at Alan Seiden's PHP and IBM i Resources.

Tomorrow I’m presenting a new webcast, New PHP Toolkit from Zend and IBM: Open Source on IBM i, as part of System i Network’s free “Virtual Conference.”

Date: Thursday, April 5
Time: 11:15am ET
Registration (free): http://tinyurl.com/new-toolkit-20120405

Other presentations in the virtual conference include Jon Paris explaining why PHP is an excellent strategic choice on IBM i, two talks on mobile technology, and more.

I invite you to watch the webcast, ask questions, and learn more about the new toolkit.

Read the original at Alan Seiden's PHP and IBM i Resources.

Hope you can join me for “Web performance first aid,” a webcast for the COMMON user group. The webcast will be recorded and archived for future listenings as well.

The webcast is for COMMON members, so anyone wanting to hear it needs to join COMMON.

I based the presentation on my consulting practice that helps ensure high performance for PHP and Zend Framework applications on IBM i. Good performance is critical for customer acceptance of web sites and mobile applications.

Webcast link: http://www.common.org/index.php/webcasts/upcoming-webcasts.html

Anyone wishing to see just the slides can do that on my site: http://alanseiden.com/presentations and look for “Web performance first aid.”

Read the original at Alan Seiden's PHP and IBM i Resources.

I recently received a question about how to use DB2 with Zend Framework on IBM i. Thomas wrote:

I would like to start with Zend Framework on i5 [IBM i] with Zend Server and ZF’s DB2 database adapter. I got this error message:
Qualified object name SYSCOLUMNS not valid. SQLCODE=-5016

I told Thomas about an improved DB2 adapter, optimized for IBM i, that I’d created in cooperation with Zend. Its usage is explained in my presentation, “From Zero to ZF,” on my Presentations page: http://www.alanseiden.com/presentations/.

Thomas wrote back to say this adapter worked perfectly for him, eliminating the error and improving performance. I believe this DB2 adapter (or something similar) will eventually be included with Zend Framework 2.0, but until then, it works well as a custom adapter.

Read the original at Alan Seiden's PHP and IBM i Resources.