query_hql.po

hibernate-distribution-3.3.1.GA-dist.zip源码

"とができます。 クエリはそのクラスを拡張した、もしくはインターフェイスを実装し"
"た全ての永続クラスを返します。 次のクエリは永続オブジェクトをすべて返します:"

#. Tag: programlisting
#: query_hql.xml:382
#, no-c-format
msgid "<![CDATA[from java.lang.Object o]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:384
#, no-c-format
msgid ""
"The interface <literal>Named</literal> might be implemented by various "
"persistent classes:"
msgstr ""
"<literal>Named</literal> インターフェイスは様々な永続クラスによって実装されま"
"す。:"

#. Tag: programlisting
#: query_hql.xml:389
#, no-c-format
msgid "<![CDATA[from Named n, Named m where n.name = m.name]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:391
#, no-c-format
msgid ""
"Note that these last two queries will require more than one SQL "
"<literal>SELECT</literal>. This means that the <literal>order by</literal> "
"clause does not correctly order the whole result set. (It also means you "
"can't call these queries using <literal>Query.scroll()</literal>.)"
msgstr ""
"最後の二つのクエリは、二つ以上のSQL <literal>SELECT</literal> を要求している"
"ことに注意してください。 このことは <literal>order by</literal> 節がリザルト"
"セット全体を正確には整列しないことを意味します (さらにそれは、<literal>Query."
"scroll()</literal> を使用してこれらのクエリを呼ぶことができないことを意味しま"
"す。)。"

#. Tag: title
#: query_hql.xml:400
#, no-c-format
msgid "The where clause"
msgstr "where節"

#. Tag: para
#: query_hql.xml:402
#, no-c-format
msgid ""
"The <literal>where</literal> clause allows you to narrow the list of "
"instances returned. If no alias exists, you may refer to properties by name:"
msgstr ""
"<literal>where</literal> 節は返されるインスタンスのリストを絞ることができま"
"す。 もし別名がない場合、名前でプロパティを参照します。"

#. Tag: programlisting
#: query_hql.xml:407
#, no-c-format
msgid "<![CDATA[from Cat where name='Fritz']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:409
#, no-c-format
msgid "If there is an alias, use a qualified property name:"
msgstr "もし別名がある場合、修飾名を使ってください。"

#. Tag: programlisting
#: query_hql.xml:413
#, no-c-format
msgid "<![CDATA[from Cat as cat where cat.name='Fritz']]>"
msgstr ""

#. Tag: para
#: query_hql.xml:415
#, no-c-format
msgid "returns instances of <literal>Cat</literal> named 'Fritz'."
msgstr "名前が'Fritz'という <literal>Cat</literal> のインスタンスを返します。"

#. Tag: programlisting
#: query_hql.xml:419
#, no-c-format
msgid ""
"<![CDATA[select foo\n"
"from Foo foo, Bar bar\n"
"where foo.startDate = bar.date]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:421
#, no-c-format
msgid ""
"will return all instances of <literal>Foo</literal> for which there exists "
"an instance of <literal>bar</literal> with a <literal>date</literal> "
"property equal to the <literal>startDate</literal> property of the "
"<literal>Foo</literal>. Compound path expressions make the <literal>where</"
"literal> clause extremely powerful. Consider:"
msgstr ""
"上のHQLは、<literal>Foo</literal> の <literal>startDate</literal> プロパティ"
"と等しい <literal>date</literal> プロパティを持った <literal>bar</literal> イ"
"ンスタンスが存在する、 すべての <literal>Foo</literal> インスタンスを返しま"
"す。 コンパウンドパス式（例えば「cat.mate.name」）は <literal>where</"
"literal> 節を非常に強力にします。注目："

#. Tag: programlisting
#: query_hql.xml:430
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.mate.name is not null]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:432
#, no-c-format
msgid ""
"This query translates to an SQL query with a table (inner) join. If you were "
"to write something like"
msgstr ""
"このクエリはテーブル結合（内部結合）を持つSQLクエリに変換されます。 その代わ"
"りに以下のように書くと、"

#. Tag: programlisting
#: query_hql.xml:437
#, no-c-format
msgid ""
"<![CDATA[from Foo foo\n"
"where foo.bar.baz.customer.address.city is not null]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:439
#, no-c-format
msgid ""
"you would end up with a query that would require four table joins in SQL."
msgstr ""
"もし上のクエリを記述したらクエリ内に4つのテーブル結合を必要とするSQLクエリに"
"変換されます。"

#. Tag: para
#: query_hql.xml:443
#, no-c-format
msgid ""
"The <literal>=</literal> operator may be used to compare not only "
"properties, but also instances:"
msgstr ""
"<literal>=</literal> 演算子は以下のように、プロパティだけでなくインスタンスを"
"比較するためにも使われます。："

#. Tag: programlisting
#: query_hql.xml:448
#, no-c-format
msgid "<![CDATA[from Cat cat, Cat rival where cat.mate = rival.mate]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:450
#, no-c-format
msgid ""
"<![CDATA[select cat, mate\n"
"from Cat cat, Cat mate\n"
"where cat.mate = mate]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:452
#, no-c-format
msgid ""
"The special property (lowercase) <literal>id</literal> may be used to "
"reference the unique identifier of an object. See <xref linkend=\"queryhql-"
"identifier-property\"/> for more information."
msgstr ""
"<literal>id</literal> (小文字)は特別なプロパティであり、 オブジェクトのユニー"
"クな識別子を参照するために使用できます。(さらに、そのプロパティ名を使用できま"
"す。)"

#. Tag: programlisting
#: query_hql.xml:458
#, no-c-format
msgid ""
"<![CDATA[from Cat as cat where cat.id = 123\n"
"\n"
"from Cat as cat where cat.mate.id = 69]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:460
#, no-c-format
msgid "The second query is efficient. No table join is required!"
msgstr "2番目のクエリは効率的です。テーブル結合が必要ありません！"

#. Tag: para
#: query_hql.xml:464
#, no-c-format
msgid ""
"Properties of composite identifiers may also be used. Suppose "
"<literal>Person</literal> has a composite identifier consisting of "
"<literal>country</literal> and <literal>medicareNumber</literal>. Again, see "
"<xref linkend=\"queryhql-identifier-property\"/> for more information "
"regarding referencing identifier properties."
msgstr ""
"また複合識別子のプロパティも使用できます。ここで <literal>Person</literal> "
"が <literal>country</literal> と <literal>medicareNumber</literal> からなる複"
"合識別子を持つと仮定します。"

#. Tag: programlisting
#: query_hql.xml:471
#, no-c-format
msgid ""
"<![CDATA[from bank.Person person\n"
"where person.id.country = 'AU'\n"
"    and person.id.medicareNumber = 123456]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:473
#, no-c-format
msgid ""
"<![CDATA[from bank.Account account\n"
"where account.owner.id.country = 'AU'\n"
"    and account.owner.id.medicareNumber = 123456]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:475
#, no-c-format
msgid "Once again, the second query requires no table join."
msgstr "もう一度言いますが、2番目のクエリにはテーブル結合が必要ありません。"

#. Tag: para
#: query_hql.xml:479
#, no-c-format
msgid ""
"Likewise, the special property <literal>class</literal> accesses the "
"discriminator value of an instance in the case of polymorphic persistence. A "
"Java class name embedded in the where clause will be translated to its "
"discriminator value."
msgstr ""
"同様に <literal>class</literal> は特別なプロパティであり、 ポリモーフィックな"
"永続化におけるインスタンスのdiscriminator値にアクセスします。 where節に埋め込"
"まれたJavaのクラス名はそのdiscriminator値に変換されます。"

#. Tag: programlisting
#: query_hql.xml:485
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.class = DomesticCat]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:487
#, no-c-format
msgid ""
"You may also use components or composite user types, or properties of said "
"component types. See <xref linkend=\"queryhql-components\"/> for more "
"details."
msgstr ""
"またコンポーネントや複合ユーザ型(またそのコンポーネントのコンポーネントなど)"
"のプロパティも指定できます。 しかし決して（コンポーネントのプロパティではな"
"く）コンポーネント型のプロパティで終了するパス式を使わないでください。 例えば"
"もし <literal>store.owner</literal> が <literal>address</literal> コンポーネ"
"ントを持つエンティティならば以下のような結果となります。"

#. Tag: para
#: query_hql.xml:492
#, no-c-format
msgid ""
"An \"any\" type has the special properties <literal>id</literal> and "
"<literal>class</literal>, allowing us to express a join in the following way "
"(where <literal>AuditLog.item</literal> is a property mapped with "
"<literal>&lt;any&gt;</literal>)."
msgstr ""
"\"any\"型は特別なプロパティである <literal>id</literal> と <literal>class</"
"literal> を持ち、 以下の方法で結合を表現することを可能にします"
"(<literal>AuditLog.item</literal> は <literal>&lt;any&gt;</literal> でマッピ"
"ングされたプロパティです)。"

#. Tag: programlisting
#: query_hql.xml:498
#, no-c-format
msgid ""
"<![CDATA[from AuditLog log, Payment payment\n"
"where log.item.class = 'Payment' and log.item.id = payment.id]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:500
#, no-c-format
msgid ""
"Notice that <literal>log.item.class</literal> and <literal>payment.class</"
"literal> would refer to the values of completely different database columns "
"in the above query."
msgstr ""
"<literal>log.item.class</literal> と <literal>payment.class</literal> が 上記"
"のクエリ中で全く異なるデータベースカラムの値を参照するということに注意してく"
"ださい。"

#. Tag: title
#: query_hql.xml:508
#, no-c-format
msgid "Expressions"
msgstr "Expressions 式"

#. Tag: para
#: query_hql.xml:510
#, no-c-format
msgid ""
"Expressions allowed in the <literal>where</literal> clause include most of "
"the kind of things you could write in SQL:"
msgstr ""
"SQLの <literal>where</literal> 節で記述することが出来る式のほとんどをHQLでも"
"記述できます。:"

#. Tag: para
#: query_hql.xml:517
#, no-c-format
msgid "mathematical operators <literal>+, -, *, /</literal>"
msgstr "算術演算子：<literal>+, -, *, /</literal>"

#. Tag: para
#: query_hql.xml:522
#, no-c-format
msgid ""
"binary comparison operators <literal>=, &gt;=, &lt;=, &lt;&gt;, !=, like</"
"literal>"
msgstr "2項比較演算子：<literal>=, &gt;=, &lt;=, &lt;&gt;, !=, like</literal>"

#. Tag: para
#: query_hql.xml:527
#, no-c-format
msgid "logical operations <literal>and, or, not</literal>"
msgstr "論理演算子：<literal>and, or, not</literal>"

#. Tag: para
#: query_hql.xml:532
#, no-c-format
msgid "Parentheses <literal>( )</literal>, indicating grouping"
msgstr "グループ分けを表す括弧：<literal>( )</literal>"

#. Tag: para
#: query_hql.xml:537
#, no-c-format
msgid ""
"<literal>in</literal>, <literal>not in</literal>, <literal>between</"
"literal>, <literal>is null</literal>, <literal>is not null</literal>, "
"<literal>is empty</literal>, <literal>is not empty</literal>, "
"<literal>member of</literal> and <literal>not member of</literal>"
msgstr ""
"<literal>in</literal>, <literal>not in</literal>, <literal>between</"
"literal>, <literal>is null</literal>, <literal>is not null</literal>, "
"<literal>is empty</literal>, <literal>is not empty</literal>, "
"<literal>member of</literal> and <literal>not member of</literal>"

#. Tag: para
#: query_hql.xml:550
#, no-c-format
msgid ""
"\"Simple\" case, <literal>case ... when ... then ... else ... end</literal>, "
"and \"searched\" case, <literal>case when ... then ... else ... end</literal>"
msgstr ""
"\"シンプル\"なcase <literal>case ... when ... then ... else ... end</"
"literal>、 \"探索的\"なcase <literal>case when ... then ... else ... end</"
"literal>"

#. Tag: para
#: query_hql.xml:556
#, no-c-format
msgid ""
"string concatenation <literal>...||...</literal> or <literal>concat(...,...)"
"</literal>"
msgstr ""
"ストリングの連結 <literal>...||...</literal> または <literal>concat(...,...)"
"</literal>"

#. Tag: para
#: query_hql.xml:561
#, no-c-format
msgid ""
"<literal>current_date()</literal>, <literal>current_time()</literal>, "
"<literal>current_timestamp()</literal>"
msgstr ""
"<literal>current_date()</literal>, <literal>current_time()</literal>, "
"<literal>current_timestamp()</literal>"

#. Tag: para
#: query_hql.xml:567
#, no-c-format
msgid ""
"<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour"
"(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, "
"<literal>year(...)</literal>,"
msgstr ""
"<literal>second(...)</literal>, <literal>minute(...)</literal>, <literal>hour"
"(...)</literal>, <literal>day(...)</literal>, <literal>month(...)</literal>, "
"<literal>year(...)</literal>,"

#. Tag: para