Sorry, forgot the link. [1] http://blog.mpathirage.com/2009/10/04/data-services-or-external-variables-with-jdbc-mapping/
<http://blog.mpathirage.com/2009/10/04/data-services-or-external-variables-with-jdbc-mapping/> Thanks Milinda On Wed, Jul 14, 2010 at 5:06 PM, Milinda Pathirage < [email protected]> wrote: > Hi Christian, > > I think it's best to use some kind of a tool which provides support for > exposing data in a database as a web service in your situation. Because you > want be able to do advance database operations using external variables and > you can get more features than that if you use external data services tool. > I have discuss this issue here[1]. Please refer it if you need more > information. I may be wrong, but it's better if you can separate out > database querying logic from the BPEL process. > > Thanks > Milinda > > > On Tue, Jul 13, 2010 at 2:21 PM, Tammo van Lessen <[email protected]>wrote: > >> In the bpel-runtime package? In Derby? But I don't think there is a need >> to compile this class. >> >> If you're looking for an example schema for extvars, then look at the >> SQL statements in this class. >> >> Tammo >> >> On 13.07.2010 10:39, Christian Bruckhoff wrote: >> > Hi. >> > >> > Am 12.07.2010 16:43, schrieb Tammo van Lessen: >> >> Hi, >> >> >> >> please see here: >> >> >> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java >> >> >> >> >> >> It creates the schema for the testrun. >> >> >> >> Tammo >> > >> > Where do I find the other classes needed: >> > >> > import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource; >> > import org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule; >> > >> > Greetings >> > Christian >> > >> >> On 12.07.2010 12:00, Christian Bruckhoff wrote: >> >>> Hi. >> >>> >> >>> Am 21.06.2010 15:46, schrieb Rafal Rusin: >> >>>> You can write too, but apparently there's no guide for this. You can >> >>>> check out ExtVar* test processes to grab some info: >> >>>> >> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/resources/bpel/2.0/ >> >>>> >> >>>> >> >>> >> >>> Is there a sql schema for the testdb of the ExtVar examples? >> >>> >> >>> Greeting >> >>> Christian >> >> >> >> -- >> Tammo van Lessen - http://www.taval.de >> > > > > -- > Milinda Pathirage > Technical Lead & Product Manager WSO2 BPS; http://wso2.org/bps > WSO2 Inc.; http://wso2.com > E-mail: [email protected], [email protected] > Web: http://mpathirage.com > Blog: http://blog.mpathirage.com > -- Milinda Pathirage Technical Lead & Product Manager WSO2 BPS; http://wso2.org/bps WSO2 Inc.; http://wso2.com E-mail: [email protected], [email protected] Web: http://mpathirage.com Blog: http://blog.mpathirage.com
