Hello! I've just added the information to the wiki page. Hope it will help :)
Romek 2008/11/8 Claus Ibsen <[EMAIL PROTECTED]>: > 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:[EMAIL PROTECTED] > 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. > >
