<div>Great,<br></div><div>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</div><br><div class="gmail_quote">On Tue, Oct 6, 2009 at 9:30 AM, Schliemann, Kai <span dir="ltr"><<a href="mailto:K.Schliemann@comundus.com">K.Schliemann@comundus.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="DE" link="blue" vlink="purple">
<div>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">Hi Ronen,</span></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></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></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">There are only two steps, you have to do:</span></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"><span>1.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">Edit your parents pom.xml</span></p>
<p style="margin-left:72.0pt"><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"><span>a.<span style="font:7.0pt "Times New Roman"">
</span></span></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></p>
<p style="margin-left:72.0pt"><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"><span>b.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">Change the jdbcDriver... tags
as well</span></p>
<p style="margin-left:72.0pt"><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"><span>c.<span style="font:7.0pt "Times New Roman"">
</span></span></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></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"><span>2.<span style="font:7.0pt "Times New Roman"">
</span></span></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></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"> </span></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></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></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">Just send us the files you changed.</span></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D">Best regards</span></p>
<p><span style="font-size:10.0pt;color:#FF7F00">_________________________________________</span></p>
<p><span style="font-size:7.5pt;color:gray"> </span></p>
<p><b><span style="font-size:10.0pt;color:gray">Kai Schliemann</span></b></p>
<p><span style="font-size:7.5pt;color:gray">Senior IT-Berater</span></p>
<p><span style="font-size:7.5pt;color:gray"> </span></p>
<p><b><span style="font-size:7.5pt;color:gray">comundus GmbH</span></b></p>
<p><span style="font-size:7.5pt;color:gray">Schüttelgrabenring 3, D-71332 Waiblingen</span></p>
<p><span style="font-size:7.5pt;color:gray">Telefon +49 7151-50028-0</span></p>
<p><span style="font-size:7.5pt;color:gray">E-Mail <a href="mailto:g.maas@comundus.com" target="_blank"><span style="color:blue">k.schliemann@comundus.com</span></a></span></p>
<p><span style="font-size:7.5pt;color:gray">Internet <a href="http://www.comundus.com/" target="_blank"><span style="color:blue">www.comundus.com</span></a></span></p>
<p><span style="font-size:10.0pt;color:#FF7F00"> </span></p>
<p><span style="font-size:7.5pt;color:gray">Geschäftsführer Klaus Hillemeier </span></p>
<p><span style="font-size:7.5pt;color:gray">Amtsgericht Stuttgart, HRB 264290</span></p>
<p><span style="font-size:7.5pt;color:gray"> </span></p>
<p><span style="font-size:7.5pt;color:gray">comundus ist ein Unternehmen der IT EXCELLENCE Group</span></p>
<p><span style="font-size:10.0pt;color:#FF7F00">_________________________________________</span></p>
<p><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span lang="EN-GB" style="font-size:11.0pt;color:#1F497D"> </span></p>
<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></p>
</div><div><div class="h5">
<p> </p>
<div>
<div>
<p>Hi,</p>
</div>
<div>
<p>Does opencms maven plugin work with Postgres as well? I saw
that the requirements in the documentation is MySql only.</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Thanks,</p>
</div>
<div>
<p>Ronen</p>
</div>
</div>
</div></div></div>
</div>
<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><br></blockquote></div><br>