[opencms-dev] Separate database with OpenCms

[Enrico Ballarin Dolfin]

Steve,

I have found in the 2004 OpenCms archives your answer to a question of another 
user:

> Steve <steve.welsh at redplanetuk.com> wrote:
> Yes, I suppose you could. Sorry, I thought you wanted to use a separate
> database for your jsp application, rather than use the OpenCms one. I
> prefer to use a separate database whenever possible for any client
> specific application - I find it makes upgrades and deployments much
> simpler.
> 
> Steve,
> 
> REDPlanet Technologies Ltd,
> Salters House, Salters Lane Ind. Est., Sedgefield, Stockton-on-Tees,
> TS21 3EE
> 
> www.redplanetuk.com
> Tel +44 (1740) 625222 

We would like to migrate a Web application that uses an own mysql database to 
OpenCms. What we need is to access from OpenCms also this separate database 
using java in JSP templates (we are using Tomcat as servlet engine).

To do this I have a few questions:

OpenCms uses a special jdbc driver to access its own mysql database.
In the configuration file opencms.property there is the configuration of the 
default database pool with jdbcDriver, jdbcUrl, jdbcUrl.params, user, 
password etc. The tomcat configuration file server.xml seems not to be 
explicitly configured for opencms.

1) Can I use the same jdbc driver (with a second configuration) to access the 
separate database? Do I need a second driver (maybe the standard one)?

2) Where and how do I have to configure the driver to access the separate 
database?

3) Do I have to configure a separate database pool? Where and how?

Thanks a lot in advance
Enrico
---
InnoPark - Schweiz
Fernfachhochschule Schweiz
Jägerstrasse 2
8406 Winterthur

Tel: +41 (0)52 260 59 59
Fax: +41 (0)52 260 59 50
www.innopark.ch