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