[opencms-dev] OpenCms maven plugin with Postgres?

[Ronen]

Great,
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

On Tue, Oct 6, 2009 at 9:30 AM, Schliemann, Kai
<K.Schliemann at comundus.com>wrote:

>  Hi Ronen,
>
> 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.
>
> Nevertheless if you want to use another DBMS, it is not that complicated.
>
> There are only  two steps, you have to do:
>
> 1.       Edit your parents pom.xml
>
> a.       Change the opencms.db... tags to your corresponding connection
> settings (you can copy/paste  them from the original setup files)
>
> b.      Change the jdbcDriver... tags as well
>
> c.       In the plugins section change the dependency for the
> opencms-vfs-plugin to something similar like the following lines:
> <dependency>
>     <groupId>postgresql</groupId>
>     <artifactId>postgresql</artifactId>
>      <version>8.1-407.jdbc3</version>
> </dependency>
> (check on www.mvnbrowser.com or www.ibiblio.org how your dependency
> section must look like)
>
> 2.       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).
>
>
>
> 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.
>
> When you are finished, it would be nice, when you would share the
> PostgreSQL version of the plugin with the community.
>
> Just send us the files you changed.
>
>
>
> Best regards
>
> _________________________________________
>
>
>
> *Kai Schliemann*
>
> Senior IT-Berater
>
>
>
> *comundus GmbH*
>
> Schüttelgrabenring 3, D-71332 Waiblingen
>
> Telefon +49 7151-50028-0
>
> E-Mail k.schliemann at comundus.com <g.maas at comundus.com>
>
> Internet www.comundus.com
>
>
>
> Geschäftsführer Klaus Hillemeier
>
> Amtsgericht Stuttgart, HRB 264290
>
>
>
> comundus ist ein Unternehmen der IT EXCELLENCE Group
>
> _________________________________________
>
>
>
>
>
>
>
> *Von:* opencms-dev-bounces at opencms.org [mailto:
> opencms-dev-bounces at opencms.org] *Im Auftrag von *Ronen
> *Gesendet:* Sonntag, 4. Oktober 2009 11:00
> *An:* opencms-dev at opencms.org
> *Betreff:* [opencms-dev] OpenCms maven plugin with Postgres?
>
>
>
> Hi,
>
> Does opencms maven plugin work with Postgres as well? I saw that the
> requirements in the documentation is MySql only.
>
>
>
> Thanks,
>
> Ronen
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091007/6f18d89f/attachment.htm>