Rafal Rusin wrote:
> I think the problem is that you need to configure jndi entry in App
> Server. Then you need to provide jndi path for it in deploy.xml. Let
> me know if you have problems with it.
>
> Sorry for late reply, I'm busy these days.
Dear Rafal,
Thank you for your kind answer. I have looked into that, and played
around with it. I have a few questions below. In the jndi resource
configured for ODE:
<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="mysql" password="pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"/>
</Context>
I understand that the context path "/ode" is for the web application,
i.e. ODE; the resource name "jdbc/ODEDB" is the jndi name and the url is
pointing to the actual database. I have played with that and I could
change the resource name to something else (both in server.xml and
ode-axis2.properties), but when I changed the url to another database,
it gave an error. Is this because url needs to point to a database with
the specific schema as provided by ODE? And I don't know what is the
role of ode-axis2.properties (In the tomcat documentation, they talk
about web.xml instead)? Finally, can I set up multiple resources for
multiple databases in the same way as above?
Ultimately, I want to be able to set up multiple external databases and
query those from my BPEL processes. I thought that I could do it by
setting up multiple jndi resources in tomcat, one for each database, and
use external variable feature of ODE to query those. Is that possible?
Sorry if many of my questions are obvious. I have just started on this
and the documentation on ODE website is not that comprehensive.
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.
