Hi Shalin:
yes i tried with batchSize="-1" parameter as well
here the config i tried with
<dataConfig>
<dataSource type="JdbcDataSource" batchSize="-1" name="sp"
driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/mydb_development"
user="root" password="******" />
<document name="items">
<entity name="item" dataSource="sp" query="select * from items">
<field column="id" name="id" />
<field column="title" name="title" />
</entity>
</document>
</dataConfig>
I hope i have used batchSize parameter @ right place.
Thanks!
Mani Kumar
On Tue, Apr 14, 2009 at 11:24 AM, Shalin Shekhar Mangar <
[email protected]> wrote:
> On Tue, Apr 14, 2009 at 11:18 AM, Mani Kumar <[email protected]
> >wrote:
>
> > Here is the stack trace:
> >
> > notice in stack trace * "at
> > com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1749)"*
> >
> > It looks like that its trying to read whole table into memory at a time.
> n
> > thts y getting OOM.
> >
> >
> Mani, the data-config.xml you posted does not have the batchSize="-1"
> attribute to your data source. Did you try that? This is a known bug in
> MySql jdbc driver.
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
