Gernot Greimler

Greenhorn
+ Follow
since Sep 08, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Gernot Greimler

Just checked the official explanation ( http://www.w3.org/TR/2001/REC-xmlschema-0-20010502/#SubsGroups )and if i get this right, then substitution groups are used for recurring optional elements.

But if that is true - why not simply create a complexType with optional fields and attach it? (Just guessing arround and trying to understand aswell - no expert here )
if you just want to map data from one XML to another XML, XSLT is the key.
I work with Altova MapForce to "map" the Data from one XML Scheme to the other and don't have to write a single line of code.
didn't read the whole thread, but here is how i do the validation before inserting stuff into the database:

file is a string with absolute path + filename

I am currently working on a ex- and import system of a huge oracle database (at least a huge part of a huge database )

i have several relational tables which need to be mapped to a hierachical system (db to xml) and back (xml to db) to have a working im- and export.

currently i am planning to do this like that:

- create a good human readable XML Scheme to have a common standard [done]
- create a relational database that is alike the XML Scheme and insert some "IDs" (primary keys for each level in the xml by using XSLT's position()) [small test done - works]

-- import --
- import rowsets by dbms_savexml in PL/SQL to the relational temporary im/export tables [small test done - works]
- fill in data from im/exporttables into livetables [not done yet - works for sure ]

-- export --
- export livedata into im/export tablemodell in PL/SQL [not done yet - works for sure ]
- export temptables by using SQLX and XDB Functions in PL/SQL [working on small test atm]

Is that the proper way to ex- and import xml into relational databases or is there a standardised way to do this.

thanks in advance for only reading this complete mess of braindump i just produced here - hope anyone is able to tell me if my ideas are good or not
as far as i know actionlisteners use the same "thread" as the window paint methods - maybe try starting a thread with your JDBC query and just "lock" UI until it is finished
18 years ago