Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I recently used Spring OXM &amp; JAXB for that. The class is <code>org.springframework.oxm.jaxb.Jaxb2Marshaller</code>. You can, ofcourse, use any other implementation of <code>org.springframework.oxm.Unmarshaller</code>.</p> <p>But first You'll need to generate the objects based on Your XSD. For that I used <code>maven-jaxb2-plugin</code>.</p> <pre><code>&lt;plugin&gt; &lt;groupId&gt;org.jvnet.jaxb2.maven2&lt;/groupId&gt; &lt;artifactId&gt;maven-jaxb2-plugin&lt;/artifactId&gt; &lt;executions&gt; &lt;execution&gt; &lt;id&gt;generate-oxm&lt;/id&gt; &lt;goals&gt; &lt;goal&gt;generate&lt;/goal&gt; &lt;/goals&gt; &lt;configuration&gt; &lt;schemaDirectory&gt;src/main/resources/META-INF/xsd&lt;/schemaDirectory&gt; &lt;generatePackage&gt;com.stackoverflow.xjc&lt;/generatePackage&gt; &lt;/configuration&gt; &lt;/execution&gt; &lt;/executions&gt; &lt;/plugin&gt; </code></pre> <p>And then configure the marshaller:</p> <pre><code>@Configuration public class ApplicationConfiguration { @Autowired private ResourcePatternResolver resourceResolver; @Bean public Jaxb2Marshaller oxmMarshaller() throws IOException { Jaxb2Marshaller marshaller = new Jaxb2Marshaller(); marshaller.setContextPath("com.stackoverflow.xjc"); marshaller.setSchemas(resourceResolver.getResources("classpath:/META-INF/xsd/*.xsd")); return marshaller; } } </code></pre> <p>Than just:</p> <pre><code>File xmlFile = new File("my.xml"); Source source = new StreamSource(new FileInputStream(xmlFile)); JAXBElement&lt;MyXmlRootElemClass&gt; result = oxmMarshaller.unmarshal(source); MyXmlRootElemClass theObject = result.getValue(); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POXml to Object java Spring 3
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRoadrunner
    1. USRoadrunner
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POXml to Object java Spring 3
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COWhat MyXmlRootElemClass refers to and it gives me error when I write `new FileInputStream(xmlFile)` line and I can't put try catch to it. Sorry but can you explain more and write more?
      singulars
      1. PO
      1. USkamaci
    2. CO@kamaci: The `MyXmlRootElemClass` is the class representing the root element of Your XML based on Your XSD - it will be generated by JAXB on `generate-sources` by maven plugin and will have the same name as Your root element in XML. The last part of my answer is just to give You the idea what goes where in using the (un)marshaller - You may retrieve the XML contents to parse any other way by using any other implementation of `Source`. But still You'll probably need to handle some exceptions.
      singulars
      1. PO
      1. USRoadrunner
    3. COthanks for your help.
      singulars
      1. PO
      1. USkamaci
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload