You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Roman Minko <rn...@gmail.com> on 2013/04/04 16:41:20 UTC
update persistence.properties for Syncope h2 database
I started syncope with h2 database on tomcat, and have noticed one detail
in persistence.properties:
The datasource use is in-memory h2 database. When tomcat goes down, DB
erased.
> jpa.url=jdbc:h2:mem:syncopedb;DB_CLOSE_DELAY=-1
I propose to set H2 create DB at least in user folder:
> jpa.url=jdbc:h2:~/syncopedb;DB_CLOSE_DELAY=-1
does it make sense?
Thank you,
Roman
Re: update persistence.properties for Syncope h2 database
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 04/04/2013 17:23, Roman Minko wrote:
> I think it is a bit confusing settings anyway,
> and yes, It will be useful to know how to change this.
> Good idea to describe it on wiki.
> As I get, we have this properties in war file. So only the way to make
> it persistent in tomcat is update deployed syncope apps?
> make changes
> \webapps\syncope\WEB-INF\classes\persistence.properties
> and restart syncope core
> Am I right?
It depends if you are running in embedded mode (as I was guessing
below): in this case you can just change in the source tree
core/src/test/resources/persistence.properties
If you are instead playing with the standalone distribution, you are right.
Regards.
> 2013/4/4 Francesco Chicchiriccò <ilgrosso@apache.org
> <ma...@apache.org>>
>
> On 04/04/2013 16:41, Roman Minko wrote:
> > I started syncope with h2 database on tomcat, and have noticed one
> > detail in persistence.properties:
> > The datasource use is in-memory h2 database. When tomcat goes
> down, DB
> > erased.
> > > jpa.url=jdbc:h2:mem:syncopedb;DB_CLOSE_DELAY=-1
> > I propose to set H2 create DB at least in user folder:
> > > jpa.url=jdbc:h2:~/syncopedb;DB_CLOSE_DELAY=-1
> > does it make sense?
>
> Hi Roman,
> I guess you are referring to the persistence configuration when
> running
> in embedded mode.
>
> Such configuration is currently derived from the one used by
> integration
> tests: hence the reason why H2 is configured in-memory.
>
> It could be an idea to add a note on the wiki pages [1] [2] saying
> something like "do you want to make it persistent? Just change this".
>
> WDYT?
>
> [1]
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+embedded+mode
> [2]
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+standalone+distribution
>
--
Francesco Chicchiriccò
ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/
Re: update persistence.properties for Syncope h2 database
Posted by Roman Minko <rn...@gmail.com>.
I think it is a bit confusing settings anyway,
and yes, It will be useful to know how to change this.
Good idea to describe it on wiki.
As I get, we have this properties in war file. So only the way to make it
persistent in tomcat is update deployed syncope apps?
make changes
\webapps\syncope\WEB-INF\classes\persistence.properties
and restart syncope core
Am I right?
Thank you,
Roman
2013/4/4 Francesco Chicchiriccò <il...@apache.org>
> On 04/04/2013 16:41, Roman Minko wrote:
> > I started syncope with h2 database on tomcat, and have noticed one
> > detail in persistence.properties:
> > The datasource use is in-memory h2 database. When tomcat goes down, DB
> > erased.
> > > jpa.url=jdbc:h2:mem:syncopedb;DB_CLOSE_DELAY=-1
> > I propose to set H2 create DB at least in user folder:
> > > jpa.url=jdbc:h2:~/syncopedb;DB_CLOSE_DELAY=-1
> > does it make sense?
>
> Hi Roman,
> I guess you are referring to the persistence configuration when running
> in embedded mode.
>
> Such configuration is currently derived from the one used by integration
> tests: hence the reason why H2 is configured in-memory.
>
> It could be an idea to add a note on the wiki pages [1] [2] saying
> something like "do you want to make it persistent? Just change this".
>
> WDYT?
>
> [1]
>
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+embedded+mode
> [2]
>
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+standalone+distribution
>
> --
> Francesco Chicchiriccò
>
> ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
> http://people.apache.org/~ilgrosso/
>
>
Re: update persistence.properties for Syncope h2 database
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 04/04/2013 16:41, Roman Minko wrote:
> I started syncope with h2 database on tomcat, and have noticed one
> detail in persistence.properties:
> The datasource use is in-memory h2 database. When tomcat goes down, DB
> erased.
> > jpa.url=jdbc:h2:mem:syncopedb;DB_CLOSE_DELAY=-1
> I propose to set H2 create DB at least in user folder:
> > jpa.url=jdbc:h2:~/syncopedb;DB_CLOSE_DELAY=-1
> does it make sense?
Hi Roman,
I guess you are referring to the persistence configuration when running
in embedded mode.
Such configuration is currently derived from the one used by integration
tests: hence the reason why H2 is configured in-memory.
It could be an idea to add a note on the wiki pages [1] [2] saying
something like "do you want to make it persistent? Just change this".
WDYT?
[1]
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+embedded+mode
[2]
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+standalone+distribution
--
Francesco Chicchiriccò
ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/