AW: [fw-db] zf:accessing db2 table on system i

Hi Sante,

you should not use the Db2 Adapter from Zend Framework, but the one which was especially created for System i. You can find it in the ZendC folder next to the ZF library. More information can be found here in Appendix H:
http://static.zend.com/topics/Zend-Core-User-Guide-i5OS-V261.pdf

Regards,
Jan

-----Ursprüngliche Nachricht-----
Von: sante [mailto:sante_malatesta@codexroma.it]
Gesendet: Freitag, 21. Mai 2010 15:44
An: fw-db@lists.zend.com
Betreff: [fw-db] zf:accessing db2 table on system i

Hi all!
I'm trying to work with ZF, so I've downloaded the quickstart tutorial from
the web. My installation is on system ibm i os/v5r4 and my database is
(obviously) db2. I've changed the tutorial in order that it can deal with
this database. Actually connection to the database works and I can get
metadata from any table. But there is a big problem. When the script attemps
to access a db2 table (namely the "save" function of GuestbookMapper.php for
signAction of the controller) I get the following error message:
An error occurred
Application error
#0 /usr/local/Zend/ZendFramework/library/Zend/Db/Statement.php(115):
Zend_Db_Statement_Db2->_prepare('INSERT INTO "gu...')
#1 /usr/local/Zend/ZendFramework/library/Zend/Db/Adapter/Db2.php(230):
Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Db2), 'INSERT INTO
"gu...')
#2 /usr/local/Zend/ZendFramework/library/Zend/Db/Adapter/Abstract.php(467):
Zend_Db_Adapter_Db2->prepare('INSERT INTO "gu...')
#3 /usr/local/Zend/ZendFramework/library/Zend/Db/Adapter/Abstract.php(546):
Zend_Db_Adapter_Abstract->query('INSERT INTO "gu...', Array)
#4 /usr/local/Zend/ZendFramework/library/Zend/Db/Table/Abstract.php(1056):
Zend_Db_Adapter_Abstract->insert('guestbook', Array)
#5
/www/zendcore/htdocs/quickstart/application/models/GuestbookMapper.php(69):
Zend_Db_Table_Abstract->insert(Array)
#6 /www/zendcore/htdocs/quickstart/application/models/Guestbook.php(224):
Default_Model_GuestbookMapper->save(Object(Default_Model_Guestbook))
#7
/www/zendcore/htdocs/quickstart/application/controllers/GuestbookController.php(59):
Default_Model_Guestbook->save()
#8 /usr/local/Zend/ZendFramework/library/Zend/Controller/Action.php(513):
GuestbookController->signAction()
#9
/usr/local/Zend/ZendFramework/library/Zend/Controller/Dispatcher/Standard.php(289):
Zend_Controller_Action->dispatch('signAction')
#10 /usr/local/Zend/ZendFramework/library/Zend/Controller/Front.php(946):
Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http),
Object(Zend_Controller_Response_Http))
#11
/usr/local/Zend/ZendFramework/library/Zend/Application/Bootstrap/Bootstrap.php(77):
Zend_Controller_Front->dispatch()
#12 /usr/local/Zend/ZendFramework/library/Zend/Application.php(358):
Zend_Application_Bootstrap_Bootstrap->run()
#13 /www/zendcore/htdocs/quickstart/public/index.php(28):
Zend_Application->run()
#14 {main}
Any guggestion?
Thanks a lot

--
View this message in context: http://zend-framework-community.634137.n4.nabble.com/zf-accessing-db2-table-on-system-i-tp2226165p2226165.html
Sent from the Zend DB mailing list archive at Nabble.com.