superstock51
New Member
Here is the scoop:
We would like to use a stored procedure to Parse and Read an XML file. The file is being generated by Java Code and stored on disk. The OS is Linux, and we wrote a procedure that actually compiles on the database. Here lies the problem:
SAXBuilder builder = new SAXBuilder();
Document doc = builder.build(new File("c:/spXml/src/TestData.xml"));
Element el = doc.getRootElement();
Iterator records = el.getChildren("record").iterator();
In the above code where we specify the path, will not compile if we change it to a UNIX style directory like /pro/reports/src/TestData.xml. When we try to compile this, SQL Explorer crashes hard. If we leave the ":" in the string it is fine. I can't determine if the SAX class is causing the crash or if the OS is causing it because I run the SQL Explorer from my PC. Please help!!!!
Kent K.
We would like to use a stored procedure to Parse and Read an XML file. The file is being generated by Java Code and stored on disk. The OS is Linux, and we wrote a procedure that actually compiles on the database. Here lies the problem:
SAXBuilder builder = new SAXBuilder();
Document doc = builder.build(new File("c:/spXml/src/TestData.xml"));
Element el = doc.getRootElement();
Iterator records = el.getChildren("record").iterator();
In the above code where we specify the path, will not compile if we change it to a UNIX style directory like /pro/reports/src/TestData.xml. When we try to compile this, SQL Explorer crashes hard. If we leave the ":" in the string it is fine. I can't determine if the SAX class is causing the crash or if the OS is causing it because I run the SQL Explorer from my PC. Please help!!!!
Kent K.