RE: Cache entire table for use in an application

2005-11-23 Thread Meindert
Hi ooper,   There is a smart alternative to the use of parent child relation and the resulting recursive queries; The Nested Set Model.   http://dev.mysql.com/tech-resources/articles/hierarchical-data.html     MEINDERT HOVING From: ooper [mailto:[EMAIL PROTECTED] Sent: 23 Nove

Re: how can i get attribute from inbed object?

2005-11-23 Thread Alex Chew
Sure. log4j-1.2.8.jar and commons-loggin-1.0.4.jar are there. my IDE is eclipse  On 11/24/05, Larry Meadors <[EMAIL PROTECTED]> wrote: Is the log4j.jar in WEB-INF/lib?LarryOn 11/23/05, Alex Chew < [EMAIL PROTECTED]> wrote:> nothing changed. :(> following is my log4j.properties>> # Global logging c

Re: how can i get attribute from inbed object?

2005-11-23 Thread Larry Meadors
Is the log4j.jar in WEB-INF/lib? Larry On 11/23/05, Alex Chew <[EMAIL PROTECTED]> wrote: > nothing changed. :( > following is my log4j.properties > > # Global logging configuration > log4j.rootLogger=DEBUG, stdout > > > # SqlMap logging configuration... > log4j.logger.com.ibatis=DEBUG > log4j.lo

Re: how can i get attribute from inbed object?

2005-11-23 Thread Alex Chew
nothing changed. :( following is my log4j.properties   # Global logging configurationlog4j.rootLogger=DEBUG, stdout # SqlMap logging configuration...log4j.logger.com.ibatis=DEBUGlog4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUGlog4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUGlog4j.lo

Re: how can i get attribute from inbed object?

2005-11-23 Thread Larry Meadors
On 11/23/05, Alex Chew <[EMAIL PROTECTED]> wrote: > by the way, how can i turn log4j on in web application(WAR)? > i tried to put my log4j.properties in WEB-INF/, but no logs displayed on > console Put it in WEB-INF/classes instead. Larry

Re: how can i get attribute from inbed object?

2005-11-23 Thread Alex Chew
Thanks, Michael     Yes, it is a spell mistake. But there is no such mistakes in my application. what i want is i can create an Account with specified user like this:     Account account = new Account();     account.setHandledby(user);//pre got User     account.setDeposit(new Double(0));     Accoun

java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded

2005-11-23 Thread Vio Stan
Hello   I have to load, process and save arround 100,000 rows. In order to do this I set a batch size to 1000 (can increase or decrease this value) so I process, for example 100 times x 1000 records. So, in one operation I have to save, let say, 1000 records. In order to do this I use batc

Lazy Loading, am I missing something?

2005-11-23 Thread Vinny
I'm trying out the lazy loading feature (I'm using 2.1.5) under jdk 1.42. my setting look like: and I put the cglib-nodep-2.1_3.jar from sf.net into WEB-INF/lib (this is a Struts 1.2.7 project by the way, no Spring involved) restarted my webapp and it is extremely slow now, I'm thinking that

Re: how can i get attribute from inbed object?

2005-11-23 Thread Michael Campbell
On 11/23/05, Alex Chew <[EMAIL PROTECTED]> wrote: > > > Do you mean there should have such a field like > private Long handlebyId; > and i should prepare the data? > It seems some strange. Yes, I misunderstood your initial question. My apologies. See below. > > > > > insert into ACCOUNT

Re:Cache entire table for use in an application

2005-11-23 Thread ooper
I'm investigating hsqldb (www.hsqldb.org) right now. It appears to have the functionality I am looking for, i.e., in-memory db capabilities.Thanks everyone for your input.BrianBroadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com*Your* clubs, no sign up to read

Re: Cache entire table for use in an application

2005-11-23 Thread Larry Meadors
If the data is static (and it sounds like it is), why not just build the tree when your app starts, and work with it that way? Larry On 11/23/05, ooper <[EMAIL PROTECTED]> wrote: > I have a recursive function that builds a tree menu from data in the db. The > recursive function executes > a sql

Re:Cache entire table for use in an application

2005-11-23 Thread ooper
I have a recursive function that builds a tree menu from data in the db. The recursive function executes a sql query against the database for each node of the tree, so as the tree gets larger, the time needed to build it becomes larger. In an effort to enhance performance, I wanted to pull data int

FW: First sqlMap causing Parse Errors Please Assist

2005-11-23 Thread Niels Beekman
Forwarding to the list: Anyone knows if the Developer Guide is up-to-date on this? Niels -Original Message- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: woensdag 23 november 2005 15:26 To: Niels Beekman Subject: RE: First sqlMap causing Parse Errors Please Assist Thanks for the

Re: Cache entire table for use in an application

2005-11-23 Thread Larry Meadors
What are you trying to accomplish? Larry On 11/22/05, ooper <[EMAIL PROTECTED]> wrote: > Is there a nice way to load an entire table into memory and then execute > queries against what's in memory instead of executing queries against the > database? > (I'm using SQLServer.) > > TIA, Brian Barnet

Re: groupBy / N+1 problem

2005-11-23 Thread Clinton Begin
Did you upgrade the version of iBATIS that comes with JPetStore? FYI for all:  I'm in the process of heavily refactoring JPetStore, as it's in great need of some TLC. Cheers, Clinton On 11/23/05, Daniel Wintschel <[EMAIL PROTECTED]> wrote: Hi all,I've been fiddling around with JPetStore, trying

groupBy / N+1 problem

2005-11-23 Thread Daniel Wintschel
Hi all,I've been fiddling around with JPetStore, trying to add an example that performs a groupBy - in order to demonstrate the 'solution' to the N+1 problem. I have this working in a completely different application that I wrote, but for some reason, this is giving me grief. I've been at it for ab

Re: how can i get attribute from inbed object?

2005-11-23 Thread Alex Chew
  Do you mean there should have such a field like private Long handlebyId; and i should prepare the data? It seems some strange.   >  > insert into ACCOUNT (ID,NAME, DEPOSITE, FK_HANDLEBY)> values (#id#, #name#, #deposit#, #handleby.id#) >   in my opinion, handleby.id here  should be explai