This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Order in bind variable for PreparedStatement in Java

 
Stephane Philippart
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everybody,

Sorry for my poor english and the size of the post.

I have a critical problem with a prepared query and bind variable in Java.

I try to execute the following query which do return one row :

The tce column is a decimal, age column a varchar and cli a varchar


with the following values :

No rows are returned.

If I don't respect the order of the bind variable like this :

The correct row is returned.

I am confused because it seems that the jdbc driver bind the variable first in the inner join and after in my case ... when inspite their order in the query.

The same query work perfectly under Oracle whit the good order for the bind variables.

My informix database is 9.40.UC2
My Jdbc informix driver is 2.21.JC5

If anybody have an explaination.

thanks

Stef
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Stef,
Sounds like a bug in the driver. Are there any other Informix drivers you can use?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic