Hi all,
I'm trying to access mysql database from inside BPEL process using JDBC
external variable as instructed on the ODE website. I have done the
following:
* Insert the following in the Tomcat server file, inside the Host element:
<Context path="/ode" docBase="ode" debug="5" reloadable="true"
crossContext="true">
<Resource name="jdbc/ODEDB" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="username" password="pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
</Context>
<Context path="/test" docBase="test" debug="5" reloadable="true"
crossContext="true">
<Resource name="jdbc/ODEDB" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="username" password="pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test?autoReconnect=true"/>
</Context>
* Declare the following in deploy.xml file:
<xvar:externalVariable id="evar1" >
<jdbc:jdbc
xmlns:jdbc="http://ode.apache.org/externalVariables/jdbc";
xmlns="http://ode.apache.org/externalVariables/jdbc";>
<datasource-ref>test</datasource-ref>
<table>shop</table>
<column name="article"
key="yes" />
<column name="dealer" />
<column name="price" />
</jdbc:jdbc>
</xvar:externalVariable>
* Declare the following in wsdl file:
<element name="DBRow">
<complexType>
<sequence>
<element name="_article" type="int"/>
<element name="_dealer" type="string"/>
<element name="_price" type="double"/>
</sequence>
</complexType>
</element>
* And finally, declare an external variable in bpel file:
<bpel:variable name="tmp" element="tns:DBRow"
xvar:id="evar1"></bpel:variable>
However, I keep getting the following errors when deploying it:
ERROR - GeronimoLog.error(104) |
file:/usr/lib/apache-tomcat-5.5.27/webapps/ode/WEB-INF/processes/temp/test.bpel:44:
error: [MustSpecifyRelatedVariable] The external variable declaration
for "tmp" must specify a related variable.
ERROR - GeronimoLog.error(104) |
file:/usr/lib/apache-tomcat-5.5.27/webapps/ode/WEB-INF/processes/temp/test.bpel:77:
error: [UndeclaredVariable] Attempt to reference undeclared variable "tmp".
Would someone please point out where I went wrong, or point me to an
example on using external variable to access mysql from a BPEL process?
Thanks in advance.
Hoang
UTS CRICOS Provider Code: 00099F
DISCLAIMER: This email message and any accompanying attachments may contain
confidential information. If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments. If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with authority,
states them to be the views of the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.
Think. Green. Do.
Please consider the environment before printing this email.
