I try to configure the following scenario:
File Poller --> Spagic Advanced JDBC --> Reply to File Sender
<file:sender service="foo:file"
endpoint="sender"
directory="file:C:\Projects\SimpleJDBC\sender" />
<file:poller service="foo:file"
endpoint="poller"
file="file:C:\Projects\SimpleJDBC\poller"
targetService="foo:myJdbcQueryadvJdbcDatasource2"
period="10000" >
<property name="filter">
<bean class="org.apache.commons.io.filefilter.WildcardFilter">
<constructor-arg value="*.xml" />
</bean>
</property>
</file:poller>
The database processing seems to work. A query was built and sent to the
database. But I get an IO Exception at the File Component when using an input
file as in the following:
<?xml version="1.0" encoding="UTF-8"
?><queryConfig><name>Whoever</name></queryConfig>
I have no ideas where it come from.
13:55:40,345 | DEBUG | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-1 |
JDBCQueryConfig | ents.jdbcquery.JDBCQueryConfig 120 | Filling
Parameters from Normalized Message
13:55:40,345 | DEBUG | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-1 |
JDBCParameterFactory | jdbcquery.JDBCParameterFactory 96 | Converting
value: Sevcik to type: class java.lang.String
13:55:40,345 | DEBUG | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-1 |
JDBCQueryConfig | ents.jdbcquery.JDBCQueryConfig 129 | Parameter[0]
Name[name] Values[0] ( Type: java.lang.String) XPath (/queryConfig/name)
13:55:40,345 | DEBUG | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-1 |
BCAdvancedQueryComponent | ery.JDBCAdvancedQueryComponent 100 | Executing
query: SELECT username,pass FROM user WHERE (SecondName LIKE ?)
13:55:40,361 | DEBUG | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-1 |
BCAdvancedQueryComponent | ery.JDBCAdvancedQueryComponent 131 | Query results:
[EMAIL PROTECTED] [Element: <rows attributes: []/>]
13:55:40,361 | WARN | pool-flow.seda.myJdbcQueryadvJdbcDatasource2-thread-2 |
FileComponent | icemix.file.FilePollerEndpoint 389 | Message in
file C:\Projects\SimpleJDBC\poller\input.xml could not be handled successfully:
java.io.IOException: Stream closed
javax.xml.transform.TransformerException: java.io.IOException: Stream closed
at
org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:505)
at
org.apache.servicemix.jbi.jaxp.SourceTransformer.toResult(SourceTransformer.java:125)
at
org.apache.servicemix.jbi.jaxp.SourceTransformer.toResult(SourceTransformer.java:103)
at
org.apache.servicemix.jbi.jaxp.SourceTransformer.toString(SourceTransformer.java:140)
at
org.apache.servicemix.jbi.jaxp.SourceTransformer.contentToString(SourceTransformer.java:161)
at
org.spagic.smx.components.jdbcquery.JDBCAdvancedQueryComponent.transform(JDBCAdvancedQueryComponent.java:147)
at
org.apache.servicemix.components.util.TransformComponentSupport.onMessageExchange(TransformComponentSupport.java:71)
at
org.apache.servicemix.jbi.messaging.DeliveryChannelImpl.processInBound(DeliveryChannelImpl.java:620)
at
org.apache.servicemix.jbi.nmr.flow.AbstractFlow.doRouting(AbstractFlow.java:172)
at
org.apache.servicemix.jbi.nmr.flow.seda.SedaFlow.doRouting(SedaFlow.java:168)
at
org.apache.servicemix.jbi.nmr.flow.seda.SedaQueue$1.run(SedaQueue.java:134)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.io.IOException: Stream closed
at
java.io.BufferedInputStream.getBufIfOpen(BufferedInputStream.java:145)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:189)
at java.io.BufferedInputStream.read(BufferedInputStream.java:235)
at
org.apache.xerces.impl.XMLEntityManager$RewindableInputStream.read(Unknown
Source)
at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown
Source)
at
org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at
org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:484)
... 13 more
Berndt
