From portal-commits at lists.jboss.org Sun Feb 3 23:12:45 2008 Content-Type: multipart/mixed; boundary="===============7286324002235809250==" MIME-Version: 1.0 From: portal-commits at lists.jboss.org To: portal-commits at lists.jboss.org Subject: [portal-commits] JBoss Portal SVN: r9725 - docs/branches/JBoss_Portal_Branch_2_6/referenceGuide/en/modules. Date: Sun, 03 Feb 2008 23:12:45 -0500 Message-ID: --===============7286324002235809250== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Author: mmcallis Date: 2008-02-03 23:12:45 -0500 (Sun, 03 Feb 2008) New Revision: 9725 Modified: docs/branches/JBoss_Portal_Branch_2_6/referenceGuide/en/modules/installa= tion.xml Log: updating 2.3.4. Database Setup 2.3.5. Datasource Configuration Modified: docs/branches/JBoss_Portal_Branch_2_6/referenceGuide/en/modules/i= nstallation.xml =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- docs/branches/JBoss_Portal_Branch_2_6/referenceGuide/en/modules/install= ation.xml 2008-02-04 01:27:57 UTC (rev 9724) +++ docs/branches/JBoss_Portal_Branch_2_6/referenceGuide/en/modules/install= ation.xml 2008-02-04 04:12:45 UTC (rev 9725) @@ -377,67 +377,50 @@ - Setting up the database - - Database Setup - You will need a database for JBoss Portal to function, y= ou can use any database - supported by Hibernate. - - - - Create a new Database: - For example purposes we call this new database - jbossportal - - - - - Grant access rights for a = user to your database: - You must make sure the user has access to this new= DB, as JBoss Portal will need to create the - tables and modify data within them. - - - - - Deploy your JDBC connector= : - You must make available a JDBC connector for JBoss= Portal to communicate with your database. The - connector lib should be placed in - JBOSS_HOME/server/default/lib/* - - - - - - - DataSource Configuration - - You will need a valid datasource descriptor, for JBoss Port= al to communicate with your database. Having - obtained the sources and having set your JBOSS_HOME environ= ment variable ( - - ), you can now have the JBoss Portal build system generate = preconfigured datasources for you. - - - Navigate to - JBOSS_PORTAL_HOME_DIRECTORY/core - and type: - build datasource - - - - - - - - Once complete, the datasource build should produce the foll= owing directory and file structure: - - - - - - - At this point, you should configure the one that suits y= ou best with your Database and JDBC - driver. - Database Setup + + A database is required for JBoss Portal to run. JBoss EAP and JBoss = AS include an embedded Hypersonic SQL database that JBoss Portal can use; h= owever, this is only recommended for developer use. The following databases= are recommended for production use, and have had test suites run against t= hem: MySQL 4, MySQL 5, Microsoft SQL Server, PostgreSQL 8, Oracle 9, and Or= acle 10. JBoss Portal can use any database that is supported by Hibernate. + + + To configure a database to use with JBoss Portal: + + + + + + Create a new database: this gu= ide assumes that the new database will be called jbossportal. + + + + + Grant access rights for a user to the jbossportal database: JBoss Portal needs to cr= eate tables and modify table data. Grant access rights to a desired user to= the jbossportal database. Configure the same username= and password in the Datasource descriptor. + + + + + Deploy a RDBMS JDBC connector:= a RDBMS JDBC connector is required for JBoss Portal to communicate with a = database. Copy the connector into the JBOSS_INSTALL_DIRECTORY/ser= ver/default/lib/ directory. For example, a RDBMS JDBC connector = for MySQL can be download from . For the correct RDMBS JDBC connector, please refer = to the database documentation. + + + + + + + Datasource Configuration + + The JBoss Portal binary download that was extracted in , contains pre-configured Datasource descripto= rs for the more popular databases. Datasource descriptors are provided for = the MySQL 4, MySQL 5, PostgreSQL, Microsoft SQL Server, and Oracle database= s, and can be found in the setup subdirectory where th= e JBoss Portal binary was extracted to: + + + + + + + + Copy the Datasource descriptor that matches your database into the JBOSS_INSTALLATION_DIRECTORY/server/configuration/deploy/ directory, where configuration is either all, default, minimal, or production. For example, if = you are using the production configuration, copy the Datasource descriptor = into the JBOSS_INSTALLATION_DIRECTORY/server/production/deploy/ directory. + + + After the Datasource descriptor has been copied into the dep= loy directory, make sure the username, password, connection-url,= and driver-class are correct for your chosen database. Datasource descript= or files can be deployed to test before being used in production. The follo= wing is an example Datasource descriptor for the PostgreSQL database: + + @@ -448,18 +431,11 @@ portalpassword - ]]> - Please verify that the username, password, url, and driver-= class are correct for - your flavor of DB. - - - Now - copy - your datasource descriptor to - JBOSS_HOME/server/default/deploy - - - + ]]> + + For further details about Datasource descriptors, please refer to t= he JBoss JDBC Datasource wiki page. + + Starting and running JBoss Portal --===============7286324002235809250==--