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/
