Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of willem.jiang@gmail.com
 designates 209.85.160.45 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=VW0Ubbj9GR6ihTIeWwCdDb3JvDatyQkNt81v25ngIKY7mxuiJgM7l9tjfCTbVHlBl4
         vH8ss09LSaLR9k/+0YtKtkEWlQtPfAdiAhFRPJerR/rAO2zUGlknyV2cg9V7K/Vp5WBX
         p9CYbOVeGI3nR5Ca2atbz3yFd5r0mqAAkhwts=
Message-ID: <4C522A4C.70008@gmail.com>
Date: Fri, 30 Jul 2010 09:26:36 +0800
From: Willem Jiang <willem.jiang@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228)
MIME-Version: 1.0
To: users@camel.apache.org
Subject: Re: Help using JoSQL
References: <1280451902351-2259071.post@n5.nabble.com>
In-Reply-To: <1280451902351-2259071.post@n5.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

It looks like you didn't put the camel-josql jar into your class path.

Willem
----------------------------------
Apache Camel, Apache CXF committer
Open Source Integration http://www.fusesource.com
Blog http://willemjiang.blogspot.com
Tiwtter http://twitter.com/willemjiang

Thiago Souza wrote:
> Hi,
> 
>            I'm trying to use JoSQL. I followed the instructions at
> http://camel.apache.org/sql.html. Here is my current test context:
> 
> 
> 	<c:route>
> 		<c:from uri="file://./input" />
> 		<c:unmarshal ref="test" /> <!-- json -->
> 		<c:setBody>
> 			<c:sql>select num from java.util.Map</c:sql>
> 		</c:setBody>
> 		<c:to uri="log:test?level=INFO" />
> 	</c:route>
> 
> 
>        But I'm always getting the following exception:
> 
> 
> java.lang.IllegalArgumentException: No script engine could be created for:
> sql
>         at
> org.apache.camel.builder.script.ScriptBuilder.createScriptEngine(ScriptBuilder.java:473)
>         at
> org.apache.camel.builder.script.ScriptBuilder.checkInitialised(ScriptBuilder.java:451)
>         at
> org.apache.camel.builder.script.ScriptBuilder.getEngine(ScriptBuilder.java:383)
>         at
> org.apache.camel.builder.script.ScriptBuilder.getScriptContext(ScriptBuilder.java:426)
>         at
> org.apache.camel.builder.script.ScriptBuilder.evaluateScript(ScriptBuilder.java:501)
>         at
> org.apache.camel.builder.script.ScriptBuilder.evaluate(ScriptBuilder.java:77)
>         at
> org.apache.camel.builder.script.ScriptBuilder.evaluate(ScriptBuilder.java:81)
>         at
> org.apache.camel.processor.SetBodyProcessor.process(SetBodyProcessor.java:36)
>         at
> org.apache.camel.impl.converter.AsyncProcessorTypeConverter$ProcessorToAsyncProcessorBridge.process(AsyncProcessorTypeConverter.java:50)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)
>         at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:68)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)
>         at
> org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:99)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)
>         at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:68)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:290)
>         at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:202)
>         at
> org.apache.camel.processor.DefaultChannel.process(DefaultChannel.java:256)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at org.apache.camel.processor.Pipeline.process(Pipeline.java:143)
>         at org.apache.camel.processor.Pipeline.process(Pipeline.java:78)
>         at
> org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:99)
>         at
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:70)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:98)
>         at
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:89)
>         at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:68)
>         at
> org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:313)
>         at
> org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:144)
>         at
> org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:110)
>         at
> org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:98)
>         at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
>         at
> java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
>         at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
>         at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
>         at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> 
> 
> Any clue anyone?
> 
> Regards,
> Thiago Souza
>