I use the Transfer.java to result a XML Document. *************************************************************** If using the DTD, I want to get the document...
Do I must have the "IgnoreRoot..." in my map file? ********************* XML file ************************* If I want to get the XML Document that "Peoples"...
Hello I want to store XML-Data in an Oracle-DB but I have a problem with Transfer.java. I have successfully generated the SQL-DDL for that with GenerateMap...
I have this situation in an XML file: ... <room type="SGL" roomnum="1"> <paxname isleadname="Y">MIKE</paxname> <gross>84.000</gross> <nett>84.000</nett> ...
You need to modify Transfer to commit the connection before closing it. (This is a bug in Transfer.) For more information, see: ...
Ronald Bourret
rpbourret@...
Jan 3, 2002 10:51 pm
1838
This depends on the parser you are using. Your parser should have an option so that it throws an exception when it finds a validation error. (Most parsers do...
Ronald Bourret
rpbourret@...
Jan 3, 2002 10:59 pm
1839
Thanks. This is a known bug and has been fixed in version 2.0. (Good work finding it. It's not an easy one...) -- Ron...
Ronald Bourret
rpbourret@...
Jan 3, 2002 11:11 pm
1840
Hi Ron Nice to have you back. I was going crazy trying to figure out the result set closing problem and was not sure if I was going to break the program. Did...
Hi I am trying to make a map file for this incoming XML data. it should populate two tables invoice and <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE...
Did your Q1 is that you want to get the <!DOCTYPE response SYSTEM "intacct_response.v2.1.dtd"> in the output xml file? If yes, I add the statement a row of...
Has anyone looked at JaxMe? (http://jaxme.sourceforge.net) The docs for it are sparse, but I'm curious if anyone here has any experience with it and cares to...
Gary Lawrence Murphy
garym@...
Jan 4, 2002 6:42 am
1844
... DOM levels 1 and 2 do not allow you to add/modify a DocumentType node, so you can't modify the DOM tree returned by DBMSToDOM. Therefore, the only way to...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:03 am
1845
... Note that this is specific to the Xerces parser. ... This is easy. Just add these attributes to the root element: doc = dbmsToDOM.retrieveDocument(...); ...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:12 am
1846
You can't do this in version 1.0. (You will be able to do this in version 2.0). To solve the problem, create a map file for the following XML document: <?xml...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:27 am
1847
This is the same problem as your previous question. You first need to transform the document to: <room type="SGL" roomnum="1" isleadname="Y"> ...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:27 am
1848
... The problem is that IgnoreRoot and PseudoRoot can only eliminate a single, top-level element. The data you want to map is nested more deeply than that. The...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:34 am
1849
... Do I must add these instructs in the "toXML" of Transfer.java ?...
... No. You only use IgnoreRoot if you don't want to map the root element to the database. ... If you do not map <Peoples> with IgnoreRoot, you must use...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:45 am
1852
Just use the identifiers without quotes. For example: CORRECT: <ClassMap> <ElementType Name='DATA-STRUCT'> <ToClassTable> <Table Name='DATA-STRUCT'/> ...
Ronald Bourret
rpbourret@...
Jan 4, 2002 8:53 am
1853
I just took a quick look at it. It appears to have two major differences: 1) You can't transfer data directly from XML to/from the database. Instead, you must...
Ronald Bourret
rpbourret@...
Jan 4, 2002 9:05 am
1854
... Your code will probably work, but I won't guarantee it :) A better solution would be to close the result set in the method that creates it. To do this, you...
Ronald Bourret
rpbourret@...
Jan 4, 2002 9:32 am
1855
1) See previous email for possible solutions to DTD problem 2) For datecreated and datedue, you will have to transform these before mapping. For more...
Ronald Bourret
rpbourret@...
Jan 4, 2002 9:41 am
1856
... Yes. Remember that Transfer.java is just a sample. Most people use it as code to start writing their own application. -- Ron...
Ronald Bourret
rpbourret@...
Jan 4, 2002 10:38 am
1857
This is very strange. I assume POLICYPK is a generated key and has a SQL type of NUMERIC. Assuming this is true, then the call stack for the Oracle ODBC driver...
Ronald Bourret
rpbourret@...
Jan 4, 2002 11:09 pm
1858
... I add these instructions in the "toXML" of Transfer.java, but it has a little of bugs. I add some declared instructions with root, but it still have bugs....
root should be declared as an Element (org.w3c.dom.Element): static void toXML(String mapFilename, String xmlFilename, String url, String tableName,...
Ronald Bourret
rpbourret@...
Jan 7, 2002 7:12 am
1860
... I have modify my xml file and Transfer the data from database to the xml document that is success. But I can't transfer the data to the database. The data...
Please see example xml file below which i am trying to bring into DBMS tables. My problem is that there is too many nesting levels which don't make database...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
