Author: tolusha Date: 2010-07-06 06:30:32 -0400 (Tue, 06 Jul 2010) New Revision: 2744 Added: jcr/trunk/docs/userguide/en/src/main/docbook/en-US/modules/managed-datasources.xml Modified: jcr/trunk/docs/userguide/en/src/main/docbook/en-US/master.xml Log: EXOJCR-815: Document how to use AS Managed DataSource Modified: jcr/trunk/docs/userguide/en/src/main/docbook/en-US/master.xml =================================================================== --- jcr/trunk/docs/userguide/en/src/main/docbook/en-US/master.xml 2010-07-06 07:00:30 UTC (rev 2743) +++ jcr/trunk/docs/userguide/en/src/main/docbook/en-US/master.xml 2010-07-06 10:30:32 UTC (rev 2744) @@ -61,5 +61,8 @@ <xi:include href="modules/portal-container.xml" xmlns:xi="http://www.w3.org/2001/XInclude" /> + + <xi:include href="modules/managed-datasources.xml" + xmlns:xi="http://www.w3.org/2001/XInclude" /> </book> Added: jcr/trunk/docs/userguide/en/src/main/docbook/en-US/modules/managed-datasources.xml =================================================================== --- jcr/trunk/docs/userguide/en/src/main/docbook/en-US/modules/managed-datasources.xml (rev 0) +++ jcr/trunk/docs/userguide/en/src/main/docbook/en-US/modules/managed-datasources.xml 2010-07-06 10:30:32 UTC (rev 2744) @@ -0,0 +1,98 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN" +"http://www.oasis-open.org/docbook/xml/4.5/docbookx.dtd"> +<part> + <title>How to use AS Managed DataSource under JBoss AS</title> + + <chapter id="Introduction"> + <title>Configurations Steps</title> + + <important> + <para>Checked under Gatein 3.1.0-GA Final</para> + </important> + + <important> + <para>only no-tx-datasource is supported in JCR 1.12</para> + </important> + + <section id="Overview"> + <title>Declaring the datasources in the AS</title> + + <para>Under JBoss, just put a file XXX-ds.xml in the deploy server + (example: \server\default\deploy). In this file we will configure all + datasources which eXo will need. (there should be 4 named: + jdbcjcr_portal, jdbcjcr_portal-sample, jdbcidm_portal &amp; + jdbcidm_sample-portal).</para> + + <para>Example:<programlisting>&lt;?xml version="1.0" encoding="UTF-8"?&gt; +&lt;datasources&gt; + &lt;no-tx-datasource&gt; + &lt;jndi-name&gt;jdbcjcr_portal&lt;/jndi-name&gt; + &lt;connection-url&gt;jdbc:hsqldb:${jboss.server.data.dir}/data/jdbcjcr_portal&lt;/connection-url&gt; + &lt;driver-class&gt;org.hsqldb.jdbcDriver&lt;/driver-class&gt; + &lt;user-name&gt;sa&lt;/user-name&gt; + &lt;password&gt;&lt;/password&gt; + &lt;/no-tx-datasource&gt; + + &lt;no-tx-datasource&gt; + &lt;jndi-name&gt;jdbcjcr_sample-portal&lt;/jndi-name&gt; + &lt;connection-url&gt;jdbc:hsqldb:${jboss.server.data.dir}/data/jdbcjcr_sample-portal&lt;/connection-url&gt; + &lt;driver-class&gt;org.hsqldb.jdbcDriver&lt;/driver-class&gt; + &lt;user-name&gt;sa&lt;/user-name&gt; + &lt;password&gt;&lt;/password&gt; + &lt;/no-tx-datasource&gt; + + &lt;no-tx-datasource&gt; + &lt;jndi-name&gt;jdbcidm_portal&lt;/jndi-name&gt; + &lt;connection-url&gt;jdbc:hsqldb:${jboss.server.data.dir}/data/jdbcidm_portal&lt;/connection-url&gt; + &lt;driver-class&gt;org.hsqldb.jdbcDriver&lt;/driver-class&gt; + &lt;user-name&gt;sa&lt;/user-name&gt; + &lt;password&gt;&lt;/password&gt; + &lt;/no-tx-datasource&gt; + + &lt;no-tx-datasource&gt; + &lt;jndi-name&gt;jdbcidm_sample-portal&lt;/jndi-name&gt; + &lt;connection-url&gt;jdbc:hsqldb:${jboss.server.data.dir}/data/jdbcidm_sample-portal&lt;/connection-url&gt; + &lt;driver-class&gt;org.hsqldb.jdbcDriver&lt;/driver-class&gt; + &lt;user-name&gt;sa&lt;/user-name&gt; + &lt;password&gt;&lt;/password&gt; + &lt;/no-tx-datasource&gt; +&lt;/datasources&gt;</programlisting></para> + + <para>Which properties can be set for datasource can be found here: + <link + linkend="???">http://docs.jboss.org/jbossas/docs/Server_Conf... + </section> + + <section> + <title>Do not let eXo bind datasources explicitly</title> + + <para>Edit server/default/conf/gatein/configuration.properties and + comment out next rows in JCR section:</para> + + <programlisting>#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=</programlisting> + + <para>and in IDM section:</para> + + <programlisting>#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=</programlisting> + + <para>In jcr-configuration.xml and idm-configuration.xml comment out the + plugin InitialContextInitializer.</para> + + <programlisting>&lt;!-- Commented because, Datasources are declared and bound by AS, not in eXo --&gt; +&lt;!-- +&lt;external-component-plugins&gt; + [...] +&lt;/external-component-plugins&gt; +--&gt;</programlisting> + + <para>Running eXo after these configurations goes well.</para> + </section> + </chapter> +</part>