Using StaX to parse xml document into database tables

["richie.riviere@gmail.com" <ri...@gmail.com>]

Hi All,

I've just spent a few hours trying to implement a solution and am a bit
confused. My use case is that I have an XML document full of items. i.e.

<Items>...<item></item>...<item></item>...</Items>

There could be about 100 individual items in the document.

I am currently using StAXXPathSplitChoicePerformanceTest.java and
StAXJAXBIteratorExpressionTest.java as my guides to try and come up with a
good solution. The pattern I want to use is the message router pattern.

So far I have something like this...

MainApp.java <http://camel.465427.n5.nabble.com/file/n5741319/MainApp.java>  
ToStagingRouteBuilder.java
<http://camel.465427.n5.nabble.com/file/n5741319/ToStagingRouteBuilder.java>  
AbstractFileRouteBuilder.java
<http://camel.465427.n5.nabble.com/file/n5741319/AbstractFileRouteBuilder.java>  
Item.java <http://camel.465427.n5.nabble.com/file/n5741319/Item.java>  
application-context.xml
<http://camel.465427.n5.nabble.com/file/n5741319/application-context.xml>  
camel-context.xml
<http://camel.465427.n5.nabble.com/file/n5741319/camel-context.xml>  

The bit that reads the XML file from the input directory works. And I know
when my route runs and my processor does a String xml =
exchange.getIn().getBody(String.class); the xml in the file gets read
correctly.

Where I am stuck is that jaxb doesn't seem to have split the items into
individual item records.
i.e. This code returns empty and I get an array Index out of bounds.

/	protected void getObjects() {
        recordsEndpoint.expectedMessageCount(10);
        recordsEndpoint.allMessages().body().isInstanceOf(Item.class);
		Item item =
recordsEndpoint.getReceivedExchanges().get(0).getIn().getBody(Item.class);
		System.out.println(item.getItemNo());
	}/	

Does what I am doing in my code make sense. Can anyone help me with what I
am missing to get the parsing to work? 


Also if I do get the parsing of the xml file working can anyone provide me
some advice on a nice design pattern for me to use to write to the db. 


thank you!



--
View this message in context: http://camel.465427.n5.nabble.com/Using-StaX-to-parse-xml-document-into-database-tables-tp5741319.html
Sent from the Camel - Users mailing list archive at Nabble.com.