Re: [fw-db] Zend_Db_Adapter_DB2 on I5

I've been told that there are some DB Connection issues that were fixed by
fixed by IBM PTF (program temporary fix). Can you confirm that both
machines are up to date in this regard?

-ralph

On 1/28/09 11:39 AM, "David Ulrich" <david@dahuu.fr> wrote:

> Ralph,
>
> I tested with schema too but i had the same result (on V5R3).
> I tested with getConnection() too and the result is :
>
> [28-jan-2009 18:33:37] PHP Fatal error: Uncaught exception
> 'Zend_Db_Adapter_Db2_Exception' with message 'Connexion à base de données
> relationnelle S65EA94B déjà établie. SQLCODE=-842' in
> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Db2.php:191
> Stack trace:
> #0
> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Abstract.php(300
> ): Zend_Db_Adapter_Db2->_connect()
> #1 /www/php/site/admin/public/testdb.php(15):
> Zend_Db_Adapter_Abstract->getConnection()
> #2 {main}
> thrown in
> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Db2.php on line
> 191
>
> Same script works fine on V5R4.
>
> David Ulrich
>
> -----Message d'origine-----
> De : Ralph Schindler [mailto:ralph.schindler@zend.com]
> Envoyé : mercredi 28 janvier 2009 18:11
> À : David Ulrich; fw-db@lists.zend.com
> Objet : Re: [fw-db] Zend_Db_Adapter_DB2 on I5
>
>> From the trace stack, it appears your connection is not being made
> correctly.
>
> Have you tried adding schema to your Zend_Db::factory()?
>
> I imagine it would look like so:
>
> $db = Zend_Db::factory('Db2',array(
>         'host'=>'127.0.0.1',
>         'username'=>'USERNAME',
>         'password'=>'password',
>         'dbname'=>'DATABASE',
> 'schema'=>'MYLIB'
> ));
>
> And to test, you can simply ensure this works:
>
> $db->getConnection(); // this should not fail.
>
> sidenote: connections are lazy-loaded until the first usage, so while the
> above is something good to test your connection; lazy-loading the connection
> (which is what you are doing in your scripts utilizing the table) are a good
> thing. Once you figure out why the connection is failing, remove the
> getConnection() from your bootstrap. This will prevent requests that don't
> use a db connection from actually connecting to the database.
>
>
> On 1/28/09 7:45 AM, "David Ulrich" <david@dahuu.fr> wrote:
>
>> Hi,
>>
>> I¹m trying to use Zend_Db on my I5 but I have some problems.
>> I create a little test file and test it on 2 I5 (one V5R3 and one V5R4).
>> I downloaded the latest svn trunk for testing.
>>
>> [code]
>> <?php
>> require_once "Zend/Loader.php";
>> // Set up autoload.
>> Zend_Loader::registerAutoload();
>>
>> class Alertes extends Zend_Db_Table_Abstract {
>>         /**
>>          * The default table name
>>          */
>>         protected $_name = 'MYFILE';
>>         protected $_schema = 'MYLIB';
>>         protected $_primary = 'MACLE';
>> }
>>
>> $db = Zend_Db::factory('Db2',array(
>>         'host'=>'127.0.0.1',
>>         'username'=>'USERNAME',
>>         'password'=>'password',
>>         'dbname'=>'DATABASE'));
>> Zend_Db_Table::setDefaultAdapter($db);
>>
>> // #1
>> $sql = 'select * from MYLIB.MYFILE';
>> print_r($db->fetchAll($sql));
>>
>> // #2
>> $alertes = new Alertes();
>> print_r($alertes->fetchAll());
>> ?>
>> [/code]
>>
>> On V5R3, nothing works. I got this message (as the message is in French,
>> message is : Connection to database DATABASE already done) :
>> [code]
>> [28-Jan-2009 14:33:40] PHP Fatal error:  Uncaught exception
>> 'Zend_Db_Adapter_Db2_Exception' with message 'Connexion à base de données
>> relationnelle DATABASE déjà établie. SQLCODE=-842' in
>> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Db2.php:191
>> Stack trace:
>> #0
>>
> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Abstract.php(441
> ):
>> Zend_Db_Adapter_Db2->_connect()
>> #1
>>
> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Abstract.php(668
> ):
>> Zend_Db_Adapter_Abstract->query('select * from M...', Array)
>> #2 /www/php/site/admin/public/testdb.php(16):
>> Zend_Db_Adapter_Abstract->fetchAll('select * from M...')
>> #3 {main}
>>   thrown in
>> /usr/local/Zend/ZendFramework-1.7.3/library/Zend/Db/Adapter/Db2.php on
> line
>> 191
>> [/code]
>>
>> On V5R4, the #1 works fine but not #2 wich this message :
>> [code]
>> [28-Jan-2009 11:43:53] PHP Fatal error:  Uncaught exception
>> 'Zend_Db_Statement_Db2_Exception' with message 'Qualificatif de colonne ou
>> table MYFILE non défini. SQLCODE=-5001' in
>> /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Statement/Db2.php:71
>> Stack trace:
>> #0 /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Statement.php(109):
>> Zend_Db_Statement_Db2->_prepare('select MYFILE...')
>> #1 /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Adapter/Db2.php(230):
>> Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Db2), 'select
>> MYFILE...')
>> #2
>>
> /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Adapter/Abstract.php(456):
>> Zend_Db_Adapter_Db2->prepare('select MYFILE...')
>> #3
>>
> /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Adapter/Abstract.php(668):
>> Zend_Db_Adapter_Abstract->query('select MYFILE...', Array)
>> #4 /www/alertes/public/testdb.php(23):
>> Zend_Db_Adapter_Abstract->fetchAll('select MYFILE...')
>> #5 {main}
>>   thrown in
>> /usr/local/Zend/ZendFramework-1.7/library/Zend/Db/Statement/Db2.php on
> line 71
>> [/code]
>> The sql generated by Zend_DB_Table does not work on I5.
>>
>> Did I miss something ?
>>
>> Thanks,
>> David
>>

--
Ralph Schindler
Software Engineer | ralph.schindler@zend.com
Zend Framework | http://framework.zend.com/