Re: Using MyBatis in a camel route on SMX

[Freeman Fang]

Hi,

For the internet access requirement during runtime, it's generally  
caused by download xsd/dtd schema files remotely, for this case, you  
can use xml catelog technique to use a local schema file instead, you  
can download the schema file beforehand, and put it in your customer  
bundle,  then in catelog file rewrite the URI so that it will search  
the local file first, if can find it locally, then won't download it  
remotely. you may need google a bit to get more details about xml  
catelog.

For the No suitable driver found issue, that's actually a frequently  
asked question when use jdbc as bundle in OSGi container, the solution  
is that you can use Dynamic-Import, just as Charles pointed out, you  
also can use Fragment bundle, you may need take a look at[1]

[1]http://fusesource.com/forums/thread.jspa?messageID=9780&#9780

Freeman


On 2011-3-24, at 下午9:17, Michael Dewitte wrote:

I updated the issue in jira with the new project version as  
attachment and
commented the new issues...

Now, if I give access to the net to the server, the error I have is  
a "No
suitable driver found "... (see stacktrace bellow)...
I don't know why, since the jdbc driver bundle is deployed, and
import-packages are written in the pom (correctly ?)

Mike


com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in User.xml.
--- The error occurred while executing mapped statement.
--- Check the deleteUser.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in User.xml.
--- The error occurred while executing mapped statement.
--- Check the deleteUser.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1
at
com 
.ibatis 
.sqlmap 
.engine 
.mapping 
.statement.MappedStatement.executeUpdate(MappedStatement.java:107) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:480) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java: 
98)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:74) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
org 
.apache 
.camel.component.ibatis.IBatisProducer.doDelete(IBatisProducer.java: 
164)[225:org.apache.camel.camel-ibatis:2.6.0]
at
org 
.apache 
.camel.component.ibatis.IBatisProducer.process(IBatisProducer.java: 
55)[225:org.apache.camel.camel-ibatis:2.6.0]
at
org.apache.camel.impl.converter.AsyncProcessorTypeConverter 
$ 
ProcessorToAsyncProcessorBridge 
.process(AsyncProcessorTypeConverter.java:50) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.SendProcessor 
$2.doInAsyncProducer(SendProcessor.java:104) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:272) 
[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.SendProcessor.process(SendProcessor.java: 
98)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.interceptor.TraceInterceptor.process(TraceInterceptor.java:99) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler 
.processErrorHandler(RedeliveryErrorHandler.java:299) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:208) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache.camel.processor.DefaultChannel.process(DefaultChannel.java: 
269)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:125) 
[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:80) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:102) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processExchange(GenericFileConsumer.java: 
330)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:157) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component.file.GenericFileConsumer.poll(GenericFileConsumer.java: 
121)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:97) 
[68:org.apache.camel.camel-core:2.6.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java: 
441)[:1.6.0_22]
at
java.util.concurrent.FutureTask 
$Sync.innerRunAndReset(FutureTask.java:317)[:1.6.0_22]
at
java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)[: 
1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) 
[:1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java: 
180)[:1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)[: 
1.6.0_22]
at
java.util.concurrent.ThreadPoolExecutor 
$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_22]
at
java.util.concurrent.ThreadPoolExecutor 
$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_22]
at java.lang.Thread.run(Thread.java:662)[:1.6.0_22]
Caused by: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1
at java.sql.DriverManager.getConnection(DriverManager.java:602)[: 
1.6.0_22]
at java.sql.DriverManager.getConnection(DriverManager.java:185)[: 
1.6.0_22]
at
com 
.ibatis 
.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java: 
580)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java: 
222)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java: 
48)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java: 
89)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.mapping 
.statement.MappedStatement.executeUpdate(MappedStatement.java:94) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
... 44 more
13:56:40,050 | ERROR | //activemq/input |  
GenericFileOnCompletion          |
68 - org.apache.camel.camel-core - 2.6.0 | Caused by:
[com.ibatis.common.jdbc.exception.NestedSQLException -
--- The error occurred in User.xml.
--- The error occurred while executing mapped statement.
--- Check the deleteUser.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1]
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in User.xml.
--- The error occurred while executing mapped statement.
--- Check the deleteUser.
--- Check the statement or the result map.
--- Cause: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1
at
com 
.ibatis 
.sqlmap 
.engine 
.mapping 
.statement.MappedStatement.executeUpdate(MappedStatement.java:107) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:480) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java: 
98)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:74) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
org 
.apache 
.camel.component.ibatis.IBatisProducer.doDelete(IBatisProducer.java: 
164)[225:org.apache.camel.camel-ibatis:2.6.0]
at
org 
.apache 
.camel.component.ibatis.IBatisProducer.process(IBatisProducer.java: 
55)[225:org.apache.camel.camel-ibatis:2.6.0]
at
org.apache.camel.impl.converter.AsyncProcessorTypeConverter 
$ 
ProcessorToAsyncProcessorBridge 
.process(AsyncProcessorTypeConverter.java:50) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.SendProcessor 
$2.doInAsyncProducer(SendProcessor.java:104) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:272) 
[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.SendProcessor.process(SendProcessor.java: 
98)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.interceptor.TraceInterceptor.process(TraceInterceptor.java:99) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler 
.processErrorHandler(RedeliveryErrorHandler.java:299) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:208) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache.camel.processor.DefaultChannel.process(DefaultChannel.java: 
269)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:125) 
[68:org.apache.camel.camel-core:2.6.0]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:80) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:102) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processExchange(GenericFileConsumer.java: 
330)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:157) 
[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel 
.component.file.GenericFileConsumer.poll(GenericFileConsumer.java: 
121)[68:org.apache.camel.camel-core:2.6.0]
at
org 
.apache 
.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:97) 
[68:org.apache.camel.camel-core:2.6.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java: 
441)[:1.6.0_22]
at
java.util.concurrent.FutureTask 
$Sync.innerRunAndReset(FutureTask.java:317)[:1.6.0_22]
at
java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)[: 
1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) 
[:1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java: 
180)[:1.6.0_22]
at
java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)[: 
1.6.0_22]
at
java.util.concurrent.ThreadPoolExecutor 
$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_22]
at
java.util.concurrent.ThreadPoolExecutor 
$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_22]
at java.lang.Thread.run(Thread.java:662)[:1.6.0_22]
Caused by: java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/forem_1
at java.sql.DriverManager.getConnection(DriverManager.java:602)[: 
1.6.0_22]
at java.sql.DriverManager.getConnection(DriverManager.java:185)[: 
1.6.0_22]
at
com 
.ibatis 
.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java: 
580)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java: 
222)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java: 
48)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java: 
89)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at
com 
.ibatis 
.sqlmap 
.engine 
.mapping 
.statement.MappedStatement.executeUpdate(MappedStatement.java:94) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
... 44 more




2011/3/24 Charles Moulliard <cmoulli...@gmail.com>

As there is a ticket on JIRA, may I suggest that you post your last
project Linus and Michael allowing us to check that and combine our
efforts

Info required : version of components used, Smx version, ...

Regards,

Charles
On Thu, Mar 24, 2011 at 12:08 PM, Michael Dewitte
<michael.dewi...@gmail.com> wrote:
What I suspected is right. I took a network trace, and saw that  
there was
a
request to ibatis.apache.org.... WHY ? :-( How can I avoid that,  
as on
the
server, I can't connect to the net ?

To go further, I gave access to the net for a short time to the  
box, and
it
went further, so it's well the problem for this version of the  
code (not
using blueprint).... now, I face "no suitable driver found"  
problem...
still
investigating...

Mike


2011/3/24 Michael Dewitte <michael.dewi...@gmail.com>

As Willem suggested me on the camel list, I migrated the  
blueprint to
spring... he suspected some initialisation was not done in  
blueprint...

I now have a different error :

10:02:03,097 | ERROR | //activemq/input | DefaultErrorHandler
| 68 - org.apache.camel.camel-core - 2.6.0 | Failed delivery for
exchangeId: ID-oniryx-mike-44117-1300956291456-0-94. Exhausted  
after
delivery attempt: 1 caught: java.lang.RuntimeException: Error  
occurred.
Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause:
java.net.ConnectException: Connection timed out
java.lang.RuntimeException: Error occurred.  Cause:
com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause:
java.net.ConnectException: Connection timed out
at

com 
.ibatis 
.sqlmap 
.engine 
.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:49) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at

com 
.ibatis 
.sqlmap 
.client 
.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at

org 
.apache 
.camel 
.component 
.ibatis.IBatisComponent.createSqlMapClient(IBatisComponent.java:89) 
[225:org.apache.camel.camel-ibatis:2.6.0]
at

org 
.apache 
.camel 
.component 
.ibatis.IBatisComponent.getSqlMapClient(IBatisComponent.java:104) 
[225:org.apache.camel.camel-ibatis:2.6.0]
at

org 
.apache 
.camel 
.component 
.ibatis.IBatisEndpoint.getSqlMapClient(IBatisEndpoint.java:77) 
[225:org.apache.camel.camel-ibatis:2.6.0]
at

org 
.apache 
.camel.component.ibatis.IBatisProducer.doDelete(IBatisProducer.java: 
152)[225:org.apache.camel.camel-ibatis:2.6.0]
at

org 
.apache 
.camel.component.ibatis.IBatisProducer.process(IBatisProducer.java: 
55)[225:org.apache.camel.camel-ibatis:2.6.0]
at

org.apache.camel.impl.converter.AsyncProcessorTypeConverter 
$ 
ProcessorToAsyncProcessorBridge 
.process(AsyncProcessorTypeConverter.java:50) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org.apache.camel.processor.SendProcessor 
$2.doInAsyncProducer(SendProcessor.java:104) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:272) 
[68:org.apache.camel.camel-core:2.6.0]
at

org.apache.camel.processor.SendProcessor.process(SendProcessor.java: 
98)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.interceptor.TraceInterceptor.process(TraceInterceptor.java:99) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler 
.processErrorHandler(RedeliveryErrorHandler.java:299) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:208) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache.camel.processor.DefaultChannel.process(DefaultChannel.java: 
269)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org.apache.camel.processor.Pipeline.process(Pipeline.java:125) 
[68:org.apache.camel.camel-core:2.6.0]
at

org.apache.camel.processor.Pipeline.process(Pipeline.java:80) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:102) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java: 
70)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.processor 
.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.management 
.InstrumentationProcessor.process(InstrumentationProcessor.java:68) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processExchange(GenericFileConsumer.java: 
330)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.component 
.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:157) 
[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel 
.component.file.GenericFileConsumer.poll(GenericFileConsumer.java: 
121)[68:org.apache.camel.camel-core:2.6.0]
at

org 
.apache 
.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:97) 
[68:org.apache.camel.camel-core:2.6.0]
at

java.util.concurrent.Executors$RunnableAdapter.call(Executors.java: 
441)[:1.6.0_22]
at

java.util.concurrent.FutureTask 
$Sync.innerRunAndReset(FutureTask.java:317)[:1.6.0_22]
at

java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)[: 
1.6.0_22]
at

java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) 
[:1.6.0_22]
at

java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java: 
180)[:1.6.0_22]
at

java.util.concurrent.ScheduledThreadPoolExecutor 
$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)[: 
1.6.0_22]
at

java.util.concurrent.ThreadPoolExecutor 
$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_22]
at

java.util.concurrent.ThreadPoolExecutor 
$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_22]
at java.lang.Thread.run(Thread.java:662)[:1.6.0_22]
Caused by: com.ibatis.common.xml.NodeletException: Error parsing  
XML.
Cause: java.net.ConnectException: Connection timed out
at

com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at

com 
.ibatis 
.sqlmap 
.engine 
.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:46) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
... 44 more
Caused by: java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)[:1.6.0_22]
at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)[: 
1.6.0_22]
at

java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) 
[:1.6.0_22]
at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)[:1.6.0_22]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)[: 
1.6.0_22]
at java.net.Socket.connect(Socket.java:529)[:1.6.0_22]
at java.net.Socket.connect(Socket.java:478)[:1.6.0_22]
at sun.net.NetworkClient.doConnect(NetworkClient.java:163)[: 
1.6.0_22]
at
sun.net.www.http.HttpClient.openServer(HttpClient.java:394)[: 
1.6.0_22]
at
sun.net.www.http.HttpClient.openServer(HttpClient.java:529)[: 
1.6.0_22]
at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)[: 
1.6.0_22]
at sun.net.www.http.HttpClient.New(HttpClient.java:306)[:1.6.0_22]
at sun.net.www.http.HttpClient.New(HttpClient.java:323)[:1.6.0_22]
at

sun 
.net 
.www 
.protocol 
.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:975) 
[:1.6.0_22]
at

sun 
.net 
.www 
.protocol 
.http.HttpURLConnection.plainConnect(HttpURLConnection.java:916)[: 
1.6.0_22]
at

sun 
.net 
.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java: 
841)[:1.6.0_22]
at

sun 
.net 
.www 
.protocol 
.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1177) 
[:1.6.0_22]
at  
org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown
Source)[:]
at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown
Source)[:]
at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown
Source)[:]
at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown
Source)[:]
at

org.apache.xerces.impl.XMLDocumentScannerImpl 
$DTDDispatcher.dispatch(Unknown
Source)[:]
at

org 
.apache 
.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(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.DOMParser.parse(Unknown Source)[:]
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown  
Source)[:]
at

com 
.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java: 
157)[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
at

com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50) 
[224:org.apache.servicemix.bundles.ibatis-sqlmap:2.3.4.726_3]
... 45 more



I suspect it's trying to download the sqlmap-config dtd from the  
net...
but
why ? I mean, normally, it should take it from the ibatis-sqlmap
servicemix
bundle, no ?

Mike


2011/3/24 Charles Moulliard <cmoulli...@gmail.com>

Hi Michael,

I'm really sorry but I don't have any example right now. If I have
time, I
will try to deploy your project this afternoon.

Regards,

Charles


On 24/03/11 08:49, Michael Dewitte wrote:

Hi, thanks for your answer.

Since I'm using MySQL (for test prupose at least), I installed  
the
driver
as
OSGI bundle. I'm not sure that the route bundle I deploy is  
able to
use
it,
but it seems I'm blocked earlier.

I would greatly appreciate if you could package a working  
sample and
post
it. I assume that in my case there might be some wrong config  
or some
file
is not at the right place... I posted my project as attachment  
of a
jira
issue I raised  as asked by Gert.... Maybe you'd be able to  
find the
difference with your project... or maybe you could attach your  
sample
project to the case so that I can go further...

Thanks for everybody's help !

2011/3/24 Brimstedt<li...@brimstedt.se>

Hello,
I have used camel-ibatis in a route in smx 4.x if it helps.

I've just started to use it and so far made a select that  
outputs
rows
the
log.

The first problem I had was to get ibatis to find my jtds driver
(ended
up
putting it in lib and exposing it in custom.properties.

The second problem I have is with configuring the datasource,  
right
now
I
have it hardcoded in SqlMapConfig.xml and have yet to find a  
way to
put
it
in my beans.xml or configure db connection using java. If  
someone
could
enlighten me here, id be very happy.

If I can provide any help on the camel-ibatis usage id be  
delighted.

br
/Linus


Gert Vanthienen wrote:

Mike,

There's a good chance that nobody has tried the
ServiceMix/Camel/iBatis comibination before.   However, it  
sounds
like
a reasonable use case, so would you be willing to raise a  
JIRA issue
and provide a patch with the stuff you have so far (perhaps  
remove
the
bits that are proprietary to your company or project) so we  
can turn
it into a working example ?




--
View this message in context:


http://servicemix.396122.n5.nabble.com/Using-MyBatis-in-a-camel-route-on-SMX-tp4256837p4261774.html
Sent from the ServiceMix - User mailing list archive at  
Nabble.com.







--
Freeman Fang

------------------------

FuseSource: http://fusesource.com
blog: http://freemanfang.blogspot.com
twitter: http://twitter.com/freemanfang
Apache Servicemix:http://servicemix.apache.org
Apache Cxf: http://cxf.apache.org
Apache Karaf: http://karaf.apache.org
Apache Felix: http://felix.apache.org