shins****@users*****
shins****@users*****
2006年 1月 10日 (火) 21:40:46 JST
Update of /cvsroot/jetspeed-japan/jetspeed-2-trans/ja/xdocs/guides In directory sf-cvs:/tmp/cvs-serv20195/ja/xdocs/guides Modified Files: guide-database.xml Log Message: submitted by KATOH Yasufumi jetspeed-2-trans/ja/xdocs/guides/guide-database.xml 1.1.1.1 -> 1.2 (modified) http://cvs.sourceforge.jp/cgi-bin/viewcvs.cgi/jetspeed-japan/jetspeed-2-trans/ja/xdocs/guides/guide-database.xml.diff?r1=1.1.1.1&r2=1.2 =================================================================== RCS file: jetspeed-2-trans/ja/xdocs/guides/guide-database.xml,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -r1.1.1.1 -r1.2 --- guide-database.xml 2005/12/16 03:43:36 1.1.1.1 +++ guide-database.xml 2006/01/10 12:40:46 1.2 @@ -1,225 +1,394 @@ -<?xml version="1.0"?> -<!-- - Copyright 2004 The Apache Software Foundation - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. ---> -<document> - <properties> - <title>Jetspeed 2 Database Configuration</title> - <subtitle>Welcome to Jetspeed 2</subtitle> - <authors> - <person name="David Sean Taylor" email="taylo****@apach*****" /> - <person name="David Le Strat" email="dlest****@apach*****" /> - <person name="Ron Wheeler" - email="rwhee****@artif*****" /> - </authors> - </properties> - <body> - <section name="Default Database"> - <p> - The default database distributed with Jetspeed-2 is the - Hypersonic SQL Java Database (HSQL). HSQL runs in its - own process outside of Jetspeed-2. It is not a - production-ready database, however it allows you to get - up and running quickly. To move on to a more robust - database, follow the instructions in the next section. - </p> - </section> - <section name="MySQL"> - <p> - To run with My SQL, add the following properties to your - $HOME/build.properties: - </p> - <source test=""> - <![CDATA[ - -# ------------------------------------------------------------------------- -# configure MySQL Test DB (only needed when running unit tests) -# ------------------------------------------------------------------------- -org.apache.jetspeed.test.database.default.name=mysql -org.apache.jetspeed.test.database.url = jdbc:mysql://j2-server/j2test -org.apache.jetspeed.test.database.driver = com.mysql.jdbc.Driver -org.apache.jetspeed.test.database.user = jetspeed2 -org.apache.jetspeed.test.database.password = whatever -# ------------------------------------------------------------------------- -# configure MySQL Production DB -# ------------------------------------------------------------------------- -org.apache.jetspeed.production.database.default.name=mysql -org.apache.jetspeed.production.database.url = jdbc:mysql://j2-server/j2 -org.apache.jetspeed.production.database.driver = com.mysql.jdbc.Driver -org.apache.jetspeed.production.database.user = jetspeed2 -org.apache.jetspeed.production.database.password = whatever -# ------------------------------------------------------------------------- - -]]> - </source> - <p> - In the example above, you will need to have a MySQL - server running on a host named 'j2-server' with a - database called 'j2' for production. - <br /> - If you are going to run the unit tests you will also - need an additional test database called 'j2test'. - <br /> - A user named 'jetspeed2' should be granted access to - both the 'j2' and 'j2test' databases. - </p> - - <subsection name="MySQL Known Issues"> - <p>None</p> - </subsection> - - </section> - - <section name="Oracle"> - <p> - To run with Oracle, add the following properties to your - $HOME/build.properties: - </p> - - <source test=""> - <![CDATA[ - -# ------------------------------------------------------------------------- -# configure Oracle Test DB (only needed when running unit tests) -# ------------------------------------------------------------------------- -# org.apache.jetspeed.test.database.default.name=oracle -# org.apache.jetspeed.test.database.ojb.platform=oracle9i -# org.apache.jetspeed.test.database.url = jdbc:oracle:thin:@j2-sever:1521:j2db -# org.apache.jetspeed.test.database.driver = oracle.jdbc.driver.OracleDriver -# org.apache.jetspeed.test.database.user = j2test -# org.apache.jetspeed.test.database.password = whatever -# ------------------------------------------------------------------------- -# configure Oracle Production DB -# ------------------------------------------------------------------------- -# org.apache.jetspeed.production.database.default.name=oracle -# org.apache.jetspeed.production.database.ojb.platform=oracle9i -# org.apache.jetspeed.production.database.url = jdbc:oracle:thin:@j2-server:1521:j2db -# org.apache.jetspeed.production.database.driver = oracle.jdbc.driver.OracleDriver -# org.apache.jetspeed.production.database.user = j2 -# org.apache.jetspeed.production.database.password = whatever -# ------------------------------------------------------------------------- - -]]> - </source> - <p> - In the example above, you will need to have a Oracle - server running on a host named 'j2-server' and have an - Oracle database SID named 'j2db' installed on that - server. Also, you will need a database user (schema) - called 'j2' for production usage. - <br /> - If you are going to run the unit tests you will need an - additional user called 'j2test'. - </p> - - <subsection name="Oracle Known Issues"> - <p> - Only for the first time you create the database for - Oracle, there is an issue with the drop statements. - To get around this problem, set your properties as - above in your $HOME/build.properties, and then run - these commands using the - <a href="j2-maven-plugin.html"> - Jetspeed 2 Maven plugin - </a> - : - </p> - <source test=""> - <![CDATA[ - -maven j2:db.scripts.gen -maven j2:dropdrops -maven j2:db.create.test (only when running unit tests) -maven j2:db.create.production - -]]> - </source> - </subsection> - - </section> - - <section name="Drivers"> - <p> - JDBC drivers are configured to work with the Maven build - by adding your specified JDBC driver jars to the Maven - class path. Specify the jars with the - <b>org.apache.jetspeed.test.jdbc.drivers.path</b> - and - <b>org.apache.jetspeed.production.jdbc.drivers.path</b> - properties in your $HOME/build.properties. - </p> - <p> - NOTE: The Hypersonic JDBC driver is distributed with - Jetspeed and require no configuration. - </p> - <source test=""> - <![CDATA[ - -# My SQL Driver Path Example, test and production -org.apache.jetspeed.test.jdbc.drivers.path= - /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar -org.apache.jetspeed.production.jdbc.drivers.path= - /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar - -# Oracle 9i Driver Path Example, test and production -org.apache.jetspeed.test.jdbc.drivers.path= - /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar -org.apache.jetspeed.production.jdbc.drivers.path= - /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar - -# Oracle 8i Driver Path Example, test and production -org.apache.jetspeed.test.jdbc.drivers.path= - /Portal/lib/oracle/classes12.jar; -org.apache.jetspeed.production.jdbc.drivers.path= - /Portal/lib/oracle/classes12.jar; - -]]> - </source> - - <subsection name="Distributing Drivers"> - <p> - When Jetspeed is deployed to an application server - using the maven deploy target, only the Hypersonic - JDBC driver is copied into the web application. To - distribute a specific driver (i.e. Oracle, MySQL), - you will need to copy the driver into the - application server's common class path for shared - code. - </p> - <table> - <tr> - <th>Application Server</th> - <th>Procedure</th> - </tr> - <tr> - <td>Tomcat 5 and 5.5</td> - <td> - copy driver(s) to ${TOMCAT_HOME}/endorsed/ - </td> - </tr> - - </table> - - </subsection> - <subsection name="Datasource Configuration with Jetspeed-2"> - <p> - Jetspeed-2 requires a datasource to be configured in the application server on which it is being deployed. - For more information, see the <a href="../multiproject/jetspeed-rdbms/index.html">RDBMS component documentation</a>. - </p> - </subsection> - - </section> - </body> -</document> +<?xml version="1.0"?> +<!-- + Copyright 2004 The Apache Software Foundation + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +--> +<document> + <properties> + <title>[Jetspeed 2 Database Configuration] Jetspeed 2 のデータベース設定</title> + <subtitle>Welcome to Jetspeed 2</subtitle> + <authors> + <person name="David Sean Taylor" email="taylo****@apach*****" /> + <person name="David Le Strat" email="dlest****@apach*****" /> + <person name="Ron Wheeler" + email="rwhee****@artif*****" /> + </authors> + <translators> + <person name="加藤泰文" email="karma****@prog*****" /> + </translators> + </properties> + <body> + <section name="[Default Database] デフォルトのデータベース"> + <div class="original"> + <p> + The default database distributed with Jetspeed-2 is the + Hypersonic SQL Java Database (HSQL). HSQL runs in its + own process outside of Jetspeed-2. It is not a + production-ready database, however it allows you to get + up and running quickly. To move on to a more robust + database, follow the instructions in the next section. + </p> + </div> + <p> + Jetspeed 2 と一緒に配布されるデフォルトのデータベースは Hypersonic SQL Java Database (HSQL) です。HSQL は Jetspeed 2 とは別の自身のプロセスとして実行されます。HSQL は本番環境に使うレベルのデータベースではありませんが、素早く起動し実行されます。もっと堅牢はデータベースに切替えるには、次のセクションの以降の手順を読んでください。 + </p> + </section> + <section name="[MySQL] MySQL"> + <div class="original"> + <p> + To run with My SQL, add the following properties to your + $HOME/build.properties: + </p> + </div> + <p> + MySQL を使って実行するには、$HOME/build.properties に次のようなプロパティを追加してください。 + </p> + <div class="original"> + <source test=""> + <![CDATA[ + +# ------------------------------------------------------------------------- +# configure MySQL Test DB (only needed when running unit tests) +# ------------------------------------------------------------------------- +org.apache.jetspeed.test.database.default.name=mysql +org.apache.jetspeed.test.database.url = jdbc:mysql://j2-server/j2test +org.apache.jetspeed.test.database.driver = com.mysql.jdbc.Driver +org.apache.jetspeed.test.database.user = jetspeed2 +org.apache.jetspeed.test.database.password = whatever +# ------------------------------------------------------------------------- +# configure MySQL Production DB +# ------------------------------------------------------------------------- +org.apache.jetspeed.production.database.default.name=mysql +org.apache.jetspeed.production.database.url = jdbc:mysql://j2-server/j2 +org.apache.jetspeed.production.database.driver = com.mysql.jdbc.Driver +org.apache.jetspeed.production.database.user = jetspeed2 +org.apache.jetspeed.production.database.password = whatever +# ------------------------------------------------------------------------- + +]]> + </source> + </div> + <source test=""> + <![CDATA[ + +# ------------------------------------------------------------------------- +# MySQL テストデータベースの設定 (ユニットテストを実行するときのみ必要) +# ------------------------------------------------------------------------- +org.apache.jetspeed.test.database.default.name=mysql +org.apache.jetspeed.test.database.url = jdbc:mysql://j2-server/j2test +org.apache.jetspeed.test.database.driver = com.mysql.jdbc.Driver +org.apache.jetspeed.test.database.user = jetspeed2 +org.apache.jetspeed.test.database.password = whatever +# ------------------------------------------------------------------------- +# MySQL 本番環境データベースの設定 +# ------------------------------------------------------------------------- +org.apache.jetspeed.production.database.default.name=mysql +org.apache.jetspeed.production.database.url = jdbc:mysql://j2-server/j2 +org.apache.jetspeed.production.database.driver = com.mysql.jdbc.Driver +org.apache.jetspeed.production.database.user = jetspeed2 +org.apache.jetspeed.production.database.password = whatever +# ------------------------------------------------------------------------- + +]]> + </source> + <div class="original"> + <p> + In the example above, you will need to have a MySQL + server running on a host named 'j2-server' with a + database called 'j2' for production. + <br /> + If you are going to run the unit tests you will also + need an additional test database called 'j2test'. + <br /> + A user named 'jetspeed2' should be granted access to + both the 'j2' and 'j2test' databases. + </p> + </div> + <p> + 先の例では、'j2-server' という名前のサーバで MySQL サーバが実行されている必要があり、そのデータベースサーバに 'j2' という本番環境用のデータベースがある必要があります。<br /> + もしユニットテストを実行したいのであれば、加えて 'j2test' というデータベースも必要です。<br /> + 以上の 'j2' と 'j2test' データベースに対して、'jetspeed2' というユーザが権限を持っている必要があります。 + </p> + <subsection name="[MySQL Known Issues] MySQL の既知の問題"> + <div class="oririnal"> + <p>None</p> + </div> + <p>なし</p> + </subsection> + + </section> + + <section name="[Oracle] Oracle"> + <div class="original"> + <p> + To run with Oracle, add the following properties to your + $HOME/build.properties: + </p> + </div> + <p> + Jetspeed 2 を Oracle で実行するには、以下のプロパティが $HOME/build.properties に必要です。 + </p> + + <div class="original"> + <source test=""> + <![CDATA[ + +# ------------------------------------------------------------------------- +# configure Oracle Test DB (only needed when running unit tests) +# ------------------------------------------------------------------------- +# org.apache.jetspeed.test.database.default.name=oracle +# org.apache.jetspeed.test.database.ojb.platform=oracle9i +# org.apache.jetspeed.test.database.url = jdbc:oracle:thin:@j2-sever:1521:j2db +# org.apache.jetspeed.test.database.driver = oracle.jdbc.driver.OracleDriver +# org.apache.jetspeed.test.database.user = j2test +# org.apache.jetspeed.test.database.password = whatever +# ------------------------------------------------------------------------- +# configure Oracle Production DB +# ------------------------------------------------------------------------- +# org.apache.jetspeed.production.database.default.name=oracle +# org.apache.jetspeed.production.database.ojb.platform=oracle9i +# org.apache.jetspeed.production.database.url = jdbc:oracle:thin:@j2-server:1521:j2db +# org.apache.jetspeed.production.database.driver = oracle.jdbc.driver.OracleDriver +# org.apache.jetspeed.production.database.user = j2 +# org.apache.jetspeed.production.database.password = whatever +# ------------------------------------------------------------------------- + +]]> + </source> + </div> + <source test=""> + <![CDATA[ + +# ------------------------------------------------------------------------- +# Oracle テストデータベースの設定 (ユニットテストを実行するときのみ必要) +# ------------------------------------------------------------------------- +# org.apache.jetspeed.test.database.default.name=oracle +# org.apache.jetspeed.test.database.ojb.platform=oracle9i +# org.apache.jetspeed.test.database.url = jdbc:oracle:thin:@j2-sever:1521:j2db +# org.apache.jetspeed.test.database.driver = oracle.jdbc.driver.OracleDriver +# org.apache.jetspeed.test.database.user = j2test +# org.apache.jetspeed.test.database.password = whatever +# ------------------------------------------------------------------------- +# Oracle 本番環境データベースの設定 +# ------------------------------------------------------------------------- +# org.apache.jetspeed.production.database.default.name=oracle +# org.apache.jetspeed.production.database.ojb.platform=oracle9i +# org.apache.jetspeed.production.database.url = jdbc:oracle:thin:@j2-server:1521:j2db +# org.apache.jetspeed.production.database.driver = oracle.jdbc.driver.OracleDriver +# org.apache.jetspeed.production.database.user = j2 +# org.apache.jetspeed.production.database.password = whatever +# ------------------------------------------------------------------------- + +]]> + </source> + <div class="original"> + <p> + In the example above, you will need to have a Oracle + server running on a host named 'j2-server' and have an + Oracle database SID named 'j2db' installed on that + server. Also, you will need a database user (schema) + called 'j2' for production usage. + <br /> + If you are going to run the unit tests you will need an + additional user called 'j2test'. + </p> + </div> + <p> + 先の例では、'j2-server' という名前のサーバで Oracle サーバが実行されている必要があり、サーバに 'j2db' というオラクルデータベース SID が登録されている必要があります。そして、本番環境用に 'j2' というデータベースユーザ (スキーマ) が必要です。<br /> + もしユニットテストを実行するのであれば、加えて 'j2test' というユーザも必要です。 + </p> + + <subsection name="[Oracle Known Issues] Oracle の既知の問題"> + <div class="original"> + <p> + Only for the first time you create the database for + Oracle, there is an issue with the drop statements. + To get around this problem, set your properties as + above in your $HOME/build.properties, and then run + these commands using the + <a href="j2-maven-plugin.html"> + Jetspeed 2 Maven plugin + </a> + : + </p> + </div> + <p> + Oracle 用にデータベースを作成する際には最初に一回だけ drop ステートメントに関する注意が必要です。この問題を回避するには、$HOME/build.properties 内のプロパティを先に挙げたように設定し、それから + <a href="j2-maven-plugin.html"> + Jetspeed 2 Maven plugin + </a> + を使った以下のようなコマンドを実行します。 + </p> + <div class="original"> + <source test=""> + <![CDATA[ + +maven j2:db.scripts.gen +maven j2:dropdrops +maven j2:db.create.test (only when running unit tests) +maven j2:db.create.production + +]]> + </source> + </div> + <source test=""> + <![CDATA[ + +maven j2:db.scripts.gen +maven j2:dropdrops +maven j2:db.create.test (only when running unit tests) +maven j2:db.create.production + +]]> + </source> + </subsection> + + </section> + + <section name="[Drivers] ドライバ"> + <div class="original"> + <p> + JDBC drivers are configured to work with the Maven build + by adding your specified JDBC driver jars to the Maven + class path. Specify the jars with the + <b>org.apache.jetspeed.test.jdbc.drivers.path</b> + and + <b>org.apache.jetspeed.production.jdbc.drivers.path</b> + properties in your $HOME/build.properties. + </p> + </div> + <p> + JDBC ドライバは、あなたが指定する JDBC ドライバの jar ファイルを Maven クラスパスに追加することによって、Maven のビルドで実行するように設定されます。jar ファイルは $HOME/build.properties 内の + <b>org.apache.jetspeed.test.jdbc.drivers.path</b> + と + <b>org.apache.jetspeed.production.jdbc.drivers.path</b> + というプロパティに指定します。 + </p> + <div class="original"> + <p> + NOTE: The Hypersonic JDBC driver is distributed with + Jetspeed and require no configuration. + </p> + </div> + <p> + 注意: Hypersonic JDBC ドライバは Jetspeed と一緒に配布されるので、設定の必要はありません。 + </p> + <div class="original"> + <source test=""> + <![CDATA[ + +# My SQL Driver Path Example, test and production +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar + +# Oracle 9i Driver Path Example, test and production +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar + +# Oracle 8i Driver Path Example, test and production +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/oracle/classes12.jar; +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/oracle/classes12.jar; + +]]> + </source> + </div> + <source test=""> + <![CDATA[ + +# テスト及び本番環境用の MySQL ドライバの例 +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar + +# テスト及び本番環境用の Oracle 9i ドライバの例 +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar + +# テスト及び本番環境用の Oracle 8i ドライバの例 +org.apache.jetspeed.test.jdbc.drivers.path= + /Portal/lib/oracle/classes12.jar; +org.apache.jetspeed.production.jdbc.drivers.path= + /Portal/lib/oracle/classes12.jar; + +]]> + </source> + + <subsection name="[Distributing Drivers] ドライバの配布"> + <div class="original"> + <p> + When Jetspeed is deployed to an application server + using the maven deploy target, only the Hypersonic + JDBC driver is copied into the web application. To + distribute a specific driver (i.e. Oracle, MySQL), + you will need to copy the driver into the + application server's common class path for shared + code. + </p> + </div> + <p> + Maven の deploy ターゲットを使ったアプリケーションサーバへの配備の際は、Hypersonic JDBC ドライバだけがウェブアプリケーションにコピーされます。指定するドライバ (Oracle や MySQL) を配布するには、ドライバをアプリケーションサーバの共用のクラスパスにコピーする必要があります。 + </p> + <div class="original"> + <table> + <tr> + <th>Application Server</th> + <th>Procedure</th> + </tr> + <tr> + <td>Tomcat 5 and 5.5</td> + <td> + copy driver(s) to ${TOMCAT_HOME}/endorsed/ + </td> + </tr> + + </table> + </div> + <table> + <tr> + <th>アプリケーションサーバ</th> + <th>手順</th> + </tr> + <tr> + <td>Tomcat 5 and 5.5</td> + <td> + ${TOMCAT_HOME}/endorsed/ へドライバをコピー + </td> + </tr> + + </table> + </subsection> + <subsection name="[Datasource Configuration with Jetspeed-2]"> + <div class="original"> + <p> + Jetspeed-2 requires a datasource to be configured in the application server on which it is being deployed. + For more information, see the <a href="../multiproject/jetspeed-rdbms/index.html">RDBMS component documentation</a>. + </p> + </div> + <p> + Jetspeed 2 は、配備するアプリケーションサーバ内でデータソースを設定する必要があります。更なる情報は、<a href="../multiproject/jetspeed-rdbms/index.html">RDBMS component documentation</a> を参照してください。 + </p> + </subsection> + + </section> + </body> +</document>
