[opencms-dev] OpenCms maven plugin with Postgres?

[Schliemann, Kai]

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 <mailto:g.maas at comundus.com> 

Internet www.comundus.com <http://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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091006/59b3f8d5/attachment.htm>