Hibernate example source code file (association_mapping.po)

This example Hibernate source code file (association_mapping.po) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - Hibernate tags/keywords

a, address, address, cdata, hibernate, id, in, person, person, personaddress, personaddress, tag, tag, the

The Hibernate association_mapping.po source code

# translation of Collection_Mapping.po to
# Xi HUANG <xhuang@redhat.com>, 2007, 2010.
msgid ""
msgstr ""
"Project-Id-Version: Collection_Mapping\n"
"Report-Msgid-Bugs-To: http://bugs.kde.org\n"
"POT-Creation-Date: 2010-02-10T07:25:34\n"
"PO-Revision-Date: 2010-01-06 17:26+1000\n"
"Last-Translator: Xi HUANG <xhuang@redhat.com>\n"
"Language-Team:  <en@li.org>\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"X-Generator: KBabel 1.11.4\n"

#. Tag: title
#, no-c-format
msgid "Association Mappings"
msgstr "関連マッピング"

#. Tag: title
#, no-c-format
msgid "Introduction"
msgstr "イントロダクション"

#. Tag: para
#, no-c-format
msgid ""
"Association mappings are often the most difficult thing to implement "
"correctly. In this section we examine some canonical cases one by one, "
"starting with unidirectional mappings and then bidirectional cases. We will "
"use <literal>Person and Address in all the "
"examples."
msgstr ""
"関連マッピングはしばしば理解が最も難しいものになります。この章では、基本的な"
"一つ一つのケースについて述べます。単方向のマッピングから始め、それから双方向"
"のケースについて考えていきます。例として、 <literal>Person と "
"<literal>Address を用います。"

#. Tag: para
#, no-c-format
msgid ""
"Associations will be classified by multiplicity and whether or not they map "
"to an intervening join table."
msgstr ""
"関連は、結合テーブルを入れるかかどうかと、多重度によって分類することにしま"
"す。"

#. Tag: para
#, no-c-format
msgid ""
"Nullable foreign keys are not considered to be good practice in traditional "
"data modelling, so our examples do not use nullable foreign keys. This is "
"not a requirement of Hibernate, and the mappings will work if you drop the "
"nullability constraints."
msgstr ""
"null 可能な外部キーは従来型データモデリングの中では良い習慣と見なされていない"
"ため、すべての例で not null の外部キーを使用します。これは Hibernate の要件で"
"はありません。 not null 制約を外したとしても、マッピングは問題なく動作しま"
"す。"

#. Tag: title
#, no-c-format
msgid "Unidirectional associations"
msgstr "単方向関連"

#. Tag: title
#, fuzzy, no-c-format
msgid "Many-to-one"
msgstr "many-to-one"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional many-to-one association is the most "
"common kind of unidirectional association."
msgstr ""
"<emphasis>単方向多対一関連 は単方向関連の中で最も一般的なもので"
"す。"

#. Tag: title
#, fuzzy, no-c-format
msgid "One-to-one"
msgstr "one-to-one"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional one-to-one association on a foreign key はほとんど同じものです。唯一"
"違うのは、カラムのユニークな制約です。"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional one-to-one association on a primary key は通常、特別な ID ジェネレータ"
"を使います。 （この例では関連の方向が逆になっていることに注意してください）"

#. Tag: title
#, fuzzy, no-c-format
msgid "One-to-many"
msgstr "one-to-many"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional one-to-many association on a foreign key はとても特殊なケースで、あま"
"り推奨されていません。"

#. Tag: para
#, no-c-format
msgid "You should instead use a join table for this kind of association."
msgstr "このような関連のために結合テーブルを使うことをお薦めします。"

#. Tag: title
#, no-c-format
msgid "Unidirectional associations with join tables"
msgstr "結合テーブルを使った単方向関連"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional one-to-many association on a join tableunique=\"true\" はより好ましいで"
"す。 <literal>unique=\"true\" の指定により、多重度が多対多から一対"
"多に変わったことに注意して下さい。"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional many-to-one association on a join table は関連が任意であるときに"
"非常に一般的なものです。"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>unidirectional one-to-one association on a join table "
"is possible, but extremely unusual."
msgstr ""
"<emphasis>結合テーブルの単方向一対一関連 は、非常に特殊ですが不可"
"能ではありません。"

#. Tag: title
#, fuzzy, no-c-format
msgid "Many-to-many"
msgstr "many-to-many"

#. Tag: para
#, no-c-format
msgid ""
"Finally, here is an example of a <emphasis>unidirectional many-to-many "
"association</emphasis>."
msgstr "最後に、 <emphasis>単方向多対多関連 を示します。"

#. Tag: title
#, no-c-format
msgid "Bidirectional associations"
msgstr "双方向関連"

#. Tag: title
#, no-c-format
msgid "one-to-many / many-to-one"
msgstr "一対多/多対一"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>bidirectional many-to-one association is the most "
"common kind of association. The following example illustrates the standard "
"parent/child relationship."
msgstr ""
"<emphasis>双方向多対一関連 は最も一般的な関連です。 （標準的な親子"
"関係です）"

#. Tag: para
#, no-c-format
msgid ""
"If you use a <literal>List, or other indexed collection, set the "
"<literal>key column of the foreign key to not null and insert=\"false"
"\"</literal>:"
msgstr ""
"<literal>List （または他のインデックス付きのコレクション）を使うな"
"ら、外部キーの <literal>key カラムを not null に"
"設定し、コレクション側が各要素のインデックスをメンテナンスするように、関連を"
"扱う必要があります （<literal>update=\"false\" かつ "
"<literal>insert=\"false\" と設定して、反対側を仮想的に inverse にし"
"ます）："

#. Tag: para
#, fuzzy, no-c-format
msgid ""
"If the underlying foreign key column is <literal>NOT NULL, it is "
"important that you define <literal>not-null=\"true\" on the "
"<literal><key> element of the collection mapping. Do not "
"only declare <literal>not-null=\"true\" on a possible nested "
"<literal><column> element, but on the <key> であるならば、コレクション"
"マッピングの <literal><key> 要素を not-null=\"true"
"\"</literal> にすることは重要です。入れ子になった <column><key> 要素も "
"<literal>not-null=\"true\" と定義しないようにしてください。"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>bidirectional one-to-one association on a foreign key "
"is common:"
msgstr "<emphasis>外部キーの双方向一対一関連 は非常に一般的です。"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>bidirectional one-to-one association on a primary key "
"uses the special id generator:"
msgstr ""
"<emphasis>主キーの双方向一対一関連 は特殊な ID ジェネレータを使い"
"ます。"

#. Tag: title
#, no-c-format
msgid "Bidirectional associations with join tables"
msgstr "結合テーブルを使った双方向関連"

#. Tag: para
#, no-c-format
msgid ""
"The following is an example of a <emphasis>bidirectional one-to-many "
"association on a join table</emphasis>. The inverse=\"true\" です。 inverse="
"\"true\"</literal> が関連端、コレクション、結合のいずれかに設定できることに注"
"意してください。"

#. Tag: title
#, no-c-format
msgid "one to one"
msgstr "一対一"

#. Tag: para
#, no-c-format
msgid ""
"A <emphasis>bidirectional one-to-one association on a join table "
"is possible, but extremely unusual."
msgstr ""
"<emphasis>結合テーブルの双方向一対一関連 は非常に特殊ですが、可能"
"です。"

#. Tag: para
#, no-c-format
msgid ""
"Here is an example of a <emphasis>bidirectional many-to-many association を示します。"

#. Tag: title
#, no-c-format
msgid "More complex association mappings"
msgstr "より複雑な関連マッピング"

#. Tag: para
#, no-c-format
msgid ""
"More complex association joins are <emphasis>extremely rare. "
"Hibernate handles more complex situations by using SQL fragments embedded in "
"the mapping document. For example, if a table with historical account "
"information data defines <literal>accountNumber, "
"<literal>effectiveEndDate and effectiveStartDate 稀です。マッピングドキュメン"
"トに SQL 文を埋め込むことで、さらに複雑な状況を扱うことができます。例えば、 "
"<literal>accountNumber 、 effectiveEndDate 、 "
"<literal>effectiveStartDate カラムを持つ account （口座）情報の履歴"
"を扱うテーブルは、以下のようにマッピングします。"

#. Tag: para
#, no-c-format
msgid ""
"You can then map an association to the <emphasis>current "
"instance, the one with null <literal>effectiveEndDate, by using:"
msgstr ""
"そして、関連を <emphasis>現時点の インスタンス "
"（<literal>effectiveEndDate が null であるもの）にマッピングしま"
"す。以下のようになります："

#. Tag: para
#, no-c-format
msgid ""
"In a more complex example, imagine that the association between "
"<literal>Employee and Organization is "
"maintained in an <literal>Employment table full of historical "
"employment data. An association to the employee's <emphasis>most recentstartDate と "
"<literal>Organization（組織） 間の関連が Employment（雇"
"用）</literal> テーブルで保持される場合を想像してください。このテーブルには雇"
"用データの履歴がすべて含まれます。すると従業員の <emphasis>最も最近のstartDate を持つも"
"の）は、このようにマッピングできます："

#. Tag: para
#, no-c-format
msgid ""
"This functionality allows a degree of creativity and flexibility, but it is "
"more practical to handle these kinds of cases using HQL or a criteria query."
msgstr ""
"この機能は非常に強力です。しかしこのような場合、普通は HQL や criteria クエリ"
"を使う方がより実践的です。"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <many-to-one name=\"address\" \n"
#~ "        column=\"addressId\"\n"
#~ "        not-null=\"true\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key, addressId "
#~ "bigint not null )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key, addressId "
#~ "bigint not null )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <many-to-one name=\"address\" \n"
#~ "        column=\"addressId\" \n"
#~ "        unique=\"true\"\n"
#~ "        not-null=\"true\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key, addressId "
#~ "bigint not null unique )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key, addressId "
#~ "bigint not null unique )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "        </generator>\n"
#~ "    </id>\n"
#~ "    <one-to-one name=\"person\" constrained=\"true\"/>\n"
#~ "</class>]]>"
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"foreign\">\n"
#~ "            <param name=\"property\">person</param>\n"
#~ "        </generator>\n"
#~ "    </id>\n"
#~ "    <one-to-one name=\"person\" constrained=\"true\"/>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table Address ( personId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table Address ( personId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"addresses\">\n"
#~ "        <key column=\"personId\" \n"
#~ "            not-null=\"true\"/>\n"
#~ "        <one-to-many class=\"Address\"/>\n"
#~ "    </set>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table Address ( addressId bigint not null primary key, personId "
#~ "bigint not null )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table Address ( addressId bigint not null primary key, personId "
#~ "bigint not null )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"addresses\" table=\"PersonAddress\">\n"
#~ "        <key column=\"personId\"/>\n"
#~ "        <many-to-many column=\"addressId\"\n"
#~ "            unique=\"true\"\n"
#~ "            class=\"Address\"/>\n"
#~ "    </set>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId not null, addressId bigint not null "
#~ "primary key )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId not null, addressId bigint \n"
#~ "    not null primary key )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <join table=\"PersonAddress\" \n"
#~ "        optional=\"true\">\n"
#~ "        <key column=\"personId\" unique=\"true\"/>\n"
#~ "        <many-to-one name=\"address\"\n"
#~ "            column=\"addressId\" \n"
#~ "            not-null=\"true\"/>\n"
#~ "    </join>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null primary key, "
#~ "addressId bigint not null )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null primary key, "
#~ "addressId bigint not null )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <join table=\"PersonAddress\" \n"
#~ "        optional=\"true\">\n"
#~ "        <key column=\"personId\" \n"
#~ "            unique=\"true\"/>\n"
#~ "        <many-to-one name=\"address\"\n"
#~ "            column=\"addressId\" \n"
#~ "            not-null=\"true\"\n"
#~ "            unique=\"true\"/>\n"
#~ "    </join>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null primary key, "
#~ "addressId bigint not null unique )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null primary key, "
#~ "addressId bigint\n"
#~ "    not null unique )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"addresses\" table=\"PersonAddress\">\n"
#~ "        <key column=\"personId\"/>\n"
#~ "        <many-to-many column=\"addressId\"\n"
#~ "            class=\"Address\"/>\n"
#~ "    </set>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null, addressId bigint "
#~ "not null, primary key (personId, addressId) )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null, addressId bigint "
#~ "not null, \n"
#~ "    primary key (personId, addressId) )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <many-to-one name=\"address\" \n"
#~ "        column=\"addressId\"\n"
#~ "        not-null=\"true\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"people\" inverse=\"true\">\n"
#~ "        <key column=\"addressId\"/>\n"
#~ "        <one-to-many class=\"Person\"/>\n"
#~ "    </set>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "   <id name=\"id\"/>\n"
#~ "   ...\n"
#~ "   <many-to-one name=\"address\"\n"
#~ "      column=\"addressId\"\n"
#~ "      not-null=\"true\"\n"
#~ "      insert=\"false\"\n"
#~ "      update=\"false\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "   <id name=\"id\"/>\n"
#~ "   ...\n"
#~ "   <list name=\"people\">\n"
#~ "      <key column=\"addressId\" not-null=\"true\"/>\n"
#~ "      <list-index column=\"peopleIdx\"/>\n"
#~ "      <one-to-many class=\"Person\"/>\n"
#~ "   </list>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <many-to-one name=\"address\" \n"
#~ "        column=\"addressId\" \n"
#~ "        unique=\"true\"\n"
#~ "        not-null=\"true\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "   <one-to-one name=\"person\" \n"
#~ "        property-ref=\"address\"/>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "        </generator>\n"
#~ "    </id>\n"
#~ "    <one-to-one name=\"person\" \n"
#~ "        constrained=\"true\"/>\n"
#~ "</class>]]>"
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <one-to-one name=\"address\"/>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"foreign\">\n"
#~ "            <param name=\"property\">person</param>\n"
#~ "        </generator>\n"
#~ "    </id>\n"
#~ "    <one-to-one name=\"person\" \n"
#~ "        constrained=\"true\"/>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"addresses\" \n"
#~ "        table=\"PersonAddress\">\n"
#~ "        <key column=\"personId\"/>\n"
#~ "        <many-to-many column=\"addressId\"\n"
#~ "            unique=\"true\"\n"
#~ "            class=\"Address\"/>\n"
#~ "    </set>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <join table=\"PersonAddress\" \n"
#~ "        inverse=\"true\" \n"
#~ "        optional=\"true\">\n"
#~ "        <key column=\"addressId\"/>\n"
#~ "        <many-to-one name=\"person\"\n"
#~ "            column=\"personId\"\n"
#~ "            not-null=\"true\"/>\n"
#~ "    </join>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null, addressId bigint "
#~ "not null primary key )\n"
#~ "create table Address ( addressId bigint not null primary key )\n"
#~ "        ]]>"
#~ msgstr ""
#~ "create table Person ( personId bigint not null primary key )\n"
#~ "create table PersonAddress ( personId bigint not null, addressId bigint "
#~ "not null primary key )\n"
#~ "create table Address ( addressId bigint not null primary key )"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <join table=\"PersonAddress\" \n"
#~ "        optional=\"true\">\n"
#~ "        <key column=\"personId\" \n"
#~ "            unique=\"true\"/>\n"
#~ "        <many-to-one name=\"address\"\n"
#~ "            column=\"addressId\" \n"
#~ "            not-null=\"true\"\n"
#~ "            unique=\"true\"/>\n"
#~ "    </join>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <join table=\"PersonAddress\" \n"
#~ "        optional=\"true\"\n"
#~ "        inverse=\"true\">\n"
#~ "        <key column=\"addressId\" \n"
#~ "            unique=\"true\"/>\n"
#~ "        <many-to-one name=\"person\"\n"
#~ "            column=\"personId\" \n"
#~ "            not-null=\"true\"\n"
#~ "            unique=\"true\"/>\n"
#~ "    </join>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<class name=\"Person\">\n"
#~ "    <id name=\"id\" column=\"personId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"addresses\" table=\"PersonAddress\">\n"
#~ "        <key column=\"personId\"/>\n"
#~ "        <many-to-many column=\"addressId\"\n"
#~ "            class=\"Address\"/>\n"
#~ "    </set>\n"
#~ "</class>\n"
#~ "\n"
#~ "<class name=\"Address\">\n"
#~ "    <id name=\"id\" column=\"addressId\">\n"
#~ "        <generator class=\"native\"/>\n"
#~ "    </id>\n"
#~ "    <set name=\"people\" inverse=\"true\" table=\"PersonAddress\">\n"
#~ "        <key column=\"addressId\"/>\n"
#~ "        <many-to-many column=\"personId\"\n"
#~ "            class=\"Person\"/>\n"
#~ "    </set>\n"
#~ "</class>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<properties name=\"currentAccountKey\">\n"
#~ "    <property name=\"accountNumber\" type=\"string\" not-null=\"true\"/"
#~ ">\n"
#~ "    <property name=\"currentAccount\" type=\"boolean\">\n"
#~ "        <formula>case when effectiveEndDate is null then 1 else 0 "
#~ "end</formula>\n"
#~ "    </property>\n"
#~ "</properties>\n"
#~ "<property name=\"effectiveEndDate\" type=\"date\"/>\n"
#~ "<property name=\"effectiveStateDate\" type=\"date\" not-null=\"true\"/"
#~ ">"

#, fuzzy
#~ msgid ""
#~ "<![CDATA[\n"
#~ "</many-to-one>]]>"
#~ msgstr ""
#~ "<many-to-one name=\"currentAccountInfo\" \n"
#~ "        property-ref=\"currentAccountKey\"\n"
#~ "        class=\"AccountInfo\">\n"
#~ "    <column name=\"accountNumber\"/>\n"
#~ "    <formula>'1'</formula>\n"
#~ "</many-to-one>"

#, fuzzy
#~ msgid ""
#~ "<![CDATA["
#~ msgstr ""
#~ "<join>\n"
#~ "    <key column=\"employeeId\"/>\n"
#~ "    <subselect>\n"
#~ "        select employeeId, orgId \n"
#~ "        from Employments \n"
#~ "        group by orgId \n"
#~ "        having startDate = max(startDate)\n"
#~ "    </subselect>\n"
#~ "    <many-to-one name=\"mostRecentEmployer\" \n"
#~ "            class=\"Organization\" \n"
#~ "            column=\"orgId\"/>\n"
#~ "</join>"