Re: dynamic resultmap?

On Tue, Oct 21, 2008 at 6:36 PM, Josh Joy <[EMAIL PROTECTED]> wrote: > Is this possible? Yes. :) Larry PS: look into the and elements.

dynamic resultmap?

I need two different resultmaps/resultclass. One resultclass is an "int" for when I do a select count(*). The second is a resultmap for the actual query. The query is being filtered (using various where clauses). I need to reuse this sql fragment for the paging with filtering as well as the count

Re: help ! please !!!!

English please!! 2008/10/21 Carlos de Luna Saenz <[EMAIL PROTECTED]> > No te entendí, si quieres mandame a mi correo personal un mail y veo si > puedo ayudarte. > saludos. > > - Mensaje original > De: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Para: user-java@ibatis.apache.org > Enviado:

Re: help ! please !!!!

No te entendí, si quieres mandame a mi correo personal un mail y veo si puedo ayudarte. saludos. - Mensaje original De: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Para: user-java@ibatis.apache.org Enviado: martes, 21 de octubre, 2008 12:08:43 Asunto: help ! please i have the follow

dynamic CREATE TABLE woe

Hi all, I encountered a 'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException' while executing the following SQL script: CREATE TABLE data $[].name$ $[].type$ The java code that prepare the list parameter and execute the SQL script is

Re: Avoid java heap space while using iBatis

HI Ankit, I would do a loop, fetching lesser number of rows each time. I had a similar requirement, when I had to do a bulk fetch (basically a nightly job which had to create a lucene index) and I saw Ibatis was caching all the rows and not freeing up the cache which resulted in an O

RE: Avoid java heap space while using iBatis

Michael, Thats true. We are using the complete data set and plotting it to flex. I am trying to handle this using some logic that can give me limited set of data for calculation in spring in segements. Regards Ankit From: Michael Schall [mailto:[EMAIL PROTECTED]

RE: Avoid java heap space while using iBatis

Larry, Using the query for list in loop will allow me to fetch limited set of record per DB call and at the same time executing the logic with the available set. Let me know your thoughts Regards Ankit -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Tuesday, Octobe

RE: Avoid java heap space while using iBatis

Thanks Jiming, This solution looks good.. I will try implement this. Thanks & Regards Ankit From: Jiming Liu [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 8:49 PM To: user-java@ibatis.apache.org Subject: Re: Avoid java heap space while using iBatis

Re: help ! please !!!!

ibatis can't handle this automatically for you. If you don't want to write the loop in your dao layer by yourself I guess you need to switch to JPA / Hibernate. Regards Kai --- Original Nachricht --- Absender: [EMAIL PROTECTED] Datum: 21.10.2008 19:08 > i have the followin object graph !! >

help ! please !!!!

i have the followin object graph !! class Persona { int id_per; String name; List domi; } class Domicilio { int id_per; int id_domi; String street; etc... some other propertis } it is posible for example code ? Persona p = new Persona(1,"pepe") p.getDomicil

Re: duplicate databases

If I get it right you need to execute same statements to multiple (two) databases. Have a look at http://ha-jdbc.sourceforge.net/. I have NOT used it, but it seems to be an easy and transparent way to achieve what you need.

Re: Avoid java heap space while using iBatis

I suggest you can write/dump the records to a temp file and then implement an Iterator to read the record one after another. from the file. Best regards, Jiming Liu On Tue, Oct 21, 2008 at 10:30 PM, <[EMAIL PROTECTED]> wrote: > Hi, > > Our project is facing a java heap space issue while fetchi

Re: Avoid java heap space while using iBatis

Are you really using all 200,000 data points in your graphs or are you summarizing? Can you use SQL to generate summery information and graph that? On Tue, Oct 21, 2008 at 9:45 AM, Larry Meadors <[EMAIL PROTECTED]>wrote: > Why do you think queryForList in a loop will work better? > > Larry > > >

Re: Avoid java heap space while using iBatis

Why do you think queryForList in a loop will work better? Larry On Tue, Oct 21, 2008 at 8:30 AM, <[EMAIL PROTECTED]> wrote: > Hi, > > Our project is facing a java heap space issue while fetching the record set > of around 200,000. > Using a row handler is not helpful as the same record set is b

RE: Avoid java heap space while using iBatis

hi! this might not be your help wanted.. but i think about 200,000 record set...selecting them at once?? will not be a good idea i think.. i have no idea why you are implemented that way and also i suggest you to check your heap profile first just suggesting ... sorry if this doesn't hel

Avoid java heap space while using iBatis

Hi, Our project is facing a java heap space issue while fetching the record set of around 200,000. Using a row handler is not helpful as the same record set is being used to plot a slider and three graphs on UI (Flex). increasing the heap space size is not allowed in our application as it is a st

duplicate databases

Precondition: I know this is a screwy set up. But, it is, what it is. What I need, are ideas for dealing with it, and any heads up dor potential nightmares. We have two databases that are supposed to remain synchronized. For some reason, there is no abstraction layer (hardware or otherwise) that p