hi,
below is a section of my synapse configuration file:
..
....
<dblookup>
<connection>
<pool>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/userdatabase</url>
<user>gge</user>
<password>Tes9t</password>
</pool>
</connection>
<statement>
<sql>select * from company where name=?</sql>
<parameter
expression="//m0:getQuote/m0:request/m0:symbol"
xmlns:m0="http://services.samples/xsd";
type="VARCHAR"/>
<result name="company_id" column="id"/>
</statement>
</dblookup>
....
..
As per the above configuration I want to provide a dynamic sql in place of
the static sql so that I am able to add parameters though a java program.
Is there any method by which I can access this sql in a java program and set
it there itself?
please suggest.
--
View this message in context:
http://www.nabble.com/creating-dynamic-sql-in-synapse-configuration-file-tp15063625p15063625.html
Sent from the Synapse - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
