As ibatis project is not longer an Apache project, you should considering to use myibatis supported by camel
The dtd are located there and are available http://mybatis.org/dtd/mybatis-3-config.dtd Remark : I suggest that you open a ticket on myibatis project to ask them to add the dtd file in the jar and that the classloader load it charles On Thu, Mar 24, 2011 at 3:03 PM, Charles Moulliard <[email protected]> wrote: > 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. >>> >> >>>>> >>> >> >>>>> >>> >> >> >>> >> > >>> >> >>> > >> >> >
