Re: LargeSelect example ?

2007-10-25 Thread YannickR
Yannick Richard wrote: Thomas Vandahl-2 wrote: Yannick Richard wrote: Hi, I am currently working on a Torque project that will handle database synchronization. The problem we have is an Out of Memory exception while selecting a big bunch of data from the database.

RE: Change JDBC to Java map

2007-10-25 Thread Greg Monroe
One quick solution comes to mind. If you don't need to use the SQL generated by Torque, you can just define your NUMERIC(9) fields as INTEGER or BIGINT in the XML. This should generate get/set methods that for long instead of BigDecimal. JDBC (or maybe Village) will manage the conversion when

Re: Wrong SQL generation from Criteria

2007-10-25 Thread Brendan Miller
Sorry to repost, but any thoughts on this? I'm getting this again (wrote some more code like the above), this time without any addAscending...: Criteria crit = new Criteria(); crit.addJoin(TransactionPeer.ORDER_ID, OrderPeer.ID); crit.add(TransactionPeer.ACCT_ID, account.getID());