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. >>>>> >>>>> >> >
