Hi Michael, > - why it doesn't work with blueprint and it works with spring-xml
To be investigated. Have you created a JIRA ticket for that purpose ? > - why it keep on trying to fetch the SqlMapConfig.dtd and if the server is > offline - it gets a connection time out and then it fails.... This is not SMX related but due to the definition defined in the XML file. Apparently, The link to the web page is down for the moment. this is why you have a timeout. Can you change the header of the xml file and point to a local system DTD if this is possible ? 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:36 PM, Michael Dewitte <[email protected]> wrote: > Charles, a huge thanks to you, because it works ! > I was reading in the mailing list archive about something like this, but it > was about putting it in the MANIFEST of camel-ibatis... > Now, still I'm wondering the two first issues : > - why it doesn't work with blueprint and it works with spring-xml > - why it keep on trying to fetch the SqlMapConfig.dtd and if the server is > offline - it gets a connection time out and then it fails.... > But thanks for your help, because it give me the possibility to test > further, even if I have to find answers to the 2 first issues if I want to > put this into production sometime... > Mike > > 2011/3/24 Charles Moulliard <[email protected]> >> >> 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. >> >> >>>>> >> >> >>>>> >> >> >> >> >> > >> >> >> > > >
