Re: iBATIS in Indianapolis

On Mar 1, 2007, at 5:31 PM, Ted Schrader wrote: Hi Mark, Thanks for the link to your Abator page, but unfortunately it's coming up blank for me (both IE and FFox). Oops! I've fixed it. Try http://www.ociweb.com/mark/Abator.html again. (Good luck in the Little Rock Marathon this Sunday, by

How to suppress log files created by ibatis

Hi I have a application running on AS400 using ibatis, i am using Log4J for logging, i am getting a lot of log in my spool file. for preparedStatement created, resultset etc, How do i suppress these logs from my Log4j.properties file which i use to set logging in my application. Ashish

RE: How to suppress log files created by ibatis

Put '#' before these entries in your log4J.properties file log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG

Re: Avoiding N+1 Selects

No. Larry On 2/28/07, Brad Handy [EMAIL PROTECTED] wrote: I think I could use a row handler to arrange the objects in a situation like this. One question I have: Do the results of a query with a custom RowHandler still get cached when using OSCache? Brad On 2/22/07, Brad Handy [EMAIL

Re: Simple question...

If this is for a new project, don't use the iBATIS DAO, use spring instead. The iBATIS DAO is deprecated, and using Spring gives you a lot more options. Larry On 3/1/07, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Having examined the DTD, it's actually illegal, but not enforced. I have tried

Syntax for getter variables in a POJO

I am trying to figure out the magical syntax for POJO's in getter/setters. I have a database column called product_id, another called p_sequence. What do these map to in a POJO getter/setter? Seems the underscore causes some problems. I have had to do some aliases to make them work (i.e.

RE: Syntax for getter variables in a POJO

These should map respectively to pSequence and productId. Chris -Original Message- From: Collin Peters [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 12:11 PM To: user-java@ibatis.apache.org Subject: Syntax for getter variables in a POJO I am trying to figure out the magical

M:N select and groupBy

Ok, I may be referring to the concept inaccurately as I'm not an sql guru (non available so the work falls to me). I'm trying to accomplish the following query: resultMap id=totalsByHourResults class=Statistics groupBy=timestamp result property=timestamp column=timestamp / result

Re: Using an array instead of a List

I'm not sure if I follow. After looking over the iterate tag, it looks like it is only for adding dynamic SQL *into* a select statement. I am looking for a way to get data *out of* a select statement and into a Java array. Do you have any examples or links of what you mean? On 3/2/07, Poitras

Adding a sql map at run time

Hi all, Does anyone have any pointers for how I would add a sql map to the SqlMapClient at runtime. I'm writing a GUI that lets a use enter a piece of SQL and I'm using iBATIS to do the heavy lifting of mapping my java parameters to the sql and executing it and doing the return mapping.

Re: iBatis and entity-attribute-value style tables

Hi Collin, If you can do it with straight-up JDBC, you can probably do it with iBATIS. I sense you may be looking for some magic in the form of avoiding N+1 selects. Based on your example, perhaps the following two value objects are called for: UserVO Integer id; String firstName;

Re: Using an array instead of a List

Hi Ted, I believe since the List still exists in the VO, Axis will complain. You would essentially end up having two versions of the VO which would wreck havoc on having proper code using the services (i.e. you essentially would have to have two versions of everything) So does this mean that

Re: Using an array instead of a List

Hi Collin, I must admit I have not worked with web services, so having a List-backed array may not be a good fit. This pattern seems to work pretty well for me in sending objects to JSPs for rendering, though. In regards to iBATIS not supporting arrays, in a way you are right because you will

Re: Just Another Stored Procedure Question

For stored procedure calls that return a value, don't we have to use JDBC syntax like this: {? = call EKA.SISTEM_KONTROL_SPAJ.GENERATE_COUNTER (?,?,?,?,?,?)} The leading ? receives the value. Perhaps this is why result and hasil have no value. Replace the ?'s with your iBATIS parameters and

Re: Syntax for getter variables in a POJO

+1. Yep, you can either use column aliases or a result map. On 3/2/07, Ted Schrader [EMAIL PROTECTED] wrote: Hi Collin, So setProduct_id() and setP_sequence() wouldn't work? Regardless, if I understand the recommeneded iBATIS way of doing things, your situation would be an excellent case