Hi Michael,
This is a recurrent problem when using a DataSource / ORM projects on
OSGI as the bundle need to know which SQL Driver classes it must
import. Unfortunately, it is not possible in ORM / DataSource bundles
to import all the Database drivers available on the market. A
workaround is to use the DynamicImport-Package instruction to allow
OSGI platform to detect that and load this class after the bundle
starting up
You can add this instruction using the command
karaf@root> dev:dynamic-import --help
DESCRIPTION
dev:dynamic-import
Enable/disable dynamic-import for a given bundle
SYNTAX
dev:dynamic-import [options] id
ARGUMENTS
id
The bundle ID
OPTIONS
--help
Display this help message
Regards,
Charles Moulliard
Sr. Principal Solution Architect - FuseSource
Apache Committer
Blog : http://cmoulliard.blogspot.com
Twitter : http://twitter.com/cmoulliard
Linkedin : http://www.linkedin.com/in/charlesmoulliard
Skype: cmoulliard
On Thu, Mar 24, 2011 at 2:17 PM, Michael Dewitte
<[email protected]> 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 <[email protected]>
>
>> 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
>> <[email protected]> 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 <[email protected]>
>> >
>> >> 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 <[email protected]>
>> >>
>> >>> 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<[email protected]>
>> >>>>
>> >>>> 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.
>> >>>>>
>> >>>>>
>> >>
>> >
>>
>
