Return-Path: X-Original-To: apmail-db-general-archive@www.apache.org Delivered-To: apmail-db-general-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AAAA8D8D7 for ; Wed, 13 Mar 2013 14:00:03 +0000 (UTC) Received: (qmail 80894 invoked by uid 500); 13 Mar 2013 14:00:03 -0000 Delivered-To: apmail-db-general-archive@db.apache.org Received: (qmail 80850 invoked by uid 500); 13 Mar 2013 14:00:02 -0000 Mailing-List: contact general-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: general@db.apache.org List-Id: Delivered-To: mailing list general@db.apache.org Received: (qmail 80841 invoked by uid 99); 13 Mar 2013 14:00:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Mar 2013 14:00:02 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Mar 2013 13:59:58 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 822042388BA6 for ; Wed, 13 Mar 2013 13:59:22 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Subject: svn commit: r854277 [26/44] - in /websites/production/db/content/derby: docs/10.4/ja_JP/ docs/10.4/ja_JP/getstart/ docs/10.4/ja_JP/images/ docs/10.4/ja_JP/ref/ manuals/ Date: Wed, 13 Mar 2013 13:54:25 -0000 To: general@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20130313135922.822042388BA6@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003392.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003392.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003392.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,59 @@ + + + + + + + + + + + + + + + + + + + + +製品に関する但し書き + + + + +

製品に関する但し書き

+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003392.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003415.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003415.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003415.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,59 @@ + + + + + + + + + + + + + + + + + + + +グローバルなトランザクションの復元 + + + + +

グローバルなトランザクションの復元

+ +
+

XAResource.prepareの呼び出しにより、グローバルなトランザクションはコミット準備済みの状態になり、永続化できるようになります。 +コミット準備済みの状態は、一般的にはトランザクションの結果が確定する前の一時的な状態です。しかしながらシステムがクラッシュした場合、復元処理でコミット準備済みのトランザクションはその状態に戻され、トランザクションマネージャからの指示を待ちます。

+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003415.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003463.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003463.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003463.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,64 @@ + + + + + + + + + + + + + + + + + + + +XAConnection、ユーザ名、パスワード + + + + +

XAConnection、ユーザ名、パスワード

+ +
+

ユーザ名とパスワードを指定して開いたXAConnectionにて作成したトランザクションは、異なるユーザ名とパスワードで開いたXAConnectionに結び付けることはできません。 +ユーザ名とパスワードを指定せずに開いたXAConnectionにて作成したトランザクションは、あらゆるXAConnectionに結び付けることができます。

+
+ +
しかしながら復元されたグローバルなトランザクションではユーザ名とパスワードは失われており、あらゆるXAConnectionが不定なトランザクションをコミットしたりロールバックすることができます。 +
注: リモート(クライアント/サーバ)環境にてXAの機能が必要な場合、ネットワーククライアントドライバのXA DataSourceインターフェイスを使ってください。
+
+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta1003463.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta16677.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta16677.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta16677.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,90 @@ + + + + + + + + + + + + + + + + + + + + + +J2EEへの準拠:Java Transaction APIとjavax.sql インターフェイス + + + + +

J2EEへの準拠:Java Transaction APIとjavax.sql インターフェイス

+ + +
+

J2EE、Java 2 Platform, Enterprise Editionは、多階層環境の再利用可能なソフトウェア部品に基づきエンタープライズアプリケーションを開発する標準です。 +J2EEではJava 2 Platform, Standard Edition (J2SE)に加えて、Enterprise Java Beans (EJB)、Java Server Pages (JSP)、サーブレット、XMLなどの機能を提供しています。 +J2EEアーキテクチャにより既存の技術やエンタープライズアプリケーションを統合して、単一の管理が可能な環境にまとめ上げることが可能です。

+
+ +

Derbyは分散化されたJ2EEシステムにおいては、J2EE準拠のソフトウェア部品です。JNDIサーバやコネクションプールのモジュール、トランザクションマネージャ、リソースマネージャ、ユーザアプリケーション等のほかのソフトウェアと並んで、Derbyは大きなシステムの一部となるソフトウェアとなります。Derbyは、これらのうち、リソースマネージャとしてã� �機能を提供します。

+

J2EEについてのより詳細な情報は、http://java.sun.com/javaee/reference/にて入手可能なJ2EEの仕様を参照してください。

+
J2EEのシステムにてリソースマネージャとして働くためには、J2EEが要求する以下の基本機能・機構を実現しなければなりません。
    +
  • JNDIのサポート

    この機能により、アプリケーションは、データベースの名前を登録して、データベース接続URLではなく、登録した名前によりデータベースに接続できます。JDBCインターフェイスの一つである、javax.sql.DataSourceにより、この機能は実現されています。

    +
    • + +
  • コネクションプーリング

    リソースマネージャ((Derby)への接続を保持する機構です。 +接続を要求するユーザは、プールされた接続をこの機構から受け取ることができます。 +接続の確率は比較的に高価な処理となるので、クライアント/サーバの環境にてコネクションプールは有用です。組み込み環境では接続は比較的安価に手に入れることができます。したがってコネクションプールによるパフォーマンス上の利得は余りありません。 +この機能はJDBCインターフェイスの、javax.sql.ConnectionPoolDataSourceとjavax.sql.PooledConnectionにより提供されます。

    +
    • + + +
  • XA のサポート

    XAは分散トランザクション管理の標準の一つです。 +これは2フェーズコミットに基づくものです。javax.sql.XAxxxインターフェイスとjava.transaction.xaパッケージはXAの抽象的な実装です。 +XAの詳細についてはX/Open CAE Specification-Distributed +Transaction Processing: The XA Specification, X/Open Document No. XO/CAE/91/300か、ISBN 1 872630 24 3を参照してください。 +JTAのAPIは、java.transaction.xaパッケージのインターフェイス(javax.sql.XAConnection, javax.sql.XADataSource, javax.transaction.xa.XAResource, javax.transaction.xa.Xid, and javax.transaction.xa.XAException)から構成されて、この機能を提供します。

    +
    • + +
+
+
基本となるJDBCのインターフェイスを除いて、これらのインターフェイスはエンドユーザーのアプリケーションからは意識されません。これらはシステムのバックエンドのソフトウェアコンポーネントにて利用されます。 +
注: これらのインターフェイスを実装するクラスの情報や、どのようにしてDerbyをリソースマネージャーとして使うかは、Derby ディベロッパーズ ガイドの第6章にある「DerbyをJ2EEのリソースマネージャに使う」を参照してください。
+
+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta16677.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta18596.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta18596.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta18596.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,100 @@ + + + + + + + + + + + + + + + + + + + + + +javax.sql:JDBCインターフェイス + + + + +

javax.sql:JDBCインターフェイス

+ + +
+

この節ではDerbyが実装するJDBCインターフェイスについて説明します。この仕様はJ2EE準拠の一部に含まれます。

+ +
これらの拡張のより詳細な情報は、利用するバージョンのJDKのAPI文書を参照してください。この文書はhttp://java.sun.com/javase/reference/api.jspにもあります。 +
    +
  • javax.sql.DataSource +

    実在のデータソースを表し、接続のファクトリとして働きます。DataSourceインターフェイスを実装するクラスは一般的には、Java Naming and Directory (JNDI) APIに基づき登録されます。

    +
    • + +
  • javax.sql.ConnectionPoolDataSourceと javax.sql.PooledConnection

    データベースへの接続はクライアント/サーバの環境では比較的負荷が高い処理です。接続を一度確立した後、同じ接続を複数の要求に供することで、劇的にデータベースのパフォーマンスを向上することができます。

    + +

    DerbyのConnectionPoolDataSourceおよびPooledConnectionインターフェイスの実装により、コネクションプールサーバはリソースマネージャ(Derby)への接続を維持・管理することができます。 +組み込みの環境下では比較的低い負荷で接続を確立することができるので、コネクションプールは必要ではありません。

    +
    • + +
  • javax.sql.XAConnection +

    単一のXAConnectionから、単一のXAResourceおよび、その生存期間中に複数のConnectionを作ることができます。この種類の接続により、分散トランザクションが可能となります。

    +
    • + +
  • javax.sql.XADataSource +

    XADataSourceを簡単に説明すると、XAConnectionsを作成できるConnectionPoolDataSourceです。

    +
    • + +
+
+
+ +
さらにDerbyではXADataSource、DataSourceとConnectionPoolDataSourceに三つのメソッドを用意しています。 +Derbyではデータソースの属性をいくつか用意しています。 +
    +
  • setCreateDatabase(String create) +

    次回の接続でデータベースを作成する属性を設定します。引数の文字列は"create"でなければなりません。

    +
    • + +
  • setShutdownDatabase(String shutdown) +

    データベースを終了する属性を設定します。データベースは次回の接続で終了します。引数の文字列は"shutdown"でなければなりません。

    +
    • + +
+
注: これらの属性はデータベースへの接続を取得する前に設定してください。
+
+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta18596.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta51021.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta51021.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta51021.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,76 @@ + + + + + + + + + + + + + + + + + + + + + + +JTA API + + + + +

JTA API

+ + +
+
JTA APIは java.transaction.xaの二つのインターフェイスと一つの例外によりできています。このAPIはDerbyにて全て実装されています。 +
    +
  • javax.transaction.xa.XAResource
    • + +
  • javax.transaction.xa.Xid
    • + +
  • javax.transaction.xa.XAException
    • + +
+
+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefjta51021.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefkeywords29722.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefkeywords29722.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefkeywords29722.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,517 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +SQL予約語 + + + + +

SQL予約語

+ + +
+
この章ではDerbyの全予約語を一覧で示します。これにはSQL-92にて定められたものも含めます。 +これらのキーワードを二重引用符(")で囲むことなく識別子として利用した場合、Derbyはエラーを返します。 +詳細はSQL92識別子の規則を参照してください。
    +
  • ADD
    • + +
  • ALL
    • + +
  • ALLOCATE
    • + +
  • ALTER
    • + +
  • AND
    • + +
  • ANY
    • + +
  • ARE
    • + +
  • AS
    • + +
  • ASC
    • + +
  • ASSERTION
    • + +
  • AT
    • + +
  • AUTHORIZATION
    • + +
  • AVG
    • + +
  • BEGIN
    • + +
  • BETWEEN
    • + +
  • BIGINT
    • + +
  • BIT
    • + +
  • BOOLEAN
    • + +
  • BOTH
    • + +
  • BY
    • + +
  • CALL
    • + +
  • CASCADE
    • + +
  • CASCADED
    • + +
  • CASE
    • + +
  • CAST
    • + +
  • CHAR
    • + +
  • CHARACTER
    • + +
  • CHECK
    • + +
  • CLOSE
    • + +
  • COALESCE
    • + +
  • COLLATE
    • + +
  • COLLATION
    • + +
  • COLUMN
    • + +
  • COMMIT
    • + +
  • CONNECT
    • + +
  • CONNECTION
    • + +
  • CONSTRAINT
    • + +
  • CONSTRAINTS
    • + +
  • CONTINUE
    • + +
  • CONVERT
    • + +
  • CORRESPONDING
    • + +
  • CREATE
    • + +
  • CURRENT
    • + +
  • CURRENT_DATE
    • + +
  • CURRENT_TIME
    • + +
  • CURRENT_TIMESTAMP
    • + +
  • CURRENT_USER
    • + +
  • CURSOR
    • + +
  • DEALLOCATE
    • + +
  • DEC
    • + +
  • DECIMAL
    • + +
  • DECLARE
    • + +
  • DEFAULT
    • + +
  • DEFERRABLE
    • + +
  • DEFERRED
    • + +
  • DELETE
    • + +
  • DESC
    • + +
  • DESCRIBE
    • + +
  • DIAGNOSTICS
    • + +
  • DISCONNECT
    • + +
  • DISTINCT
    • + +
  • DOUBLE
    • + +
  • DROP
    • + +
  • ELSE
    • + +
  • END
    • + +
  • END-EXEC
    • + +
  • ESCAPE
    • + +
  • EXCEPT
    • + +
  • EXCEPTION
    • + +
  • EXEC
    • + +
  • EXECUTE
    • + +
  • EXISTS
    • + +
  • EXPLAIN
    • + +
  • EXTERNAL
    • + +
  • FALSE
    • + +
  • FETCH
    • + +
  • FIRST
    • + +
  • FLOAT
    • + +
  • FOR
    • + +
  • FOREIGN
    • + +
  • FOUND
    • + +
  • FROM
    • + +
  • FULL
    • + +
  • FUNCTION
    • + +
  • GET
    • + +
  • GETCURRENTCONNECTION
    • + +
  • GLOBAL
    • + +
  • GO
    • + +
  • GOTO
    • + +
  • GRANT
    • + +
  • GROUP
    • + +
  • HAVING
    • + +
  • HOUR
    • + +
  • IDENTITY
    • + +
  • IMMEDIATE
    • + +
  • IN
    • + +
  • INDICATOR
    • + +
  • INITIALLY
    • + +
  • INNER
    • + +
  • INOUT
    • + +
  • INPUT
    • + +
  • INSENSITIVE
    • + +
  • INSERT
    • + +
  • INT
    • + +
  • INTEGER
    • + +
  • INTERSECT
    • + +
  • INTO
    • + +
  • IS
    • + +
  • ISOLATION
    • + +
  • JOIN
    • + +
  • KEY
    • + +
  • LAST
    • + +
  • LEFT
    • + +
  • LIKE
    • + +
  • LOWER
    • + +
  • LTRIM
    • + +
  • MATCH
    • + +
  • MAX
    • + +
  • MIN
    • + +
  • MINUTE
    • + +
  • NATIONAL
    • + +
  • NATURAL
    • + +
  • NCHAR
    • + +
  • NVARCHAR
    • + +
  • NEXT
    • + +
  • NO
    • + +
  • NOT
    • + +
  • NULL
    • + +
  • NULLIF
    • + +
  • NUMERIC
    • + +
  • OF
    • + +
  • ON
    • + +
  • ONLY
    • + +
  • OPEN
    • + +
  • OPTION
    • + +
  • OR
    • + +
  • ORDER
    • + +
  • OUTER
    • + +
  • OUTPUT
    • + +
  • OVERLAPS
    • + +
  • PAD
    • + +
  • PARTIAL
    • + +
  • PREPARE
    • + +
  • PRESERVE
    • + +
  • PRIMARY
    • + +
  • PRIOR
    • + +
  • PRIVILEGES
    • + +
  • PROCEDURE
    • + +
  • PUBLIC
    • + +
  • READ
    • + +
  • REAL
    • + +
  • REFERENCES
    • + +
  • RELATIVE
    • + +
  • RESTRICT
    • + +
  • REVOKE
    • + +
  • RIGHT
    • + +
  • ROLLBACK
    • + +
  • ROWS
    • + +
  • RTRIM
    • + +
  • SCHEMA
    • + +
  • SCROLL
    • + +
  • SECOND
    • + +
  • SELECT
    • + +
  • SESSION_USER
    • + +
  • SET
    • + +
  • SMALLINT
    • + +
  • SOME
    • + +
  • SPACE
    • + +
  • SQL
    • + +
  • SQLCODE
    • + +
  • SQLERROR
    • + +
  • SQLSTATE
    • + +
  • SUBSTR
    • + +
  • SUBSTRING
    • + +
  • SUM
    • + +
  • SYSTEM_USER
    • + +
  • TABLE
    • + +
  • TEMPORARY
    • + +
  • TIMEZONE_HOUR
    • + +
  • TIMEZONE_MINUTE
    • + +
  • TO
    • + +
  • TRANSACTION
    • + +
  • TRANSLATE
    • + +
  • TRANSLATION
    • + +
  • TRIM
    • + +
  • TRUE
    • + +
  • UNION
    • + +
  • UNIQUE
    • + +
  • UNKNOWN
    • + +
  • UPDATE
    • + +
  • UPPER
    • + +
  • USER
    • + +
  • USING
    • + +
  • VALUES
    • + +
  • VARCHAR
    • + +
  • VARYING
    • + +
  • VIEW
    • + +
  • WHENEVER
    • + +
  • WHERE
    • + +
  • WITH
    • + +
  • WORK
    • + +
  • WRITE
    • + +
  • XML
    • + +
  • XMLEXISTS
    • + +
  • XMLPARSE
    • + +
  • XMLQUERY
    • + +
  • XMLSERIALIZE
    • + +
  • YEAR
    • + +
+
+
+ +
+ +
+
+
親トピック: SQL言語のリファレンス
+
+
関連概念
+ + + + +
+
関連資料
+ + + + + + + + + + + + + + +
+
+ + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefkeywords29722.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflicense.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflicense.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflicense.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,273 @@ + + + + + + + + + + + + + + + + + + + + + +License + + + + +

License

+ + + +

+ +

The Apache License, Version 2.0

+
+                               Apache License
+                           Version 2.0, January 2004
+                        http://www.apache.org/licenses/
+
+   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
+
+   1. Definitions.
+
+      "License" shall mean the terms and conditions for use,
+      reproduction, and distribution as defined by Sections 1 through
+      9 of this document.
+
+      "Licensor" shall mean the copyright owner or entity authorized
+      by the copyright owner that is granting the License.
+
+      "Legal Entity" shall mean the union of the acting entity and all
+      other entities that control, are controlled by, or are under
+      common control with that entity. For the purposes of this
+      definition, "control" means (i) the power, direct or indirect,
+      to cause the direction or management of such entity, whether by
+      contract or otherwise, or (ii) ownership of fifty percent (50%)
+      or more of the outstanding shares, or (iii) beneficial ownership
+      of such entity.
+
+      "You" (or "Your") shall mean an individual or Legal Entity
+      exercising permissions granted by this License.
+
+      "Source" form shall mean the preferred form for making
+      modifications, including but not limited to software source code,
+      documentation source, and configuration files.
+
+      "Object" form shall mean any form resulting from mechanical
+      transformation or translation of a Source form, including but
+      not limited to compiled object code, generated documentation,
+      and conversions to other media types.
+
+      "Work" shall mean the work of authorship, whether in Source or
+      Object form, made available under the License, as indicated by a
+      copyright notice that is included in or attached to the work
+      (an example is provided in the Appendix below).
+
+      "Derivative Works" shall mean any work, whether in Source or
+      Object form, that is based on (or derived from) the Work and
+      for which the editorial revisions, annotations, elaborations,
+      or other modifications represent, as a whole, an original work
+      of authorship.  For the purposes of this License, Derivative
+      Works shall not include works that remain separable from, or
+      merely link (or bind by name) to the interfaces of, the Work
+      and Derivative Works thereof.
+
+      "Contribution" shall mean any work of authorship, including
+      the original version of the Work and any modifications or
+      additions to that Work or Derivative Works thereof, that is
+      intentionally submitted to Licensor for inclusion in the Work
+      by the copyright owner or by an individual or Legal Entity
+      authorized to submit on behalf of the copyright owner. For the
+      purposes of this definition,
+      "submitted" means any form of electronic, verbal, or written
+      communication sent to the Licensor or its representatives,
+      including but not limited to communication on electronic mailing
+      lists, source code control systems, and issue tracking systems
+      that are managed by, or on behalf of, the Licensor for the
+      purpose of discussing and improving the Work, but excluding
+      communication that is conspicuously marked or otherwise
+      designated in writing by the copyright owner as "Not a
+      Contribution."
+
+      "Contributor" shall mean Licensor and any individual or Legal
+      Entity on behalf of whom a Contribution has been received by
+      Licensor and subsequently incorporated within the Work.
+
+   2. Grant of Copyright License. Subject to the terms and conditions
+      of this License, each Contributor hereby grants to You a
+      perpetual, worldwide, non-exclusive, no-charge, royalty-free,
+      irrevocable copyright license to reproduce, prepare Derivative
+      Works of, publicly display, publicly perform, sublicense, and
+      distribute the Work and such Derivative Works in Source or
+      Object form.
+
+   3. Grant of Patent License. Subject to the terms and conditions of
+      this License, each Contributor hereby grants to You a perpetual,
+      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
+      (except as stated in this section) patent license to make, have
+      made, use, offer to sell, sell, import, and otherwise transfer
+      the Work, where such license applies only to those patent claims
+      licensable by such Contributor that are necessarily infringed by
+      their Contribution(s) alone or by combination of their
+      Contribution(s) with the Work to which such Contribution(s) was
+      submitted. If You institute patent litigation against any entity
+      (including a cross-claim or counterclaim in a lawsuit) alleging
+      that the Work or a Contribution incorporated within the Work
+      constitutes direct or contributory patent infringement, then any
+      patent licenses granted to You under this License for that Work
+      shall terminate as of the date such litigation is filed.
+
+   4. Redistribution. You may reproduce and distribute copies of the
+      Work or Derivative Works thereof in any medium, with or without
+      modifications, and in Source or Object form, provided that You
+      meet the following conditions:
+
+      (a) You must give any other recipients of the Work or
+          Derivative Works a copy of this License; and
+
+      (b) You must cause any modified files to carry prominent notices
+          stating that You changed the files; and
+
+      (c) You must retain, in the Source form of any Derivative Works
+          that You distribute, all copyright, patent, trademark, and
+          attribution notices from the Source form of the Work,
+          excluding those notices that do not pertain to any part of
+          the Derivative Works; and
+
+      (d) If the Work includes a "NOTICE" text file as part of its
+          distribution, then any Derivative Works that You distribute
+          must include a readable copy of the attribution notices
+          contained within such NOTICE file, excluding those notices
+          that do not pertain to any part of the Derivative Works, in
+          at least one of the following places: within a NOTICE text
+          file distributed as part of the Derivative Works; within the
+          Source form or documentation, if provided along with the
+          Derivative Works; or, within a display generated by the
+          Derivative Works, if and wherever such third-party notices
+          normally appear. The contents of the NOTICE file are for
+          informational purposes only and do not modify the License.
+          You may add Your own attribution notices within Derivative
+          Works that You distribute, alongside or as an addendum to
+          the NOTICE text from the Work, provided that such additional
+          attribution notices cannot be construed as modifying the
+          License.
+
+      You may add Your own copyright statement to Your modifications
+      and may provide additional or different license terms and
+      conditions for use, reproduction, or distribution of Your
+      modifications, or for any such Derivative Works as a whole,
+      provided Your use, reproduction, and distribution of the Work
+      otherwise complies with the conditions stated in this License.
+
+   5. Submission of Contributions. Unless You explicitly state
+      otherwise, any Contribution intentionally submitted for
+      inclusion in the Work by You to the Licensor shall be under the
+      terms and conditions of this License, without any additional
+      terms or conditions.  Notwithstanding the above, nothing herein
+      shall supersede or modify the terms of any separate license
+      agreement you may have executed with Licensor regarding such
+      Contributions.
+
+   6. Trademarks. This License does not grant permission to use the
+      trade names, trademarks, service marks, or product names of the
+      Licensor, except as required for reasonable and customary use
+      in describing the origin of the Work and reproducing the content
+      of the NOTICE file.
+
+   7. Disclaimer of Warranty. Unless required by applicable law or
+      agreed to in writing, Licensor provides the Work (and each
+      Contributor provides its Contributions) on an "AS IS" BASIS,
+      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
+      implied, including, without limitation, any warranties or
+      conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or
+      FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for
+      determining the appropriateness of using or redistributing the
+      Work and assume any risks associated with Your exercise of
+      permissions under this License.
+
+   8. Limitation of Liability. In no event and under no legal theory,
+      whether in tort (including negligence), contract, or otherwise,
+      unless required by applicable law (such as deliberate and
+      grossly negligent acts) or agreed to in writing, shall any
+      Contributor be liable to You for damages, including any direct,
+      indirect, special, incidental, or consequential damages of any
+      character arising as a result of this License or out of the use
+      or inability to use the Work (including but not limited to
+      damages for loss of goodwill, work stoppage, computer failure or
+      malfunction, or any and all other commercial damages or losses),
+      even if such Contributor has been advised of the possibility of
+      such damages.
+
+   9. Accepting Warranty or Additional Liability. While redistributing
+      the Work or Derivative Works thereof, You may choose to offer,
+      and charge a fee for, acceptance of support, warranty, indemnity,
+      or other liability obligations and/or rights consistent with this
+      License. However, in accepting such obligations, You may act only
+      on Your own behalf and on Your sole responsibility, not on behalf
+      of any other Contributor, and only if You agree to indemnify,
+      defend, and hold each Contributor harmless for any liability
+      incurred by, or claims asserted against, such Contributor by
+      reason of your accepting any such warranty or additional
+      liability.
+
+   END OF TERMS AND CONDITIONS
+
+   APPENDIX: How to apply the Apache License to your work.
+
+      To apply the Apache License to your work, attach the following
+      boilerplate notice, with the fields enclosed by brackets "[]"
+      replaced with your own identifying information. (Don't include
+      the brackets!)  The text should be enclosed in the appropriate
+      comment syntax for the file format. We also recommend that a
+      file or class name and description of purpose be included on the
+      same "printed page" as the copyright notice for easier
+      identification within third-party archives.
+
+   Copyright [yyyy] [name of copyright owner]
+
+   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.
+
+ +
+ +
+ +
+ + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflicense.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimits.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimits.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimits.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,70 @@ + + + + + + + + + + + + + + + + + + + + + + + +Derbyの制限事項 + + + + +

Derbyの制限事項

+ +
+

この説ではDerbyにある制限事項を挙げます。

+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimits.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimitsxml.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimitsxml.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimitsxml.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,102 @@ + + + + + + + + + + + + + + + + + + + + + + + + + +XMLの制限 + + + + +

XMLの制限

+ + +
+

以下の表に、DerbyでのXMLデータ型の制限を記します。

+
+ + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Table 1. XMLの制限
項目制限
XMLの長さ2,147,483,647文字
XML演算子の利用Apache XercesのようなJAXP構文解析器とApache Xalanのクラスが、クラスパスに記述されている必要があります。クラスパスにこれらのクラスがない場合、XML演算子を利用するとエラーとなります。
+
+ +
+ + + + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreflimitsxml.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefminutefunc.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefminutefunc.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefminutefunc.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,72 @@ + + + + + + + + + + + + + + + + + + + + + + +MINUTE 関数 + + + + +

MINUTE 関数

+ + + +

MINUTE関数は値の分の部分を返します。

+ +

引数は時、タイムスタンプあるいはCLOB・LONG VARCHAR・XML以外の、時・タイムスタンプを表す有効な文字列でなければなりません。 +返り値は0から59の間の数です。引数にはnullをとることができ、その場合は返り値はnullをとることができます。もし引数がnullなら、返り値はnullです。 +

+
+ +

構文

MINUTE ( 式 )
+
+ +

例

+

「flights」表から、「departure_time」が6:00より6:30AMの間である全ての行を選択する。

+ +
SELECT * FROM flights WHERE HOUR(departure_time) = 6 and MINUTE(departure_time) < 31;
+
+ +
+ +
+
+
親トピック: 組み込み関数
+
+
+ + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefminutefunc.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefmonthfunc.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefmonthfunc.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefmonthfunc.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,73 @@ + + + + + + + + + + + + + + + + + + + + + + +MONTH関数 + + + + +

MONTH関数

+ + + +

MONTH関数は値から月の部分を返します。

+ +

引数は、日付、タイムスタンプ、CLOB・LONG VARCHAR・XML以外の日付・タイムスタンプを表す有効な文字列でなければなりません。 +関数の返り値は1から12の間の整数です。もし引数がnullをとることがあれば、返り値もnullとなることがあり、引数がnullなら、返り値はnullです。

+ +
+ +

構文

MONTH ( 式 )
+
+ +

例

+

EMPLOYEEという表から誕生日(BIRTHDATE)が12月の人の行を選択する。 +

+ 
SELECT * FROM EMPLOYEE
+WHERE MONTH(BIRTHDATE) = 12
+
+ +
+ +
+
+
親トピック: 組み込み関数
+
+
+ + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefmonthfunc.html ------------------------------------------------------------------------------ svn:eol-style = native Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefnewtablename.html ============================================================================== --- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefnewtablename.html (added) +++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefnewtablename.html Wed Mar 13 13:54:17 2013 @@ -0,0 +1,61 @@ + + + + + + + + + + + + + + + + + + +新しい表名 + + + + +

新しい表名

+ +
+

新しい表名は、新しく名前のついた表をあらわします。新しい表名をスキーマ名で限定することはできません。

+
+ +

構文

SQL92識別子
+
+ +

例

-- FlightBooks は新しい表名です。スキーマ名はありません。
+RENAME TABLE FLIGHTAVAILABILITY TO FLIGHTAVAILABLE
+
+ +
+ +
+
+
Parent topic: SQLの識別子
+
+
+ + + Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefnewtablename.html ------------------------------------------------------------------------------ svn:eol-style = native