Issues

ZF-4501: Unable to query database.

Issue Type: Docs: Problem Created: 2008-10-06T07:49:06.000+0000 Last Updated: 2009-01-11T21:42:47.000+0000 Status: Closed Fix version(s): Reporter: Simon Verberne (zedmond) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db_Adapter_Db2

Related issues: Attachments:

Description

I am receiving the following error when I attempt to instantiate an extended Zend_Db_Table_Abstract object.

I am able to use the native db2_connect() methods to connect to the database and perform queries.

Fatal error: Uncaught exception 'Zend_Db_Statement_Db2_Exception' with message 'COLUMNS in SYSCAT type *FILE not found. SQLCODE=-204' in /usr/local/Zend/ZendFramework/library/Zend/Db/Statement/Db2.php:69 Stack trace: #0 /usr/local/Zend/ZendFramework/library/Zend/Db/Statement.php(109): Zend_Db_Statement_Db2->_prepare('SELECT DISTINCT...') #1 /usr/local/Zend/ZendFramework/library/Zendc/Db/Adapter/Db2.php(215): Zend_Db_Statement->__construct(Object(ZendC_Db_Adapter_Db2), 'SELECT DISTINCT...') #2 /usr/local/Zend/ZendFramework/library/Zend/Db/Adapter/Abstract.php(429): ZendC_Db_Adapter_Db2->prepare('SELECT DISTINCT...') #3 /usr/local/Zend/ZendFramework/library/Zendc/Db/Adapter/Db2.php(430): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...') #4 /usr/local/Zend/ZendFramework/library/Zend/Db/Table/Abstract.php(604): ZendC_Db_Adapter_Db2->describeTable('ADDRESSTYPE', NULL) #5 /usr/local/Zend/ZendFramework/library/Zend/Db/Table/Abstract.php(533): Zend_Db_Table_Abstract->_setupMetadata() #6 /usr/local/Zend/ZendFramework/library/Z in /usr/local/Zend/ZendFramework/library/Zend/Db/Statement/Db2.php on line 69

Comments

Posted by Kristof Vansant (lupus) on 2008-11-05T14:00:52.000+0000

http://publib.boulder.ibm.com/infocenter/db2luw/… maybe telling what version of DB2 you are running would be usefull

Posted by Wil Sinclair (wil) on 2008-11-25T12:35:44.000+0000

Is this still an issue? Reporter, have you tried resolving this on the mailing list?

Posted by Simon Verberne (zedmond) on 2008-12-04T07:33:01.000+0000

I had circumvented this issue by using the "temporary" Db2 adapter (located in Zendc/Db/Adapter). Yesterday I upgraded our framework to version 1.7.1 and I am getting this error again.

My ini file looks like this:
db.adapter = Db2 db.params.username = MY_USER db.params.password = ************* db.params.schema = MY_SCHEMA db.params.dbname = MY_DB

The bootstrap creates the adapter this way: $config = new Zend_Config_Ini('../application/default/configs/wtu.ini', 'development'); $db = Zend_Db::factory($config->db); Zend_Db_Table::setDefaultAdapter($db);

My system info is as follows: Zend Core Version 2.6.0 PHP Version 5.2.6 Zend Engine Version 2.2.0 Server API apache2handler PHP Configuration File /usr/local/Zend/core/etc/php.ini Server Name 127.0.0.1 Server Software Apache/2.2.6 (Unix) Zend Core/2.6.0 PHP/5.2.6 OS Version OS400 LAB 4 5 0010000907DD Server Port 8000

Posted by Ralph Schindler (ralph) on 2008-12-04T07:45:19.000+0000

Hey Simon,

Can you try this code from standard library trunk: http://framework.zend.com/code/changelog/…

Specifically the DB2 adapter in there.

Posted by Ralph Schindler (ralph) on 2009-01-11T21:42:17.000+0000

is this still an issue? have you had a chance to try the adapter in 1.7.2?

Posted by Ralph Schindler (ralph) on 2009-01-11T21:42:46.000+0000

please reopen if this is still an issue

Have you found an issue?

See the Overview section for more details.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts