Two Laptop Bag*
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 Java 8 in Action this week in the Java 8 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ibatis query problem
 
Similar Threads
Hibernate 3: java.sql.SQLException: Field 'passwordConfirmation' doesn't have a default value
InternalResourceViewResolver failing JUnit test -- Spring Demo Source
Display name
wild cards in MySQL using jdbc
parameter not set!