Topic
No replies
jbrasileiro
jbrasileiro
1 Post
ACCEPTED ANSWER

Pinned topic Spring Integration - WebService - SELECT before Webservice consultar no

‏2012-09-21T16:05:16Z |
Hi people,

I need some help here... I'm trying to use Spring Integration.
I need to do the following:
  • I need to query db to get information about a specific objects.
  • From this result i need to pass to a channel and them execute the service to send the xml in order to get the response and save it.

Does someone could help me here?
I'm trying to use it:

code

<jdbc:inbound-channel-adapter query="select * from envios where :idTipoStatus = 0"
channel="NChannel" data-source="dataSource" sql-parameter-source-factory="spelSource">
<poller fixed-rate="1000">
<transactional />
</poller>
</jdbc:inbound-channel-adapter>

<bean id="spelSource"
class="o.s.integration.jdbc.ExpressionEvaluatingSqlParameterSourceFactory">
<property name="parameterExpressions">
<map>
<entry key="idTipoStatus" value="0"/>
</map>
</property>
</bean>
[/code]
but it isn't working....
Erro: The prefix "jdbc" for element "jdbc:inbound-channel-adapter" is not bound.

application-context.xml:
code

<!-- INTEGRATION CHANNELS -->

<poller id="defaultPoller" default="true" max-messages-per-poll="5"
fixed-rate="${fixed.rate}" />

<file:inbound-channel-adapter directory="${input.folder}"
scanner="directoryScanner" channel="fileInput" auto-create-directory="true"
prevent-duplicates="false" />

<file:outbound-gateway id="gateway" directory="${backup.folder}"
delete-source-files="true" request-channel="fileInput" reply-channel="fileQueue"
filename-generator="fileNameGenerator" auto-create-directory="true" />

<channel id="fileInput">
<interceptors>
<ref bean="fileInputInterceptor" />
</interceptors>
</channel>

<channel id="fileQueue">
<queue capacity="300" />
</channel>

<chain input-channel="fileQueue" output-channel="replyChannel">
<file:file-to-string-transformer
charset="UTF-8" />
<service-activator ref="MessageSaver" method="saveInputMessageSend" />
<service-activator ref="Validator" method="validate" />
<transformer ref="transformer" method="transformXML" />
<service-activator ref="webServiceCaller" method="callWebService" />
</chain>

<!-- ############################## -->
<!-- Handling ReplyChannel -->
<!-- ############################## -->
<channel id="replyChannel">
<queue capacity="300" />
</channel>

<chain input-channel="replyChannel" output-channel="outputChannel">
<transformer ref="genericResponseTransformer" method="transformGenericFile" />
<service-activator ref="MessageSaver" method="saveInfo" />
</chain>

<file:outbound-channel-adapter id="outputChannel"
directory="${output.folder}" filename-generator="fileNameGenerator" />

<publish-subscribe-channel id="successfulFileWriter" />
<publish-subscribe-channel id="failedFileWritter" />

<chain input-channel="failedFileTransforming" output-channel="failedFileWritter">
<transformer ref="exceptionMessageTransformer" method="transformFromExceptionMessage" />
</chain>

<!-- ############################## -->
<!-- Verify and Calling WebService To Get InputFile -->
<!-- ############################## -->
<!-- ############################## -->
<!-- Receiving XML to send to webService -->
<!-- ############################## -->
<channel id="newChannel">
<queue capacity="300" />
</channel>

<chain input-channel="newChannel" output-channel="outputChannel">
<service-activator ref="MessageSaver" method="saveReplySend" />
</chain>
<file:outbound-channel-adapter id="outputChannel" filename-generator="fileNameGenerator"
directory="${output.folder}"/>
[/code]