From: Patrick B. D. <uf...@vi...> - 2003-06-25 17:31:40
|
The java -Xmx128m does not work because the table is still too big to fit in memory. Adjusting the heap isn't a substitute dynamic cursors because the tables are still too big. On 24 Jun 2003, Don Coleman wrote: > 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 > > |