aspose file tools*
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 Spring in Action this week in the Spring 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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ibatis query problem