Re: [Jython-users] zxJDBC dynamic cursor not working with MySQL.

[Don C. <dco...@ch...>]

I'm not sure how to fix the problem, but you might consider increasing
the max heap size in your jython script.  java -Xmx128m -Dpython.home...

On Tue, 2003-06-24 at 17:49, Patrick B. Day wrote:
> Hello,
> 
> I'm trying to create a little app to export data from a MySQL server. Some
> of the tables are quite large and I'm getting an out of memory error when
> doing a fetchone() even when using a dynamic cursor. Is there some trick
> to this? Here is my test program:
> 
> from com.ziclix.python.sql import zxJDBC
> 
> conn =
> zxJDBC.connect('jdbc:mysql://alpha/','noone','','org.gjt.mm.mysql.Driver')
>  
> curs = conn.cursor(1) 
> 
> print 'cursor is', curs.dynamic and 'dynamic' or 'static'
> 
> curs.execute('select * from chqs.allcodes')
> curs.fetchone()
> 
> 
> The above test program prints "cursor is dynamic" and eventually runs out
> of memory. Thanks for your help.
> 
> -Pat.
> 
> ============================
>  
> Patrick Day
> uf...@fr...
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Jython-users mailing list
> Jyt...@li...
> https://lists.sourceforge.net/lists/listinfo/jython-users