0002267: PDO bind problem

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002267

[Quercus]

minor

always

12-19-07 08:08

05-29-08 12:19

Reporter

sergpro

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.2.0

Product Version

3.1.4

Product Build

Summary

0002267: PDO bind problem

Description

getting java.sql.SQLException: ORA-00911: invalid character exception for statement where bind is using

-- example of issue
<?php
$pdo = new PDO("java:comp/env/jdbc/db");
$query = "Insert into table_web (CLICK_ID,CAMPAIGN_ID,WSESSION_ID,URL) values (?,?,?,?)";

$DummyValue='a';
$WebSessionID='1677631';
$WebURL='localhost8080';

$stid = $pdo->prepare( $query);
$stid->bindValue( 1, $DummyValue);
$stid->bindValue( 2, $DummyValue);
$stid->bindValue( 3, $WebSessionID);
$stid->bindValue( 4, $WebURL);

$stid->execute() || die ('Error! ' . $stid->errorCode());
?>

-- but following code without binding works fine
<?php
$pdo = new PDO("java:comp/env/jdbc/db");
$query = "Insert into table_web (CLICK_ID,CAMPAIGN_ID,WSESSION_ID,URL) values ('a','a','1677631','localhost8080')";
$stid->execute() || die ('Error! ' . $stid->errorCode());
?>

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0003113) ferg 05-29-08 12:19	php/1s41

Issue History
Date Modified	Username	Field	Change
12-19-07 08:08	sergpro	New Issue
12-01-07 09:26	ferg	Project	Resin => Quercus
05-29-08 12:19	ferg	Note Added: 0003113
05-29-08 12:19	ferg	Assigned To	=> ferg
05-29-08 12:19	ferg	Status	new => closed
05-29-08 12:19	ferg	Resolution	open => fixed
05-29-08 12:19	ferg	Fixed in Version	=> 3.2.0

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.