0002267: PDO bind problem

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

3.1.4

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());
?>

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-31-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.