Re: Recursive Select in SqlMap throws java.sql.SQLException: Exhausted Resultset

2009-02-27 Thread zkn
Just a guess: could the problem be when selecting the root node because parent_id is null? On 25.02.2009, at 16:50, Sean Barbridge wrote: Hi Guys, This is the first time I used Ibatis in a project and I'm stucked on this error. "Exhausted Resultset". My problem started when i designed my

division by zero with ibator in eclipse

2009-03-01 Thread zkn
Hi, I'm getting "/ by zero" when trying to run ibator in eclipse. Here is the full stack trace: 01.03.09 22:33:16 [0x0-0xbf0bf].org.eclipse.eclipse[933] java.lang.ArithmeticException: / by zero 01.03.09 22:33:16 [0x0-0xbf0bf].org.eclipse.eclipse[933] at org .apache .ibatis .ibator .e

Re: division by zero with ibator in eclipse

2009-03-01 Thread zkn
Thanks for the quick reply. On 01.03.2009, at 23:41, Jeff Butler wrote: I'm sorry for your trouble - I'll fix the divide by zero error. This is happening because there are no tables in the database that match the configuration you've given. I think that you should remove the schema="" attrib

Re: division by zero with ibator in eclipse

2009-03-02 Thread zkn
n the database specified in the connection URL. Jeff Butler On Sun, Mar 1, 2009 at 5:30 PM, zkn wrote: Thanks for the quick reply. . On 01.03.2009, at 23:41, Jeff Butler wrote: . I'm sorry for your trouble - I'll fix the divide by zero error. This is happening because there are n

Re: read large result set in Ibatis3

2010-02-25 Thread zkn
Why not use limit and offset and work on a small subset instead of loading a large result set? I believe this would be a better approach. On 17.01.2010, at 01:54, Tomáš Procházka wrote: > > Hi. > > I need read large result set from DB (like 300 000 rows). > > It's possible use this: > > @Sel

Re: read large result set in Ibatis3

2010-02-25 Thread zkn
can't > control everything). > ciao, >Giovanni > > > > "You don't know the power of dark side" - Darth Vader > > > > On Thu, Feb 25, 2010 at 11:42 AM, zkn wrote: >>

Re: read large result set in Ibatis3

2010-02-25 Thread zkn
how it works. Sorry again if my suggestions was off-topic. On 25.02.2010, at 13:00, Martin Ellis wrote: > On 25 February 2010 10:53, zkn wrote: >> I use limit and offset exactly for this purpose. I think it's much better >> for the application and the database server to ge