-
1. Re: Tweaking the Wiki sample application
ken2 Dec 15, 2008 1:18 PM (in response to hubaghdadi)
Hussein Baghdadi wrote on Dec 15, 2008 10:18:
Hey,
We want to install Seam Wiki sample application in our unit.
Our database isPostgreSQL 8.3
Is it possible to tweak the Wiki sample application to generate PostgreSQL DDL files instead of the default which it is MySQL?
Thanks.I want to have Wiki example working with PostgreSQL, too!!
-
2. Re: Tweaking the Wiki sample application
hubaghdadi Dec 15, 2008 1:35 PM (in response to hubaghdadi)Lets raise a JIRA issue :D
Seriously, the question is still open.
-
3. Re: Tweaking the Wiki sample application
hubaghdadi Dec 22, 2008 12:26 PM (in response to hubaghdadi)I changed the Hibernate dialect to PostgreSQL (persistence-prod-war.xml) and then tried to build the project, but I got this exception:
Dialect doesn't support pooled sequences
Any help amigos?
-
4. Re: Tweaking the Wiki sample application
ken2 Dec 23, 2008 9:04 AM (in response to hubaghdadi)Yes, as far as I know, hibernate bundled with seam does not support pooled sequence for PostgreSQL, I am not sure if it supports other DB's, though.
I am not sure what happen if we abolish pooled sequence and put it back to ordinary sequence - org.jboss.seam.wiki.core.model/package-info.java and its friends. Is it only the speed - response time issue?
Are there any plan to support pooled sequence for PostgreSQL with hibernate soon?
-
5. Re: Tweaking the Wiki sample application
hubaghdadi Dec 23, 2008 9:37 AM (in response to hubaghdadi)This is my new package-info.java
@GenericGenerator( name = "wikiSequenceGenerator", strategy = "sequence", parameters = { @Parameter(name = "sequence_name", value = "WIKI_SEQUENCE"), @Parameter(name = "initial_value", value = "1000"), @Parameter(name = "increment_size", value = "1") } )
But I still get the same exception.