Ali We support dynamically loading the XML from a remote resource. In other words if the DBLookup config was in a separate XML, say on a webserver, then if its updated, the system will pick it up.
However, I don't think that is what you want! So.... Here is my suggestion: Create your own mediator class. This class can "new" a DBLookupMediator instance, and then dynamically set the DataSource, Statement, etc onto it. In your mediator you can then call dblookup.mediate(MessageContext). Does that make sense? Paul On 1/24/08, ali_khan <[EMAIL PROTECTED]> wrote: > > 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] > > -- Paul Fremantle Co-Founder and VP of Technical Sales, WSO2 OASIS WS-RX TC Co-chair blog: http://pzf.fremantle.org [EMAIL PROTECTED] "Oxygenating the Web Service Platform", www.wso2.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
