Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0002267 [Quercus] minor always 12-19-07 08:08 05-01-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-01-08 12:19

php/1s41
 

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


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker