You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Amit Rana <ra...@solis.jp> on 2003/10/06 09:04:52 UTC
datadump task
Hi,
I have a table with 29230 rows when I run "datadump" task it
fails giving out of memory. Are there any workarounds?
Regards,
Amit.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Torque in Web Apps / another questions
Posted by Sven Haiges <sh...@flavor.de>.
I just recognized some strange behaviour:
I reloaded the Struts Action several times which must have resulted in
several consecutive calls to a peer.doSelect.... from the Business Delegate
of my Web Application. After 2 or3 times, everything was working again...
it seemed like torque refreshed the connections.
again a snapshot from the torque.properties:
## Using commons-dbcp
#torque.dsfactory.xmas.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.xmas.factory=org.apache.torque.dsfactory.PerUserPoolDataSourceFactory
torque.dsfactory.xmas.pool.defaultMaxActive=10
#torque.dsfactory.xmas.pool.testOnBorrow=true
-->testOnBorrow would probably help, but when using this option Torque
won't work with my MySQL-Driver any more.
( I assume, that this option chekcs if the conneciton is alive and creates
a new one if this is not the case...)
#torque.dsfactory.xmas.pool.validationQuery=SELECT 1
torque.dsfactory.xmas.connection.driver = com.mysql.jdbc.Driver
Any more ideas? THX,
Sven
RE: datadump task
Posted by Amit Rana <ra...@solis.jp>.
Thanks William, I was able to take the datadump after increasing the
memory size.
Regards,
Amit.
> -----Original Message-----
> From: William Kemper [mailto:wkemper@franchise.com]
> Sent: Tuesday, October 07, 2003 12:48 AM
> To: Apache Torque Users List
> Subject: Re: datadump task
>
> You could increase the memory available to ant with:
> $ export ANT_OPTS=-Xmx256M
>
> On Monday 06 October 2003 3:06 am, Amit Rana wrote:
> > Is there a way to take datadump of selected tables only?
> >
> > Regards,
> > Amit.
> >
> > > -----Original Message-----
> > > From: Amit Rana [mailto:rana@solis.jp]
> > > Sent: Monday, October 06, 2003 4:05 PM
> > > To: 'Apache Torque Users List'
> > > Subject: datadump task
> > >
> > > Hi,
> > >
> > > I have a table with 29230 rows when I run "datadump" task it
> > > fails giving out of memory. Are there any workarounds?
> > >
> > > Regards,
> > > Amit.
> >
> >
---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: datadump task
Posted by William Kemper <wk...@franchise.com>.
You could increase the memory available to ant with:
$ export ANT_OPTS=-Xmx256M
On Monday 06 October 2003 3:06 am, Amit Rana wrote:
> Is there a way to take datadump of selected tables only?
>
> Regards,
> Amit.
>
> > -----Original Message-----
> > From: Amit Rana [mailto:rana@solis.jp]
> > Sent: Monday, October 06, 2003 4:05 PM
> > To: 'Apache Torque Users List'
> > Subject: datadump task
> >
> > Hi,
> >
> > I have a table with 29230 rows when I run "datadump" task it
> > fails giving out of memory. Are there any workarounds?
> >
> > Regards,
> > Amit.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: datadump task
Posted by Amit Rana <ra...@solis.jp>.
Is there a way to take datadump of selected tables only?
Regards,
Amit.
> -----Original Message-----
> From: Amit Rana [mailto:rana@solis.jp]
> Sent: Monday, October 06, 2003 4:05 PM
> To: 'Apache Torque Users List'
> Subject: datadump task
>
> Hi,
>
> I have a table with 29230 rows when I run "datadump" task it
> fails giving out of memory. Are there any workarounds?
>
> Regards,
> Amit.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org