OpenCms maven plugin with Postgres?

[Ronen Naor-5]

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

[Kai Schliemann]

Some parts of this message have been removed. Learn more about Nabble's security policy.

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 [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Ronen
Gesendet: Sonntag, 4. Oktober 2009 11:00
An: opencms-dev@...
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

[Ronen Naor-5]

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@...> 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 [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Ronen
Gesendet: Sonntag, 4. Oktober 2009 11:00
An: opencms-dev@...
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

_______________________________________________
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

[Kai Schliemann]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ronen,

that’s great. Thanks in advance. Using profiles sounds very good.

Looking forward to the Postgres version.

 

Regards

_________________________________________

  

Kai Schliemann

Senior IT-Berater

   

comundus GmbH

Schüttelgrabenring 3, D-71332 Waiblingen

Telefon [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Ronen
Gesendet: Mittwoch, 7. Oktober 2009 06:09
An: The OpenCms mailing list
Betreff: Re: [opencms-dev] OpenCms maven plugin with Postgres?

 

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@...> 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 [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Ronen
Gesendet: Sonntag, 4. Oktober 2009 11:00
An: opencms-dev@...
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

 

_______________________________________________
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

Some parts of this message have been removed. Learn more about Nabble's security policy.

I use the vfs:sync goal to synchronize changes made in my lokal filesystem to the VFS. But OpenCms doesn't notice these changes. I guess the running OpenCms instance doesn't get notified about the changed jsp in the database. Any ideas how to solve this problem? Calling the Cache Flushing Tool for the JSP repository vom the administration view helps, but would it be possible to automate this?

 

Regards

Chris

 

 

_______________________________________________
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

[Kai Schliemann]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Chris,

we are aware of this problem but haven’t had time to fix it. It is a problem of our maven-vfs-plugin.  I hope we can fix it with the next version of our plugin.

As a workaround, you can add the following request parameter to the page you are requesting:

_flex=recompile

This will clear the cache every time you load the page.

 

HTH

 

Regards

_________________________________________

  

Kai Schliemann

Senior IT-Berater

   

comundus GmbH

Schüttelgrabenring 3, D-71332 Waiblingen

Telefon [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Christian.Weber@...
Gesendet: Freitag, 9. Oktober 2009 15:13
An: opencms-dev@...
Betreff: [opencms-dev] OpenCms maven plugin: vfs:sync and flusing the jspcache

 

I use the vfs:sync goal to synchronize changes made in my lokal filesystem to the VFS. But OpenCms doesn't notice these changes. I guess the running OpenCms instance doesn't get notified about the changed jsp in the database. Any ideas how to solve this problem? Calling the Cache Flushing Tool for the JSP repository vom the administration view helps, but would it be possible to automate this?

 

Regards

Chris

 

 

_______________________________________________
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

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Kai

what about the followin solutiong: After calling vfs:sync the JSP cache could be flushed by doing a http get on the running OpenCms instance.

Regard

Chris

 

 

---

Von: opencms-dev-bounces@... [mailto:opencms-dev-bounces@...] Im Auftrag von Schliemann, Kai
Gesendet: Montag, 12. Oktober 2009 12:05
An: The OpenCms mailing list
Betreff: Re: [opencms-dev] OpenCms maven plugin: vfs:sync and flusing thejspcache

Hi Chris,

we are aware of this problem but haven’t had time to fix it. It is a problem of our maven-vfs-plugin.  I hope we can fix it with the next version of our plugin.

As a workaround, you can add the following request parameter to the page you are requesting:

_flex=recompile

This will clear the cache every time you load the page.

 

HTH

 

Regards

_________________________________________

  

Kai Schliemann

Senior IT-Berater

   

comundus GmbH

Schüttelgrabenring 3, D-71332 Waiblingen

Telefon [phone]

E-Mail g.maas@...

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@... [mailto:opencms-dev-bounces@...] Im Auftrag von Christian.Weber@...
Gesendet: Freitag, 9. Oktober 2009 15:13
An: opencms-dev@...
Betreff: [opencms-dev] OpenCms maven plugin: vfs:sync and flusing the jspcache

 

I use the vfs:sync goal to synchronize changes made in my lokal filesystem to the VFS. But OpenCms doesn't notice these changes. I guess the running OpenCms instance doesn't get notified about the changed jsp in the database. Any ideas how to solve this problem? Calling the Cache Flushing Tool for the JSP repository vom the administration view helps, but would it be possible to automate this?

 

Regards

Chris

 

 

_______________________________________________
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