[opencms-dev] Separate database with OpenCms

[Alexander Wallace]

You can use any driver in the class path, and sure you can create a separate 
datasource pointing to a different database or server... It seems to me that 
you want to access from within pages in opencms some data in a different 
db... If that is the case, you can setup your own connection pool using the 
standard app server methods and use jndi to get a hold of it...  This is to 
say, you can do it as if you were doing it with any other java app...

On Wednesday 11 May 2005 07:49 am, Enrico Ballarin Dolfin wrote:
> 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
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>