query_sql.pot

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

#: query_sql.xml:255
#, no-c-format
msgid "{[aliasname].[propertyname]"
msgstr ""

#. Tag: literal
#: query_sql.xml:257
#, no-c-format
msgid "A_NAME as {item.name}"
msgstr ""

#. Tag: entry
#: query_sql.xml:261
#, no-c-format
msgid "A composite property"
msgstr ""

#. Tag: literal
#: query_sql.xml:263
#, no-c-format
msgid "{[aliasname].[componentname].[propertyname]}"
msgstr ""

#. Tag: literal
#: query_sql.xml:265
#, no-c-format
msgid "CURRENCY as {item.amount.currency}, VALUE as {item.amount.value}"
msgstr ""

#. Tag: entry
#: query_sql.xml:270
#, no-c-format
msgid "Discriminator of an entity"
msgstr ""

#. Tag: literal
#: query_sql.xml:272
#, no-c-format
msgid "{[aliasname].class}"
msgstr ""

#. Tag: literal
#: query_sql.xml:274
#, no-c-format
msgid "DISC as {item.class}"
msgstr ""

#. Tag: entry
#: query_sql.xml:278
#, no-c-format
msgid "All properties of an entity"
msgstr ""

#. Tag: literal
#: query_sql.xml:280 query_sql.xml:328
#, no-c-format
msgid "{[aliasname].*}"
msgstr ""

#. Tag: literal
#: query_sql.xml:282
#, no-c-format
msgid "{item.*}"
msgstr ""

#. Tag: entry
#: query_sql.xml:286
#, no-c-format
msgid "A collection key"
msgstr ""

#. Tag: literal
#: query_sql.xml:288
#, no-c-format
msgid "{[aliasname].key}"
msgstr ""

#. Tag: literal
#: query_sql.xml:290
#, no-c-format
msgid "ORGID as {coll.key}"
msgstr ""

#. Tag: entry
#: query_sql.xml:294
#, no-c-format
msgid "The id of an collection"
msgstr ""

#. Tag: literal
#: query_sql.xml:296
#, no-c-format
msgid "{[aliasname].id}"
msgstr ""

#. Tag: literal
#: query_sql.xml:298
#, no-c-format
msgid "EMPID as {coll.id}"
msgstr ""

#. Tag: entry
#: query_sql.xml:302
#, no-c-format
msgid "The element of an collection"
msgstr ""

#. Tag: literal
#: query_sql.xml:304
#, no-c-format
msgid "{[aliasname].element}"
msgstr ""

#. Tag: literal
#: query_sql.xml:306
#, no-c-format
msgid "XID as {coll.element}"
msgstr ""

#. Tag: entry
#: query_sql.xml:310
#, no-c-format
msgid "roperty of the element in the collection"
msgstr ""

#. Tag: literal
#: query_sql.xml:312
#, no-c-format
msgid "{[aliasname].element.[propertyname]}"
msgstr ""

#. Tag: literal
#: query_sql.xml:314
#, no-c-format
msgid "NAME as {coll.element.name}"
msgstr ""

#. Tag: entry
#: query_sql.xml:318
#, no-c-format
msgid "All properties of the element in the collection"
msgstr ""

#. Tag: literal
#: query_sql.xml:320
#, no-c-format
msgid "{[aliasname].element.*}"
msgstr ""

#. Tag: literal
#: query_sql.xml:322
#, no-c-format
msgid "{coll.element.*}"
msgstr ""

#. Tag: entry
#: query_sql.xml:326
#, no-c-format
msgid "All properties of the the collection"
msgstr ""

#. Tag: literal
#: query_sql.xml:330
#, no-c-format
msgid "{coll.*}"
msgstr ""

#. Tag: title
#: query_sql.xml:339
#, no-c-format
msgid "Returning non-managed entities"
msgstr ""

#. Tag: para
#: query_sql.xml:341
#, no-c-format
msgid "It is possible to apply a ResultTransformer to native sql queries. Allowing it to e.g. return non-managed entities."
msgstr ""

#. Tag: programlisting
#: query_sql.xml:343
#, no-c-format
msgid ""
      "<![CDATA[sess.createSQLQuery(\"SELECT NAME, BIRTHDATE FROM CATS\")\n"
      "        .setResultTransformer(Transformers.aliasToBean(CatDTO.class))]]>"
msgstr ""

#. Tag: para
#: query_sql.xml:353
#, no-c-format
msgid "a result transformer"
msgstr ""

#. Tag: para
#: query_sql.xml:357
#, no-c-format
msgid "The above query will return a list of <literal>CatDTO</literal> which has been instantiated and injected the values of NAME and BIRTHNAME into its corresponding properties or fields."
msgstr ""

#. Tag: title
#: query_sql.xml:364
#, no-c-format
msgid "Handling inheritance"
msgstr ""

#. Tag: para
#: query_sql.xml:366
#, no-c-format
msgid "Native sql queries which query for entities that is mapped as part of an inheritance must include all properties for the baseclass and all it subclasses."
msgstr ""

#. Tag: title
#: query_sql.xml:372
#, no-c-format
msgid "Parameters"
msgstr ""

#. Tag: para
#: query_sql.xml:374
#, no-c-format
msgid "Native sql queries support positional as well as named parameters:"
msgstr ""

#. Tag: programlisting
#: query_sql.xml:377
#, no-c-format
msgid ""
      "<![CDATA[Query query = sess.createSQLQuery(\"SELECT * FROM CATS WHERE NAME like ?\").addEntity(Cat.class);\n"
      "List pusList = query.setString(0, \"Pus%\").list();\n"
      "     \n"
      "query = sess.createSQLQuery(\"SELECT * FROM CATS WHERE NAME like :name\").addEntity(Cat.class);\n"
      "List pusList = query.setString(\"name\", \"Pus%\").list();          ]]>"
msgstr ""

#. Tag: title
#: query_sql.xml:385
#, no-c-format
msgid "Named SQL queries"
msgstr ""

#. Tag: para
#: query_sql.xml:387
#, no-c-format
msgid "Named SQL queries may be defined in the mapping document and called in exactly the same way as a named HQL query. In this case, we do <emphasis>not</emphasis> need to call <literal>addEntity()</literal>."
msgstr ""

#. Tag: programlisting
#: query_sql.xml:392
#, no-c-format
msgid ""
      "<![CDATA[<sql-query name=\"persons\">\n"
      "    <return alias=\"person\" class=\"eg.Person\"/>\n"
      "    SELECT person.NAME AS {person.name},\n"
      "           person.AGE AS {person.age},\n"
      "           person.SEX AS {person.sex}\n"
      "    FROM PERSON person\n"
      "    WHERE person.NAME LIKE :namePattern\n"
      "</sql-query>]]>"
msgstr ""

#. Tag: programlisting
#: query_sql.xml:394
#, no-c-format
msgid ""
      "<![CDATA[List people = sess.getNamedQuery(\"persons\")\n"
      "    .setString(\"namePattern\", namePattern)\n"
      "    .setMaxResults(50)\n"
      "    .list();]]>"
msgstr ""

#. Tag: para
#: query_sql.xml:396
#, no-c-format
msgid "The <literal>&lt;return-join&gt;</literal> and <literal>&lt;load-collection&gt;</literal> elements are used to join associations and define queries which initialize collections, respectively."
msgstr ""

#. Tag: programlisting
#: query_sql.xml:401
#, no-c-format
msgid ""
      "<![CDATA[<sql-query name=\"personsWith\">\n"
      "    <return alias=\"person\" class=\"eg.Person\"/>\n"
      "    <return-join alias=\"address\" property=\"person.mailingAddress\"/>\n"
      "    SELECT person.NAME AS {person.name},\n"
      "           person.AGE AS {person.age},\n"
      "           person.SEX AS {person.sex},\n"
      "           address.STREET AS {address.street},\n"
      "           address.CITY AS {address.city},\n"
      "           address.STATE AS {address.state},\n"
      "           address.ZIP AS {address.zip}\n"
      "    FROM PERSON person\n"
      "    JOIN ADDRESS address\n"
      "        ON person.ID = address.PERSON_ID AND address.TYPE='MAILING'\n"
      "    WHERE person.NAME LIKE :namePattern\n"
      "</sql-query>]]>"
msgstr ""

#. Tag: para
#: query_sql.xml:403
#, no-c-format
msgid "A named SQL query may return a scalar value. You must declare the column alias and Hibernate type using the <literal>&lt;return-scalar&gt;</literal> element:"
msgstr ""

#. Tag: programlisting
#: query_sql.xml:407
#, no-c-format
msgid ""
      "<![CDATA[<sql-query name=\"mySqlQuery\">\n"
      "    <return-scalar column=\"name\" type=\"string\"/>\n"
      "    <return-scalar column=\"age\" type=\"long\"/>\n"
      "    SELECT p.NAME AS name,\n"
      "           p.AGE AS age,\n"
      "    FROM PERSON p WHERE p.NAME LIKE 'Hiber%'\n"
      "</sql-query>]]>"
msgstr ""

#. Tag: para
#: query_sql.xml:409
#, no-c-format
msgid "You can externalize the resultset mapping informations in a <literal>&lt;resultset&gt;</literal> element to either reuse them across several named queries or through the <literal>setResultSetMapping()</literal> API."
msgstr ""

#. Tag: programlisting
#: query_sql.xml:414
#, no-c-format
msgid ""
      "<![CDATA[<resultset name=\"personAddress\">\n"
      "    <return alias=\"person\" class=\"eg.Person\"/>\n"
      "    <return-join alias=\"address\" property=\"person.mailingAddress\"/>\n"
      "</resultset>\n"
      "\n"
      "<sql-query name=\"personsWith\" resultset-ref=\"personAddress\">\n"
      "    SELECT person.NAME AS {person.name},\n"
      "           person.AGE AS {person.age},\n"
      "           person.SEX AS {person.sex},\n"
      "           address.STREET AS {address.street},\n"
      "           address.CITY AS {address.city},\n"
      "           address.STATE AS {address.state},\n"
      "           address.ZIP AS {address.zip}\n"
      "    FROM PERSON person\n"
      "    JOIN ADDRESS address\n"
      "        ON person.ID = address.PERSON_ID AND address.TYPE='MAILING'\n"
      "    WHERE person.NAME LIKE :namePattern\n"
      "</sql-query>]]>"
msgstr ""

#. Tag: para
#: query_sql.xml:416
#, no-c-format
msgid "You can alternatively use the resultset mapping information in your hbm files directly in java code."
msgstr ""

#. Tag: programlisting
#: query_sql.xml:419
#, no-c-format
msgid ""
      "<![CDATA[List cats = sess.createSQLQuery(\n"
      "        \"select {cat.*}, {kitten.*} from cats cat, cats kitten where kitten.mother = cat.id\"\n"
      "    )\n"
      "    .setResultSetMapping(\"catAndKitten\")\n"
      "    .list();]]>"
msgstr ""

#. Tag: title
#: query_sql.xml:422
#, no-c-format
msgid "Using return-property to explicitly specify column/alias names"
msgstr ""

#. Tag: para
#: query_sql.xml:425