Page 1 of 1

PDO prepare statement cache problem

Posted: Thu Oct 31, 2019 9:58 am
by padelaunay
hi ,
we have a probleme with PDO and prepare statement

we are building a web application on php and ibm I V7R3
the php is on linux server and we connect to the IBM I with the unix odbc connecter
and we have a problem when we change structure of file
the resultset of the request seems to take the old description
when we change the request it's work :

example :
we have a file : client

Code: Select all

 client Code |name|surname | 
we make this request :

Code: Select all

 select * from client  where name = :name  
all work fine
we change the file :

Code: Select all

 client Code |name|surname |adresse 
and the same request make resultset "strange"
when we change the request like :

Code: Select all

 select * from client  where 1= 1 and name = :name  
it's work

if we rechange the request like that :

Code: Select all

 select * from client  where name = :name  
it's doesnt work

i think the problem it's the prepare cache

can we clear the cache ?
where is that cache ? on php server ? on IBM I ?

someone have an idea ?
thanks all