*
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
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ibatis query problem