This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Object Relational Mapping and the fly likes ibatis query problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "ibatis query problem" Watch "ibatis query problem" New topic
Author

ibatis query problem

debraj mallick
Ranch Hand

Joined: Mar 08, 2011
Posts: 188

hi all

my query in sql is like:

but when i am doing the same using ibatis and spring, it is showing exception
query:
Exception:

Any suggestion would be great.
Francois Bourgault
Ranch Hand

Joined: Oct 30, 2001
Posts: 67
Hi,

We use the following format when we have variables in the where clause:

WHERE USER_ID = #userId:VARCHAR# AND SESSION_ID = #sessionId:VARCHAR#

debraj mallick
Ranch Hand

Joined: Mar 08, 2011
Posts: 188

Thanks Francois, it worked.
 
 
subject: ibatis query problem