query_hql.po

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

#: query_hql.xml:574
#, no-c-format
msgid ""
"Any function or operator defined by EJB-QL 3.0: <literal>substring(), trim"
"(), lower(), upper(), length(), locate(), abs(), sqrt(), bit_length(), mod()"
"</literal>"
msgstr ""
"EJB-QL 3.0で定義されている関数や演算子: <literal>substring(), trim(), lower"
"(), upper(), length(), locate(), abs(), sqrt(), bit_length()</literal>"

#. Tag: para
#: query_hql.xml:580
#, no-c-format
msgid "<literal>coalesce()</literal> and <literal>nullif()</literal>"
msgstr "<literal>coalesce()</literal> と <literal>nullif()</literal>"

#. Tag: para
#: query_hql.xml:585
#, no-c-format
msgid ""
"<literal>str()</literal> for converting numeric or temporal values to a "
"readable string"
msgstr "数字や時間の値をStringにコンバートする <literal>str()</literal>）"

#. Tag: para
#: query_hql.xml:591
#, no-c-format
msgid ""
"<literal>cast(... as ...)</literal>, where the second argument is the name "
"of a Hibernate type, and <literal>extract(... from ...)</literal> if ANSI "
"<literal>cast()</literal> and <literal>extract()</literal> is supported by "
"the underlying database"
msgstr ""
"2番目の引数がHibernate型の名前である <literal>cast(... as ...)</literal> と "
"<literal>extract(... from ...)</literal>。 ただし使用するデータベースがANSI "
"<literal>cast()</literal> と <literal>extract()</literal> をサポートする場合"
"に限ります。"

#. Tag: para
#: query_hql.xml:599
#, no-c-format
msgid ""
"the HQL <literal>index()</literal> function, that applies to aliases of a "
"joined indexed collection"
msgstr ""
"結合したインデックス付きのコレクションの別名に適用されるHQLの <literal>index"
"()</literal> 関数。"

#. Tag: para
#: query_hql.xml:605
#, no-c-format
msgid ""
"HQL functions that take collection-valued path expressions: <literal>size(), "
"minelement(), maxelement(), minindex(), maxindex()</literal>, along with the "
"special <literal>elements()</literal> and <literal>indices</literal> "
"functions which may be quantified using <literal>some, all, exists, any, in</"
"literal>."
msgstr ""
"コレクション値のパス式を取るHQL関数： <literal>size(), minelement(), "
"maxelement(), minindex(), maxindex()</literal> 。 <literal>some, all, "
"exists, any, in</literal> を使って修飾することができる特別な "
"<literal>elements()</literal> と <literal>indices</literal> 関数と一緒に使い"
"ます。"

#. Tag: para
#: query_hql.xml:613
#, no-c-format
msgid ""
"Any database-supported SQL scalar function like <literal>sign()</literal>, "
"<literal>trunc()</literal>, <literal>rtrim()</literal>, <literal>sin()</"
"literal>"
msgstr ""
"<literal>sign()</literal>, <literal>trunc()</literal>, <literal>rtrim()</"
"literal>, <literal>sin()</literal> のようなデータベースがサポートするSQLスカ"
"ラ関数。"

#. Tag: para
#: query_hql.xml:619
#, no-c-format
msgid "JDBC-style positional parameters <literal>?</literal>"
msgstr "JDBCスタイルの位置パラメータ <literal>?</literal>"

#. Tag: para
#: query_hql.xml:624
#, no-c-format
msgid ""
"named parameters <literal>:name</literal>, <literal>:start_date</literal>, "
"<literal>:x1</literal>"
msgstr ""
"名前付きパラメータ: <literal>:name</literal>, <literal>:start_date</"
"literal>, <literal>:x1</literal>"

#. Tag: para
#: query_hql.xml:629
#, no-c-format
msgid ""
"SQL literals <literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"
msgstr ""
"SQLリテラル：<literal>'foo'</literal>, <literal>69</literal>, <literal>6.66E"
"+2</literal>, <literal>'1970-01-01 10:00:01.0'</literal>"

#. Tag: para
#: query_hql.xml:635
#, no-c-format
msgid ""
"Java <literal>public static final</literal> constants <literal>eg.Color."
"TABBY</literal>"
msgstr ""
"Javaの <literal>public static final</literal> 定数：<literal>eg.Color.TABBY</"
"literal>"

#. Tag: para
#: query_hql.xml:641
#, no-c-format
msgid ""
"<literal>in</literal> and <literal>between</literal> may be used as follows:"
msgstr ""
"<literal>in</literal> と <literal>between</literal> は以下のように使用できま"
"す。:"

#. Tag: programlisting
#: query_hql.xml:645
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:647
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:649
#, no-c-format
msgid "and the negated forms may be written"
msgstr "また、否定形で記述することもできます。"

#. Tag: programlisting
#: query_hql.xml:653
#, no-c-format
msgid "<![CDATA[from DomesticCat cat where cat.name not between 'A' and 'B']]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:655
#, no-c-format
msgid ""
"<![CDATA[from DomesticCat cat where cat.name not in ( 'Foo', 'Bar', 'Baz' )]]"
">"
msgstr ""

#. Tag: para
#: query_hql.xml:657
#, no-c-format
msgid ""
"Likewise, <literal>is null</literal> and <literal>is not null</literal> may "
"be used to test for null values."
msgstr ""
"同様に <literal>is null</literal> や <literal>is not null</literal> はnull値"
"をテストするために使用できます。"

#. Tag: para
#: query_hql.xml:662
#, no-c-format
msgid ""
"Booleans may be easily used in expressions by declaring HQL query "
"substitutions in Hibernate configuration:"
msgstr ""
"Hibernate設定ファイルでHQL query substitutionsを定義すれば、boolean値を式の中"
"で簡単に使用できま。："

#. Tag: programlisting
#: query_hql.xml:667
#, no-c-format
msgid ""
"<![CDATA[<property name=\"hibernate.query.substitutions\">true 1, false 0</"
"property>]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:669
#, no-c-format
msgid ""
"This will replace the keywords <literal>true</literal> and <literal>false</"
"literal> with the literals <literal>1</literal> and <literal>0</literal> in "
"the translated SQL from this HQL:"
msgstr ""
"こうすることで下記のHQLをSQLに変換するときに <literal>true</literal> , "
"<literal>false</literal> キーワードは <literal>1</literal> , <literal>0</"
"literal> に置き換えられます。:"

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

#. Tag: para
#: query_hql.xml:676
#, no-c-format
msgid ""
"You may test the size of a collection with the special property "
"<literal>size</literal>, or the special <literal>size()</literal> function."
msgstr ""
"特別なプロパティ <literal>size</literal>、または特別な関数 <literal>size()</"
"literal> を使ってコレクションのサイズをテストできます。:"

#. Tag: programlisting
#: query_hql.xml:681
#, no-c-format
msgid "<![CDATA[from Cat cat where cat.kittens.size > 0]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:683
#, no-c-format
msgid "<![CDATA[from Cat cat where size(cat.kittens) > 0]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:685
#, no-c-format
msgid ""
"For indexed collections, you may refer to the minimum and maximum indices "
"using <literal>minindex</literal> and <literal>maxindex</literal> functions. "
"Similarly, you may refer to the minimum and maximum elements of a collection "
"of basic type using the <literal>minelement</literal> and "
"<literal>maxelement</literal> functions."
msgstr ""
"インデックス付きのコレクションでは、<literal>minindex</literal> と "
"<literal>maxindex</literal> 関数を使って、インデックスの最小値と最大値を参照"
"できます。 同様に、<literal>minelement</literal> と <literal>maxelement</"
"literal> を使って、 基本型のコレクション要素の最小値と最大値を参照できます。"

#. Tag: programlisting
#: query_hql.xml:693
#, no-c-format
msgid ""
"<![CDATA[from Calendar cal where maxelement(cal.holidays) > current_date]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:695
#, no-c-format
msgid "<![CDATA[from Order order where maxindex(order.items) > 100]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:697
#, no-c-format
msgid "<![CDATA[from Order order where minelement(order.items) > 10000]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:699
#, no-c-format
msgid ""
"The SQL functions <literal>any, some, all, exists, in</literal> are "
"supported when passed the element or index set of a collection "
"(<literal>elements</literal> and <literal>indices</literal> functions) or "
"the result of a subquery (see below)."
msgstr ""
"コレクションの要素やインデックスのセット（<literal>elements</literal> と "
"<literal>indices</literal> 関数）、または副問い合わせ（後述）の結果が受け取れ"
"るときは、 SQL関数 <literal>any, some, all, exists, in</literal> がサポートさ"
"れます。"

#. Tag: programlisting
#: query_hql.xml:705
#, no-c-format
msgid ""
"<![CDATA[select mother from Cat as mother, Cat as kit\n"
"where kit in elements(foo.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:707
#, no-c-format
msgid ""
"<![CDATA[select p from NameList list, Person p\n"
"where p.name = some elements(list.names)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:709
#, no-c-format
msgid "<![CDATA[from Cat cat where exists elements(cat.kittens)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:711
#, no-c-format
msgid "<![CDATA[from Player p where 3 > all elements(p.scores)]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:713
#, no-c-format
msgid "<![CDATA[from Show show where 'fizard' in indices(show.acts)]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:715
#, no-c-format
msgid ""
"Note that these constructs - <literal>size</literal>, <literal>elements</"
"literal>, <literal>indices</literal>, <literal>minindex</literal>, "
"<literal>maxindex</literal>, <literal>minelement</literal>, "
"<literal>maxelement</literal> - may only be used in the where clause in "
"Hibernate3."
msgstr ""
"<literal>size</literal>, <literal>elements</literal>, <literal>indices</"
"literal>, <literal>minindex</literal>, <literal>maxindex</literal>, "
"<literal>minelement</literal>, <literal>maxelement</literal> はHibernate3の"
"where節だけで利用可能であることに注意してください。"

#. Tag: para
#: query_hql.xml:722
#, no-c-format
msgid ""
"Elements of indexed collections (arrays, lists, maps) may be referred to by "
"index (in a where clause only):"
msgstr ""
"インデックス付きのコレクション（arrays, lists, maps）の要素は、 インデックス"
"で参照できます（where節内でのみ）。"

#. Tag: programlisting
#: query_hql.xml:727
#, no-c-format
msgid "<![CDATA[from Order order where order.items[0].id = 1234]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:729
#, no-c-format
msgid ""
"<![CDATA[select person from Person person, Calendar calendar\n"
"where calendar.holidays['national day'] = person.birthDay\n"
"    and person.nationality.calendar = calendar]]>"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:731
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ order.deliveredItemIndices[0] ] = item and order.id = 11]]"
">"
msgstr ""

#. Tag: programlisting
#: query_hql.xml:733
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ maxindex(order.items) ] = item and order.id = 11]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:735
#, no-c-format
msgid ""
"The expression inside <literal>[]</literal> may even be an arithmetic "
"expression."
msgstr "<literal>[]</literal> 内部の式は、算術式でも構いません。"

#. Tag: programlisting
#: query_hql.xml:739
#, no-c-format
msgid ""
"<![CDATA[select item from Item item, Order order\n"
"where order.items[ size(order.items) - 1 ] = item]]>"
msgstr ""

#. Tag: para
#: query_hql.xml:741
#, no-c-format
msgid ""
"HQL also provides the built-in <literal>index()</literal> function, for "
"elements of a one-to-many association or collection of values."
msgstr ""
"一対多関連や値のコレクションの要素に対しては、HQLは組み込みの <literal>index"
"()</literal> 関数も用意しています。"

#. Tag: programlisting
#: query_hql.xml:746
#, no-c-format
msgid ""
"<![CDATA[select item, index(item) from Order order\n"
"    join order.items item\n"
"where index(item) < 5]]>"
msgstr ""