Tweaking the Wiki sample application

[hubaghdadi]

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.

[ken2]

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!!

[hubaghdadi]

Lets raise a JIRA issue :D

Seriously, the question is still open.

[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?

[ken2]

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?

[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.