You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by titexe <Ab...@eurofins.com> on 2009/09/23 18:04:59 UTC

config datasource sql server

Hello,

I'm just a beginner, I'm enthusiasm to make a model based on ActiveMQ and
Camel.

I try to make a camel route which query the database and put the result into
a queue.

I have a problem with the declaration of the database sql server 2005 I
always get this error:

ERROR: java.lang.RuntimeException: Failed to execute start task. Reason:
org.apache.camel.NoSuchEndpointException: No endpoint could be found for:
jdb
c: testdb, please check your classpath contains the needed jar camel
component.

below my configuration: 

<camelContext id="camel"
xmlns="http://activemq.apache.org/camel/schema/spring">
<route>
     <from uri="timer://pollTheDatabase?delay=10000"/>
     <setBody>
       <constant>select * from customer</constant>
     </setBody>
     <to uri="jdbc:testdb"/>
     <to uri="activemq:queue:result"/>
  </route>
</camelContext>

<bean id="testdb" class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
   <property name="serverName" value="FR50EAIC"/>
   <property name="portNumber" value="1433"/>
   <property name="databaseName" value="IP_MOM_GROUP_FIN_AXINTERFACES"/>
   <property name="user" value="appuser_talend"/>
   <property name="password" value="P@$$w0rd"/>
</bean>

version activemq : fuse message broker 5.3.0.3 
version java       :  Java 1.6

Thank you for helping me resolve this problem,

Best regards,

titexe
-- 
View this message in context: http://www.nabble.com/config-datasource-sql-server-tp25531210p25531210.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Re: config datasource sql server

Posted by Roman Kalukiewicz <ro...@gmail.com>.
Hey!

Looks like you should do what exception tells you to do:

please check your classpath contains the needed jar camel component.

that is camel-jdbc.jar.

If you have it on your classpath, then we will look into different reasons.

Roman

2009/9/23 titexe <Ab...@eurofins.com>:
>
> Hello,
>
> I'm just a beginner, I'm enthusiasm to make a model based on ActiveMQ and
> Camel.
>
> I try to make a camel route which query the database and put the result into
> a queue.
>
> I have a problem with the declaration of the database sql server 2005 I
> always get this error:
>
> ERROR: java.lang.RuntimeException: Failed to execute start task. Reason:
> org.apache.camel.NoSuchEndpointException: No endpoint could be found for:
> jdb
> c: testdb, please check your classpath contains the needed jar camel
> component.
>
> below my configuration:
>
> <camelContext id="camel"
> xmlns="http://activemq.apache.org/camel/schema/spring">
> <route>
>     <from uri="timer://pollTheDatabase?delay=10000"/>
>     <setBody>
>       <constant>select * from customer</constant>
>     </setBody>
>     <to uri="jdbc:testdb"/>
>     <to uri="activemq:queue:result"/>
>  </route>
> </camelContext>
>
> <bean id="testdb" class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
>   <property name="serverName" value="FR50EAIC"/>
>   <property name="portNumber" value="1433"/>
>   <property name="databaseName" value="IP_MOM_GROUP_FIN_AXINTERFACES"/>
>   <property name="user" value="appuser_talend"/>
>   <property name="password" value="P@$$w0rd"/>
> </bean>
>
> version activemq : fuse message broker 5.3.0.3
> version java       :  Java 1.6
>
> Thank you for helping me resolve this problem,
>
> Best regards,
>
> titexe
> --
> View this message in context: http://www.nabble.com/config-datasource-sql-server-tp25531210p25531210.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
>

Re: config datasource sql server

Posted by titexe <Ab...@eurofins.com>.
Problem fixed, camel-jdbc.jar are missing in library.

thank you for your reactivity


titexe wrote:
> 
> Hello,
> 
> I'm just a beginner, I'm enthusiasm to make a model based on ActiveMQ and
> Camel.
> 
> I try to make a camel route which query the database and put the result
> into a queue.
> 
> I have a problem with the declaration of the database sql server 2005 I
> always get this error:
> 
> ERROR: java.lang.RuntimeException: Failed to execute start task. Reason:
> org.apache.camel.NoSuchEndpointException: No endpoint could be found for:
> jdb
> c: testdb, please check your classpath contains the needed jar camel
> component.
> 
> below my configuration: 
> 
> <camelContext id="camel"
> xmlns="http://activemq.apache.org/camel/schema/spring">
> <route>
>      <from uri="timer://pollTheDatabase?delay=10000"/>
>      <setBody>
>        <constant>select * from customer</constant>
>      </setBody>
>      <to uri="jdbc:testdb"/>
>      <to uri="activemq:queue:result"/>
>   </route>
> </camelContext>
> 
> <bean id="testdb" class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
>    <property name="serverName" value="FR50EAIC"/>
>    <property name="portNumber" value="1433"/>
>    <property name="databaseName" value="IP_MOM_GROUP_FIN_AXINTERFACES"/>
>    <property name="user" value="appuser_talend"/>
>    <property name="password" value="P@$$w0rd"/>
> </bean>
> 
> version activemq : fuse message broker 5.3.0.3 
> version java       :  Java 1.6
> 
> Thank you for helping me resolve this problem,
> 
> Best regards,
> 
> titexe
> 

-- 
View this message in context: http://www.nabble.com/config-datasource-sql-server-tp25531210p25611293.html
Sent from the Camel - Users mailing list archive at Nabble.com.