Java_pool lacks Memory (DBMS_XMLSave)

Hi,

among others I still have the problem of scalability. My small application doesn't scale to infinity :-(
This is the scenario:
We have different systems sthat need to exchange Data - An XML file was the choice to solve this problem.
Oracle offers very neat tools to export data in XMLformat. (The PL/SQL Package "DBMS_XMLQuery").
I wrote some Java tools and Perl scripts to access get these XML-datastream from all over the netwok.
To import XML-Data into my Oracle 9i system I worte a small Java tool that streams a file into a CLOB field in a table. this part is scalable it never uses more than 11 MB of RAM even with filessizes of 66 MB.
This is the critical part:
Another PL/SQL procedure takes the data from the CLOB field and should fill a table (using "DBMS_XMLSave").
It works fine for smaller data < 10 MB but if I take my scalability test with 66 MB it stops with an uncaught JavaOutOfMemory Exception. My Java_Pool_size is 171 MB !
Has anyone experiences with large XML-Data, or Java Memory Errors or any other good idea hw too solve this problem using XMLData and no SQLLoader. BTW I chose to write my own Java-CLOB-Loader tool because I needed hostaccess to use the commandline Oracle Javatools (java OracleXML) . I didn't want to grant anyone hostacces on the Databasehost....

Thanks in advance
Thomas Received on Thu May 23 2002 - 04:18:01 CDT