You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by Reda <ma...@libero.it> on 2008/11/07 19:42:30 UTC
Camel SQL Component & dataSource property
Hi
Reading http://activemq.apache.org/camel/sql-component.html I cannot
understand where I have to set the dataSource. I got
SEVERE: Failed: org.apache.camel.ResolveEndpointFailedException: Failed to
resolve endpoint: sql:select username as userid from mdl_user due to:
java.lang.IllegalArgumentException: Property 'dataSource' is required
org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint:
sql:select username as userid from mdl_user due to:
java.lang.IllegalArgumentException: Property 'dataSource' is required
with
<route>
<from uri="timer://pollTheDatabase?delay=10000" />
<setProperty propertyName="dataSource">
<constant>moodleDB</constant>
</setProperty>
<to uri="sql:select username as userid from mdl_user" />
</route>
and with
<route>
<from uri="timer://pollTheDatabase?delay=10000" />
<to uri="sql:select username as userid from
mdl_user?template.dataSource=moodleDB" />
</route>
where moodleDB is defined as
<bean id="moodleDB"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/moodle" />
<property name="username" value="moodle" />
<property name="password" value="moodle" />
</bean>
It would be nice to have an example for each camel component in "examples"
in the camel distribution...
Thanks in advance
Matteo
--
View this message in context: http://www.nabble.com/Camel-SQL-Component---dataSource-property-tp20386559s22882p20386559.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Camel SQL Component & dataSource property
Posted by Roman Kalukiewicz <ro...@gmail.com>.
Hello!
I've just added the information to the wiki page. Hope it will help :)
Romek
2008/11/8 Claus Ibsen <ci...@silverbullet.dk>:
> Hi
>
> Yes this one needs improved documentation. It is a good idea to check the unit test in Camel how we test the component itself.
>
> You can configure the component in Spring XML as a standard Spring Bean where you can set the properties. I guess it has a flaw in the URI so you can set a ref to a datasource nice and easily from Spring DSL as well.
>
> Something like this, its standard Spring stuff:
>
> <bean id="sql" class="org.apache....SqlComponent"/>
> <property name="dataSource" ref="myDataSource"/>
> </bean>
>
>
>
>
>
> Med venlig hilsen
>
> Claus Ibsen
> ......................................
> Silverbullet
> Skovsgårdsvænget 21
> 8362 Hørning
> Tlf. +45 2962 7576
> Web: www.silverbullet.dk
>
> -----Original Message-----
> From: Reda [mailto:matteo.redaelli@libero.it]
> Sent: 7. november 2008 19:42
> To: camel-user@activemq.apache.org
> Subject: Camel SQL Component & dataSource property
>
>
> Hi
>
> Reading http://activemq.apache.org/camel/sql-component.html I cannot
> understand where I have to set the dataSource. I got
>
> SEVERE: Failed: org.apache.camel.ResolveEndpointFailedException: Failed to
> resolve endpoint: sql:select username as userid from mdl_user due to:
> java.lang.IllegalArgumentException: Property 'dataSource' is required
> org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint:
> sql:select username as userid from mdl_user due to:
> java.lang.IllegalArgumentException: Property 'dataSource' is required
>
> with
>
> <route>
> <from uri="timer://pollTheDatabase?delay=10000" />
> <setProperty propertyName="dataSource">
> <constant>moodleDB</constant>
> </setProperty>
> <to uri="sql:select username as userid from mdl_user" />
> </route>
>
> and with
>
> <route>
> <from uri="timer://pollTheDatabase?delay=10000" />
> <to uri="sql:select username as userid from
> mdl_user?template.dataSource=moodleDB" />
> </route>
>
> where moodleDB is defined as
>
> <bean id="moodleDB"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource">
> <property name="driverClassName" value="com.mysql.jdbc.Driver" />
> <property name="url" value="jdbc:mysql://localhost:3306/moodle" />
> <property name="username" value="moodle" />
> <property name="password" value="moodle" />
> </bean>
>
>
> It would be nice to have an example for each camel component in "examples"
> in the camel distribution...
>
> Thanks in advance
> Matteo
>
>
> --
> View this message in context: http://www.nabble.com/Camel-SQL-Component---dataSource-property-tp20386559s22882p20386559.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
>
RE: Camel SQL Component & dataSource property
Posted by Claus Ibsen <ci...@silverbullet.dk>.
Hi
Yes this one needs improved documentation. It is a good idea to check the unit test in Camel how we test the component itself.
You can configure the component in Spring XML as a standard Spring Bean where you can set the properties. I guess it has a flaw in the URI so you can set a ref to a datasource nice and easily from Spring DSL as well.
Something like this, its standard Spring stuff:
<bean id="sql" class="org.apache....SqlComponent"/>
<property name="dataSource" ref="myDataSource"/>
</bean>
Med venlig hilsen
Claus Ibsen
......................................
Silverbullet
Skovsgårdsvænget 21
8362 Hørning
Tlf. +45 2962 7576
Web: www.silverbullet.dk
-----Original Message-----
From: Reda [mailto:matteo.redaelli@libero.it]
Sent: 7. november 2008 19:42
To: camel-user@activemq.apache.org
Subject: Camel SQL Component & dataSource property
Hi
Reading http://activemq.apache.org/camel/sql-component.html I cannot
understand where I have to set the dataSource. I got
SEVERE: Failed: org.apache.camel.ResolveEndpointFailedException: Failed to
resolve endpoint: sql:select username as userid from mdl_user due to:
java.lang.IllegalArgumentException: Property 'dataSource' is required
org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint:
sql:select username as userid from mdl_user due to:
java.lang.IllegalArgumentException: Property 'dataSource' is required
with
<route>
<from uri="timer://pollTheDatabase?delay=10000" />
<setProperty propertyName="dataSource">
<constant>moodleDB</constant>
</setProperty>
<to uri="sql:select username as userid from mdl_user" />
</route>
and with
<route>
<from uri="timer://pollTheDatabase?delay=10000" />
<to uri="sql:select username as userid from
mdl_user?template.dataSource=moodleDB" />
</route>
where moodleDB is defined as
<bean id="moodleDB"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/moodle" />
<property name="username" value="moodle" />
<property name="password" value="moodle" />
</bean>
It would be nice to have an example for each camel component in "examples"
in the camel distribution...
Thanks in advance
Matteo
--
View this message in context: http://www.nabble.com/Camel-SQL-Component---dataSource-property-tp20386559s22882p20386559.html
Sent from the Camel - Users mailing list archive at Nabble.com.