Re: Inserting XML Document into Relational Tables of RDBMS

2007-10-22 Thread Albert Bupp
If I may jump in, I think what Gustavo means is you could use the scomp utility included in the XMLBeans package to generate Java classes representing the XML data that you want to populate your RDBMS. This utility generates and compiles (and jars) a set of Java class files which correspond to

Re: Inserting XML Document into Relational Tables of RDBMS

2007-10-22 Thread Albert Bupp
Meisam, You're welcome. I agree, you're 1st and biggest task will be to figure out the mapping. This may or may not be at all straight-forward, depending on the particular DOM and the RDBMS involved and whether or not you are free to design/redesign one or the other for your purposes. Once

Re: instantiate given a schema type

2007-10-22 Thread Jacob Danner
There are a couple of different ways you can do this within XmlObject. I prefer the xmlcursor methods, but you can also use .newDomNode() and work with the DOM api and call append child like parent.newDomNode()...appendChild(...) -jacobd On 10/22/07, Cory Virok [EMAIL PROTECTED] wrote: That

RE: instantiate given a schema type

2007-10-22 Thread Cory Virok
Unless I do a DOM node import, I get the Child to add is from another document error when using the DOM API. I tried using the copyXml() method with XmlCursor but it gave me an error saying that it could not copy and entire document. Since we can do this in DOM and in Cursor modes... is this

RE: instantiate given a schema type

2007-10-22 Thread Cory Virok
Actually, I can't get the DOM API to correctly insert the created node... here's my code: code //children[i] is a SchemaParticle //parent is an XmlObject SchemaTypeLoader loader = XmlBeans.getContextTypeLoader(); XmlObject childObj =

RE: Single-item sequence causes failure

2007-10-22 Thread Vance Vagell
Another example is: http://api.eurocv.eu/euroserver.php?wsdl The type License defined as: xsd:complexType name=License xsd:all xsd:element name=license type=xsd:string/ /xsd:all /xsd:complexType is not loaded. This one has an all, instead of a sequence, but is the same behavior. -

Re: Single-item sequence causes failure

2007-10-22 Thread Jacob Danner
right, this is another rpc/encoded schema and you get the same error message. http://api.eurocv.eu/euroserver.php?wsdl:525:5: error: src-resolve: attribute 'a [EMAIL PROTECTED]://schemas.xmlsoap.org/soap/encoding/' not found. One other item you can use to get around this is to add the

Re: Single-item sequence causes failure

2007-10-22 Thread Jacob Danner
The type of the sequence is actually an array of type: apachesoap:mapItem I don't think this is the cause of your problem. The WSDL is rpc/encoded which doesn't really fit the document/literal style that it should be used with. I get the typical error message when trying to compile the schema