2 Replies Latest reply on Mar 9, 2012 12:36 PM by menjivar88

    Gatein with PostgreSQL

    menjivar88 Newbie

      Hello all,

       

      i'm configuring gatein to use postgresql as the database to store the jcr information, i have done this:

       

      1- I have my postgres's driver at:

       

           /jboss-as/server/production/lib

       

      2- at my /jboss-as/server/production/deploy/gatein-ds.xml i have:

          

      </local-tx-datasource>

            <jndi-name>gatein-jcr</jndi-name>

            <connection-url>jdbc:postgresql://192.168.10.20:5432/jcrdb</connection-url>

            <driver-class>org.postgresql.Driver</driver-class>

            <user-name>gateinuser</user-name>

            <password>jboss</password>

       

            <min-pool-size>5</min-pool-size>

            <max-pool-size>20</max-pool-size>

            <idle-timeout-minutes>0</idle-timeout-minutes>

            <prepared-statement-cache-size>32</prepared-statement-cache-size>

      </local-tx-datasource>

       

      3- at my configuration.properties file i have included

       

           gatein.idm.datasource.dialect=pgsql

       

      4- I have added the next line to each <lock-manager class=...> in the file: server/production/deploy/gatein.ear/02portal.war/web-inf/conf/jcr/repository-configuration.xml

       

           <property name="jbosscache-cl-cache.jdbc.node.type" value="bytea" />

       

           I found just 3 of these lock-manager

       

      What else should i do to configurate it ?? or is this ok??

       

      thanks and regards!

      Carlos

        • 1. Re: Gatein with PostgreSQL
          Nicolas Filotto Novice

          I'm confused, I don't see any cluster profile in GateIn 3.2.0.Final by default how did you get/create it? Moreover even in the default profile as far as I can see GateIn is configured to create the datasources itself instead of using those of the application server according to my configuration.properties:

           

          gatein.jcr.datasource.name=java:jdbcjcr

          gatein.jcr.datasource.dialect=auto

          gatein.jcr.datasource.driver=org.hsqldb.jdbcDriver

          gatein.jcr.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcjcr_${name}

          gatein.jcr.datasource.username=sa

          gatein.jcr.datasource.password=

          ...

          gatein.idm.datasource.name=java:jdbcidm

          gatein.idm.datasource.driver=org.hsqldb.jdbcDriver

          gatein.idm.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcidm_${name}

          gatein.idm.datasource.username=sa

          gatein.idm.datasource.password=

           

          Can you please clarify which product you really have?

           

          If you have a product like EPP 5.2 that is configured to use the datasources created by the AS for me the  steps #1 and #2 are enough assuming that in step #2 you also configure the datasource gatein-idm

          1 of 1 people found this helpful
          • 2. Re: Gatein with PostgreSQL
            menjivar88 Newbie

            Well i'm using JEPP 5.2 and thanks for the response, and i got no errors using this configuration.

             

            Regards.

            Carlos