Issues

ZF-4271: Zend Framework on i5/OS with DB2

Description

I've tried unsuccessfully, to use the IBM PDO DB2 adapter that is part of the Framework (library/Zend/Db/Adapter/Pdo/Ibm/Db2.php), but this adapter does not appear to be compatible with DB2 on i5/OS. I have been able to connect with i5_connect and db2_connect on a regular PHP script but my boss wants me to use Zend Framework. Can anyone tell me if Zend Framework will work with DB2 on i5/OS and what DB adapter I need to use? There are plenty examples for PDO_MySQL with Zend Framework buy I can not find any with DB2. See attached config.ini and Fatal error. Can you provide me with a working example using Zend Framework on i5/OS with DB2? Thank You.

My source code "config.ini" looks like this ... [general] db.adapter = PDO IBM DB2 db.params.host = LOCALHOST db.params.port = 50000 db.params.protocol = TCPIP db.params.username = PGMR17 db.params.password = MYPASS db.params.dbname = UATDTA

Fatal Error .... Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'The ibm driver is not currently installed' in /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Adapter/Pdo/Abstract.php:116 Stack trace: #0 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Adapter/Pdo/Ibm.php(101): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Adapter/Pdo/Ibm.php(244): Zend_Db_Adapter_Pdo_Ibm->_connect() #2 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Table/Abstract.php(604): Zend_Db_Adapter_Pdo_Ibm->describeTable('albums', NULL) #3 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Table/Abstract.php(533): Zend_Db_Table_Abstract->_setupMetadata() #4 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Table/Abstract.php(268): Zend_Db_Table_Abstract->_setup() #5 /www/zendcore/htdocs/pgmr17/zf-tutorial/application/controllers/IndexController.php(8): Zend_Db_Table_Abstract->__construct() #6 /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Controller/Action.php(502): IndexC in /usr/local/Zend/ZendFramework-1.6.0/library/Zend/Db/Adapter/Pdo/Abstract.php on line 116

Comments

The latest version of core for i5 has an adapter for DB2 on i5: http://www.zend.com/en/products/core/for-i5os.