RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
Seems like my question was quite confusing, so I'll try to explain what I need once again from scratch. 1. I need to process a potentially huge number of rows (so queryForList(query) is not an option because it would try to load all objects into memory at once). 2. I need to control the

Re: how to map huge resultsets?

2007-10-04 Thread Jeff Butler
Your question is not that confusing. Here are the answers: 1. No (although the approach suggested by Christopher Lamey is *very* close if you are willing to shift your paradigm) 2. If the result set is truly huge, then approach #1 is a bad idea because iBATIS will have to read through huge

Updated IDEA plug-in for iBATIS

2007-10-04 Thread Larry Meadors
Hey all, Libing Chen (a 29 year old software developer from China) posted to one of the mailing lists about an iBATIS plug-in for IDEA that he had started working on. Now that IDEA 7 is closer to release (I've been using M2 since it's release, and it's been pretty solid), and cheaper ($250 now),

un-subsribe

2007-10-04 Thread Hosamane, Chandra
Please delete [EMAIL PROTECTED] from the mailing list In accordance with applicable professional regulations, please understand that, unless expressly stated otherwise, any written advice contained in, forwarded with, or attached to

RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
Spring-Batch processes items (item = arbitrary domain object). It iteratively asks item provider for the next object and passes them to item processor for processing. Item provider and processor are just interfaces and there are provided implementations for typical inputs and outputs (flat file,

Re: how to map huge resultsets?

2007-10-04 Thread Larry Meadors
So does the Spring-Batch framework only process Lists? What are the options for feeding it? Larry On 10/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thanks for the insights Jeff. Shifting a paradigm and letting iBATIS control the flow is not an option this case, but I think

SV: Updated IDEA plug-in for iBATIS

2007-10-04 Thread erlend.bjorge
Hi there! This plugin looks great, but are you also thinking about a feature like this: Generate CRUD SQL . with default class or alias as input param ? ??? This feature should also have the possibilities to change the default query names for each CRUD operation from e.g:

Re: un-subsribe

2007-10-04 Thread Gwyn Evans
On Thursday, October 4, 2007, 2:28:07 PM, Chandra [EMAIL PROTECTED] wrote: List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] Please delete [EMAIL PROTECTED] from the mailing list See the above list headers for where you need to email to un-subscribe. /Gwyn

SV: Updated IDEA plug-in for iBATIS

2007-10-04 Thread erlend.bjorge
Hi again! To quick respons last time: We now have intentions for automatically creating result maps and all CRUD operations (insert, select, update, and delete). Yes you are planning automatically creating all CRUD operations :-) That's realy good! ... but remember the option to override the

Re: how to map huge resultsets?

2007-10-04 Thread Christopher Lamey
I think the issue is that the RowHandler would need to call back to the framework code, which might decide to not continue processing or roll the transaction back or do any number of things. My guess is that this loop: while (itemProvider.hasNext()) { Object item = itemProvider.next ();

Re: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Larry Meadors
Heh, try it out, I hope it works for you. I am a big fan of the I'll provide what I need, you provide what you need model of Open Source development. :-) Not to sound like a capitalist pig, but this is a market-driven project, and only investors get to request features. If you'd like to sponsor

Re: SV: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Lambert Torres
Any hope for a Netbeans version? =) Lambert Torres NBA Information Technology Web Technology Group 100 Plaza Drive Secaucus, NJ 07094 Ph : (201) 974-6785 Fax: (201) 974-6001 [EMAIL PROTECTED]

Re: SV: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Larry Meadors
There are 3 scenarios I can see that would make that happen: 1) Someone else wants it bad enough to write it. 2) Someone wants it bad enough to pay me to write it. 3) I start using netbeans (You will know, because there will be monkeys flying out of my butt). Larry PS: For $300, I'll give

Re: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Jeff Butler
Are you guys using Abator for code generation? If so, let me know if you want/need anything added - I'd be happy to help. BTW - Abator already allows you to override the generated DAO method names like Erland wants, but not the generated SqlMap ids. Jeff Butler On 10/4/07, Larry Meadors

Re: oracle nested table

2007-10-04 Thread Larry Meadors
Show us the SQL. Lary On 10/4/07, a b [EMAIL PROTECTED] wrote: Hi, if i have a nested table and i want to map some column within that nested table to some property of an object how can do that? thanks in advance

Re: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Larry Meadors
Nope, just StringBuilder and the DB metadata IDEA provides. I suspect as it gets used more, it'll grow into a more mature tool (unless i3 makes it obsolete), but for now, it's purpose as I see it is to simplify CRUD operation creation. I'd like to see it grow it beyond that, because I suspect I

oracle nested table

2007-10-04 Thread a b
Hi, if i have a nested table and i want to map some column within that nested table to some property of an object how can do that? thanks in advance Need a vacation? Get great deals to amazing places on

RE: Updated IDEA plug-in for iBATIS

2007-10-04 Thread Yu, Jack
I am wondering whether the plugin could support stored procedure, as I know ibator does __not___. if you have equivlent plugin on eclipse, i will be more than happy to try. Jack _ From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 12:48 PM

RE: oracle nested table

2007-10-04 Thread Yu, Jack
Yes, ibatis could work with Oracle Object in the table. If that's output parameter, you could use java.sql.Array to hold response data. If it is input, you would need to play some tricks to get Oracle Connection object and create oracle ARRAY. I am not sure whether that's the prefer way or not,

Re: Ibatis IRAD

2007-10-04 Thread Larry Meadors
Hmm, not to sound too much like I'm telling you to RTFM, but that answer is on http://ibatis.apache.org/ (the home page), which incidentally was the first response when I googled for ibatis dtd. === DTDs @ iBATIS.com - The Deed has been done (Jul 30, 2006) The DTDs hosted at iBATIS.com have been

Ibatis IRAD

2007-10-04 Thread Kani
I 'm using iBATIS 2.0 with the WebSphere6. In my sqlMapConfig file, the IRAD server complains about Unknownhost exception www.ibatis.com . ?xml version=1.0 encoding=UTF-8? !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config 2.0//EN http://www.ibatis.com/dtd/sql-map-config-2.dtd;

RE: how to map huge resultsets?

2007-10-04 Thread robert.kasanicky
Yes, you're right about the lots and lots of different kinds of stuff :) The root of the problem with queryWithRowHandler(callback) is that it's based on internal iterator and framework expects external iterator. Using some continuations voodoo it might be possible to make an external iterator

Log file location in Web application

2007-10-04 Thread Ashish Kulkarni
Hi How do we set the log file location dyanamically in web application, Currently i am using log4j.xml file with following definiation, this file is under WEB-INF file appender name=A2 class=org.apache.log4j.DailyRollingFileAppender param name=File value=C:\\Documents and Settings\\Kulkara\\My

Re: Log file location in Web application

2007-10-04 Thread Larry Meadors
http://logging.apache.org/ Larry On 10/4/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi How do we set the log file location dyanamically in web application, Currently i am using log4j.xml file with following definiation, this file is under WEB-INF file appender name=A2 class=

Re: Log file location in Web application

2007-10-04 Thread Ashish Kulkarni
Hi Can you please let me know where do i look into for this information, any hints please Ashish On 10/4/07, Larry Meadors [EMAIL PROTECTED] wrote: http://logging.apache.org/ Larry On 10/4/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi How do we set the log file location dyanamically

Re: Log file location in Web application

2007-10-04 Thread Ashish Kulkarni
Hi Sorry i send it to wrong forum, send the question to log4j forum Ashish On 10/4/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi Can you please let me know where do i look into for this information, any hints please Ashish On 10/4/07, Larry Meadors [EMAIL PROTECTED] wrote:

Unknown Column Name problem

2007-10-04 Thread Claus Hausberger
Hello I am using IBatis 2.3 with Spring and a Oracle 10g database.When I use a select query where I specify the columns I always get an Unknown column name error. But the database does not say which column. I switched one debugging output with a log4j.xml to get the SQL IBatis uses for the query.

Re: Unknown Column Name problem

2007-10-04 Thread Jeff Butler
It sounds like you should set remapResults=true in the select element. Jeff Butler On 10/4/07, Claus Hausberger [EMAIL PROTECTED] wrote: Hello I am using IBatis 2.3 with Spring and a Oracle 10g database.When I use a select query where I specify the columns I always get an Unknown column