This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread 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 Murach's Java Servlets and JSP this week in the Servlets 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
Display name
Hibernate 3: java.sql.SQLException: Field 'passwordConfirmation' doesn't have a default value
parameter not set!
wild cards in MySQL using jdbc
InternalResourceViewResolver failing JUnit test -- Spring Demo Source