|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2013-01-29 11:36 UTC] gfratzke at arz-emmendingen dot de
Description:
------------
An error occurs when trying to fetch Informix-Lvarchar-Data with IBM-PDO:
Zend_Db_Statement_Exception: (7006) SQLSTATE[07006]: Restricted data type attribute violation: -99999 [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006 (SQLFetchScroll[-99999] at /builddir/build/BUILD/PDO_IBM-1.3.2/ibm_statement.c:1156)
Informix Dynamic Server 11.70.FC5
Test script:
---------------
$sql = 'SELECT field FROM table WHERE field_id = :fieldId';
$stmt = $this->db->prepare($sql);
$stmt->bindParam(':fieldId', $fieldId);
$stmt->execute();
$stmt->fetch();
Patchesadd-long-varchar-support (last revision 2013-01-30 13:33 UTC by cloeffler at arz-emmendingen dot de)Pull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 06:00:01 2025 UTC |
The given test case relies on components of the Zend Framework. Simple test case: ----------------- //CREATE TABLE // newTestTable // ( // col1 INTEGER, // col2 lvarchar, // PRIMARY KEY (col1) // ) //INSERT INTO newTestTable (col1, col2) VALUES (1, 'Das ist ein langer Text. Das ist ein langer Text. Das ist ein langer Text.'); $dbh = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=ourhostname;PORT=1234;DATABASE=dbname;PROTOCOL=TCPIP;", "", ""); print "Connection Established!\n"; print "Driver name: " . $dbh->getAttribute(PDO::ATTR_DRIVER_NAME) . "\n\n"; $stmt = $dbh->prepare("select col1, col2 from newTestTable where col1 = 1;"); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { print_r($row); print "\n"; } print "After Fetch\n"; print "PDO Error: " . $dbh->errorCode() . "\n"; print_r($dbh->errorInfo()); print "\n"; print "Statement Error: " . $stmt->errorCode() . "\n"; print_r($stmt->errorInfo()); print "\n"; $dbh = null; Output: ------- Connection Established! Driver name: ibm After Fetch PDO Error: 07006 Array ( [0] => 07006 [1] => -99999 [2] => [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006 (SQLFetchScroll[-99999] at /builddir/build/BUILD/PDO_IBM-1.3.2/ibm_statement.c:1156) ) Statement Error: 07006 Array ( [0] => 07006 [1] => -99999 [2] => [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006 (SQLFetchScroll[-99999] at /builddir/build/BUILD/PDO_IBM-1.3.2/ibm_statement.c:1156) )