|
osdir.com mailing list archive |
|
Subject: Re: Jython program hangs - msg#00008List: lang.jython.user<PrashantPatil@xxxxxxxxxxxxxxxxxxxxxxxx> wrote: > > Generally I don't have problem reading data and storing but for larger > data, my program hangs when I am trying to insert XML message to database. > Database guys are saying I am doing something wrong with memory and there > are no locking blocks at oracle. > > Also I am using java.sql class for creating connection, statement, > resulteset. > > Does anybody face this kind of problem? > Are you getting any sort of error message? If so, can you paste it here for us? When your program hangs if you just leave it running does it eventually give an error? What is your method of reading/writing the data? Do you read it all out and then put it all into the next place or do you read one section, write that section, destroy variables used and start over? I've had problems running out of memory when reading/writing large amounts of data to databases with Jython, but in those cases I get "JVM: out of memory" kinds of messages. The solution was multifold: the first step was to increase the -Xmx flag in my Jython command line for that script the second step was to look carefully at all of the variables I was creating in the script and make sure that they weren't inefficient (I was storing a JDBC recordset into a Jython dictionary - that's a "bad idea" in terms of memory). Hope this helps, Greg ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl Thread at a glance:
Previous Message by Date: click to view message previewJython program hangsHello, I am using jython for ETL processing for transforming data from oracle database to xml messages. Once I convert to xml messages I store information Generally I don't have problem reading data and storing but for larger data, my program hangs when I am trying to insert XML message to database. Database guys are saying I am doing something wrong with memory and there are no locking blocks at oracle. Also I am using java.sql class for creating connection, statement, resulteset. Does anybody face this kind of problem? Thanks Prashant ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl Next Message by Date: click to view message previewa new Jython wikiI'm happy to announce the creation of a new Jython wiki. http://www.jython.org/cgi-bin/wiki Bill Dehora has generously donated his time to put together the new site as well as seed it with a lot of quality pages. We're hoping this will be an ongoing process whereby we can collect information, such as the recently written developer's guide, all in one place. We still need to migrate the FAQ as well as update it with any new entries. Recently on the jython-users list there have been questions about J2ME, JDK1.5, memory, the classpath and many more issues which have been answered and should be preserved. As we move forward it's the hope the wiki will provide this forum. For the time being to edit pages you have to be approved, this is prevent spamming. Once you create an account email either Bill (his email is the 'request write access' link on the front page) or myself and we can have you added to the list. This will eventually get automated. We're also interested in a new site design, perhaps using the wiki as a focal point. Are there any designers in the group interested in donating their time and talents to update the look and feel of the Jython site as well as a produce a new logo? thanks, brian ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl Previous Message by Thread: click to view message previewJython program hangsHello, I am using jython for ETL processing for transforming data from oracle database to xml messages. Once I convert to xml messages I store information Generally I don't have problem reading data and storing but for larger data, my program hangs when I am trying to insert XML message to database. Database guys are saying I am doing something wrong with memory and there are no locking blocks at oracle. Also I am using java.sql class for creating connection, statement, resulteset. Does anybody face this kind of problem? Thanks Prashant ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl Next Message by Thread: click to view message previewa new Jython wikiI'm happy to announce the creation of a new Jython wiki. http://www.jython.org/cgi-bin/wiki Bill Dehora has generously donated his time to put together the new site as well as seed it with a lot of quality pages. We're hoping this will be an ongoing process whereby we can collect information, such as the recently written developer's guide, all in one place. We still need to migrate the FAQ as well as update it with any new entries. Recently on the jython-users list there have been questions about J2ME, JDK1.5, memory, the classpath and many more issues which have been answered and should be preserved. As we move forward it's the hope the wiki will provide this forum. For the time being to edit pages you have to be approved, this is prevent spamming. Once you create an account email either Bill (his email is the 'request write access' link on the front page) or myself and we can have you added to the list. This will eventually get automated. We're also interested in a new site design, perhaps using the wiki as a focal point. Are there any designers in the group interested in donating their time and talents to update the look and feel of the Jython site as well as a produce a new logo? thanks, brian ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl Loading Comments...
|
|
