[PHP-DB] DB2 and php serialized data
Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you offlist. Thanks for any advice/tips you may provide... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] DB2 and php serialized data
Gerard Samuel wrote: Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you offlist. Thanks for any advice/tips you may provide... I did a few more tests last night, and the problem isn't with serialized data. Im currently testing to see if a result contains returned data by issuing odbc_num_rows() The wierd thing is that if I try to select a CLOB column (this is what Im using at the moment, but I believe it applies to all LOBs), odbc_num_rows() would return -1 If I do not select a CLOB (ie INTEGER, VARCHAR this is what Im currently testing with) column, odbc_num_rows() would return the correct number of rows. I've read about odbc_num_rows() returning -1 for some databases, but that statement alludes me to believe that it either works, or doesn't work for a database. Not whether it will work for some sql conditions. So Im not sure if this is a bug or not. Im currently testing with PHP 4.3.3R2, IBM DB2 8.1 Personal Edition on win2k/IIS 5 If what Ive noticed is the expected behaviour, please let me know so I'll know whether or not to fill out a bug report... If anyone wants more information, please let me know... Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] db2 with php
I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file or directory" when I try to load the php4 module. libdb2.so.1 exists in /home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can anyone help me with this? Default installation of DB2 under redhat failed to properly setup automatically the environment at reboot (at least for me), so that I had to manually set it. There is a script file that does this under the instance dir. Try "source /home/db2inst1/sqllib/db2profile" If after that all works, you can put that in rc.local or wherever you feel it could be its place :-) HTH, bye Fabrizio /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini Alternate E-mail: C.so Umberto, 7 [EMAIL PROTECTED] loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] db2 with php
Well, if it says that it's looking for it in /etc/httpd/modules then it's obviously not looking in /home/db2inst1/sqllib/lib, eh? Try a symlink... "ln -s /home/db2inst1/sqllib/lib/libdb2.so.1 /etc/httpd/modules/libphp4.so/libdb2.so.1" Or copy the library. Or I think you can add a line into /etc/ld.so.conf too. -Szii At 11:08 PM 2/4/2001 -0500, Chris Book wrote: Hello, I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file or directory" when I try to load the php4 module. libdb2.so.1 exists in /home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can anyone help me with this? Thanks, Chris Book [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]