Re: Best practice for using Ibatis in Web application

2008-12-03 Thread Larry Meadors
I'm looking at google guice + stripes + ibatis (ashamed to say it was Brandon and Nathan's idea though). Virtually zero configuration. It just works. Larry

Batch execution of stored procedures

2008-12-03 Thread sh33dafi
Hello, I'm trying to batch execute some stored procedures that will insert data into a table. I've followed the instructions in the JavaDoc and I think the following code has to work: getSqlMapClientTemplate().execute(new SqlMapClientCallback() { public Object

Can't delete without the setter method

2008-12-03 Thread Michael He
if i don't set the setter method of the keyword-column property in a javabean,then i can't delete it using this property? for example: the javabean: public class JobPosting implements Serializable { private int jobPostingId; //missing other properties... ...

Re: using different datasource type for same datasource

2008-12-03 Thread terranceraphael
terranceraphael wrote: Hello, Basically my app can run in web as well as batch mode. Web uses JNDI Datasource and Batch mode does not use any datasource. Since all the sql-maps are one and the same for both the modes, I was wondering how I can avoid having two config files ( one for

Re: Best practice for using Ibatis in Web application

2008-12-03 Thread Rick
@Ashish You can look at Larry's old struts-spring-ibatis for basic web app setup: http://learntechnology.net/content/ibatis/spring_ibatis.jsp @Larry I did liked guice when I looked at it, but how does it help with iBATIS - I doubt it comes with and sqlMapClientTemplate? On Wed, Dec 3, 2008 at

howto do iteration with UNION

2008-12-03 Thread xianwinwin
Hi there, problem: I wish to get the production of a client through different period of times. the simple most sql will be: *** SQL ** SELECT client_ID, SUM(production) , #date1# AS start_date, #date2# AS end_date FROM client_production WHERE client_ID=33293 AND

Re: blob type support...

2008-12-03 Thread Jeff Butler
The error message states that the database type and the java type are not compatible with iBATIS default type handling. 1. What is the DB field type for IMAGEN? 2. What is the Java type for the imagen property in the result class? Jeff Butler On Wed, Dec 3, 2008 at 8:17 AM, Betto McRose Gamarra

Immutable objects in ResultMaps

2008-12-03 Thread Dan Turkenkopf
Maybe I'm just missing something, but I thought that iBATIS required the objects used in a result map to have declared setters. I was in the process if I could figure out a way to use a builder pattern to get immutable objects through iBATOR and was working my way through a sample application.

Re: Immutable objects in ResultMaps

2008-12-03 Thread Jeff Butler
See the release notes for version 2.2.0 - Clinton added support for private properties in August 2006! :) Jeff Butler On Wed, Dec 3, 2008 at 7:25 PM, Dan Turkenkopf [EMAIL PROTECTED] wrote: Maybe I'm just missing something, but I thought that iBATIS required the objects used in a result map to

Re: Immutable objects in ResultMaps

2008-12-03 Thread Dan Turkenkopf
Wow.. I guess I did miss it. For some reason Google wasn't my friend. I could only find people asking for it, and no record of it being given. :) Thanks, Dan On Wed, Dec 3, 2008 at 8:57 PM, Jeff Butler [EMAIL PROTECTED] wrote: See the release notes for version 2.2.0 - Clinton added support