<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@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:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Ronen,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>that’s great. </span><span lang=EN-GB style='font-size:
11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks in advance. Using
profiles sounds very good.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Looking forward to the Postgres version.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regards<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#FF7F00'>_________________________________________<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'> </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>Kai Schliemann</span></b><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Senior IT-Berater</span><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'> </span><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>comundus GmbH</span></b><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Schüttelgrabenring 3, D-71332 Waiblingen</span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Telefon +49 7151-50028-0</span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>E-Mail <a href="mailto:g.maas@comundus.com">k.schliemann@comundus.com</a></span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Internet <a href="http://www.comundus.com/">www.comundus.com</a></span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#FF7F00'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Geschäftsführer Klaus Hillemeier </span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>Amtsgericht Stuttgart, HRB 264290</span><span style='font-size:
10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'> </span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#FF7F00'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>comundus ist ein Unternehmen der IT EXCELLENCE Group<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#FF7F00'>_________________________________________<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b>Im
Auftrag von </b>Ronen<br>
<b>Gesendet:</b> Mittwoch, 7. Oktober 2009 06:09<br>
<b>An:</b> The OpenCms mailing list<br>
<b>Betreff:</b> Re: [opencms-dev] OpenCms maven plugin with Postgres?<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>Great,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I'll do that and share it the minute I finish. Probably best
thing will be to create profiles, one for MySql and one for Postgres<o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal>On Tue, Oct 6, 2009 at 9:30 AM, Schliemann, Kai <<a
href="mailto:K.Schliemann@comundus.com">K.Schliemann@comundus.com</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Hi Ronen,</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>as most of the
OpenCms users use a MySQL database for their OpenCms installation, we decided
to firstly make our plugin work with MySQL. And we have no plans right now to
add other databases.</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Nevertheless if you
want to use another DBMS, it is not that complicated.</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>There are only
two steps, you have to do:</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>1.</span><span
lang=EN-GB style='font-size:7.0pt;color:#1F497D'>
</span><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Edit your
parents pom.xml</span><o:p></o:p></p>
<p style='margin-left:72.0pt'><span lang=EN-GB style='font-size:11.0pt;
color:#1F497D'>a.</span><span lang=EN-GB style='font-size:7.0pt;color:#1F497D'>
</span><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Change the
opencms.db... tags to your corresponding connection settings (you can
copy/paste them from the original setup files)</span><o:p></o:p></p>
<p style='margin-left:72.0pt'><span lang=EN-GB style='font-size:11.0pt;
color:#1F497D'>b.</span><span lang=EN-GB style='font-size:7.0pt;color:#1F497D'>
</span><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Change the
jdbcDriver... tags as well</span><o:p></o:p></p>
<p style='margin-left:72.0pt'><span lang=EN-GB style='font-size:11.0pt;
color:#1F497D'>c.</span><span lang=EN-GB style='font-size:7.0pt;color:#1F497D'>
</span><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>In the plugins
section change the dependency for the opencms-vfs-plugin to something similar
like the following lines:<br>
<dependency><br>
<groupId>postgresql</groupId><br>
<artifactId>postgresql</artifactId><br>
<version>8.1-407.jdbc3</version><br>
</dependency><br>
(check on <a href="http://www.mvnbrowser.com" target="_blank">www.mvnbrowser.com</a>
or <a href="http://www.ibiblio.org" target="_blank">www.ibiblio.org</a> how
your dependency section must look like)</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>2.</span><span
lang=EN-GB style='font-size:7.0pt;color:#1F497D'>
</span><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>change the
create_tables.sql and drop_tables.sql scripts in your webapp’s pom.xml
(you can copy/paste them from the original setup files).</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>If you are
interested in trying it and you have any questions, please don’t hesitate
to ask. We try to support you as good as we can.</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>When you are
finished, it would be nice, when you would share the PostgreSQL version of the
plugin with the community.</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Just send us the
files you changed.</span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'>Best regards</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;color:#FF7F00'>_________________________________________</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'> </span><o:p></o:p></p>
<p><b><span style='font-size:10.0pt;color:gray'>Kai Schliemann</span></b><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Senior IT-Berater</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'> </span><o:p></o:p></p>
<p><b><span style='font-size:7.5pt;color:gray'>comundus GmbH</span></b><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Schüttelgrabenring 3, D-71332
Waiblingen</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Telefon +49 7151-50028-0</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>E-Mail <a
href="mailto:g.maas@comundus.com" target="_blank">k.schliemann@comundus.com</a></span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Internet <a
href="http://www.comundus.com/" target="_blank">www.comundus.com</a></span><o:p></o:p></p>
<p><span style='font-size:10.0pt;color:#FF7F00'> </span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Geschäftsführer Klaus Hillemeier
</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>Amtsgericht Stuttgart, HRB 264290</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>
</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;color:gray'>comundus ist ein Unternehmen der IT
EXCELLENCE Group</span><o:p></o:p></p>
<p><span style='font-size:10.0pt;color:#FF7F00'>_________________________________________</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span lang=EN-GB style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p> <o:p></o:p></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p><b><span style='font-size:10.0pt'>Von:</span></b><span style='font-size:
10.0pt'> <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>
[mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>]
<b>Im Auftrag von </b>Ronen<br>
<b>Gesendet:</b> Sonntag, 4. Oktober 2009 11:00<br>
<b>An:</b> <a href="mailto:opencms-dev@opencms.org" target="_blank">opencms-dev@opencms.org</a><br>
<b>Betreff:</b> [opencms-dev] OpenCms maven plugin with Postgres?</span><o:p></o:p></p>
</div>
<div>
<div>
<p> <o:p></o:p></p>
<div>
<div>
<p>Hi,<o:p></o:p></p>
</div>
<div>
<p>Does opencms maven plugin work with Postgres as well? I saw that the
requirements in the documentation is MySql only.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Thanks,<o:p></o:p></p>
</div>
<div>
<p>Ronen<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal><br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>