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
