Thanks,
do you mean :
<sm:activationSpec componentName="fileWriter" service="foo:fileWriter">
<sm:component>
<bean class="org.apache.servicemix.components.jdbc.JdbcComponent">
<sql>select p.id from product p where p.name='foo'</sql>
</bean>
</sm:component>
</sm:activationSpec>
when i try this , a have this error
error: javax.jbi.messaging.MessagingException:
java.lang.IllegalStateException: Expecting <sql></sql> node. Found: null
Regards,
Abdes
bsnyder wrote:
>
> On 3/21/07, Abdeslam El Abbassi <[EMAIL PROTECTED]>
> wrote:
>>
>> hi,
>> i try to access database by using the jdbc component.
>>
>> my configuration :
>>
>> <bean class="org.apache.servicemix.components.jdbc.JdbcComponent">
>> <property name="dataSource" ref="oracle-ds" />
>> </bean>
>> <sm:activationSpec componentName="fileWriter" service="foo:fileWriter">
>> <sm:component>
>> <bean class="org.apache.servicemix.components.jdbc.JdbcComponent">
>> </bean>
>> </sm:component>
>> </sm:activationSpec>
>>
>> How to pass the query (SQL) to the JdbcComponent ?
>
> The SQL is a JBI message that is sent to the component wrapped in
> <sql> elements. Below is an example:
>
> <sql>
> select p.id from product p where p.name='foo'
> </sql>
>
> Bruce
> --
> perl -e 'print
> unpack("u30","D0G)[EMAIL PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
> );'
>
> Apache Geronimo - http://geronimo.apache.org/
> Apache ActiveMQ - http://activemq.org/
> Apache ServiceMix - http://servicemix.org/
> Castor - http://castor.org/
>
>
--
View this message in context:
http://www.nabble.com/using-JdbcComponent-tf3442012s12049.html#a9611228
Sent from the ServiceMix - User mailing list archive at Nabble.com.
