[opencms-dev] Separate database with OpenCms

[Alexander Wallace]

On Wednesday 11 May 2005 09:24 am, Enrico Ballarin Dolfin wrote:

> The definitions of the datasource and data pool for opencms seem not to be 
in 
> server.xml or web.xml. Do I have to define an additional database pool (e.g. 
> application) in the file opencms.properties like this?
> 
I would just create a datasource using my app server, in jboss, creating a 
-ds.xml file and then setting the appropiate config in web.xml and 
jboss-web.xml and web.xml

In tomcat you can do it in several places (server.xml, context.xml in META-INF 
or use the admin app)...

then create a class or jsp code to get the connection from your new pool

> 
> 
--------------------------------------------------------------------------------------------------------------------------------------- 
> #
> # Declaration of database pools
> 
#################################################################################
> db.pools=default, application
> 
> #
> # Configuration of the default database pool
> 
#################################################################################
> ...
> ...
> 
> #
> # Configuration of the application specific database pool
> 
#################################################################################
> # name of the JDBC driver
> db.pool.application.jdbcDriver=org.gjt.mm.mysql.Driver
> 
> # URL of the JDBC driver
> db.pool.application.jdbcUrl=jdbc:mysql://localhost:3306/appdb
> 
> # optional parameters for the URL of the JDBC driver
> 
db.pool.application.jdbcUrl.params=?useUnicode\=true&characterEncoding\=UTF-8
> 
> # user name to connect to the database
> db.pool.application.user=appuser
> 
> # password to connect to the database
> db.pool.application.password=*********
> 
> # the URL to make the JDBC DriverManager return connections from the DBCP 
pool
> db.pool.application.poolUrl=opencms:application 
> ...
> ...
> 
---------------------------------------------------------------------------------------------------------------------------------------
> 
> and then to try something like this?
> 
> > <%@page import="java.sql.*,org.OpenCms.db.*,org.OpenCms.main.*"%>
> > <%
> >
> > java.sql.Connection con =
> > OpenCms.getSqlManager().getConnection(CmsDbPool.getDbPoolName(map, 
> "application"));
> >
> > // do something
> >
> > con.close();
> >
> > %>
> 
> Thanks
> Enrico
> 
> >
> > On Wednesday 11 May 2005 07:49 am, Enrico Ballarin Dolfin wrote:
> > >
> > > 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
>