<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks Nacho. I think I
follow. I loaded and configured the OpenCms module developer and am able
to connect to the database and I am thinking this is the best way to develop
modules. Can you comment on this please?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>-Jose<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Nacho Fernandez<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, September 25, 2008
5:13 AM<br>
<b><span style='font-weight:bold'>To:</span></b> The OpenCms mailing list<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [opencms-dev] best
approach</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi Jose and list,<br>
<br>
The recommended approach to using additional database tables is not using the
OpenCms database but creating a different dabatase for your application/module.
That other database can be then accessed two ways:<br>
<br>
1.- Granting permissions to the database user that controls OpenCms (by default
called "opencms") on the new database you created and using OpenCms
API to get a connection for the standard OpenCms database pool.<br>
2.- Defining a separate database pool with the right data (that database can be
even by a different vendor, for instance an Oracle database different to the
MySQL where you may have installed OpenCms) and once again getting connections
through OpenCms API but this time from that other pool. For this approach I
suggest you read this nice wiki article: <a
href="http://opencms-wiki.org/Using_OpenCms%27s_Database_connection_pool">http://opencms-wiki.org/Using_OpenCms%27s_Database_connection_pool</a>
. By the way, the last part of the article shows you how to get data from a
database pool in OpenCms and that should be useful to you even if you choose
the first approach.<br>
<br>
I hope it helps. Greetings,<br>
<br>
Nacho.<o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>