Author: d.plentz Date: 2007-07-13 00:14:38 -0400 (Fri, 13 Jul 2007) New Revision: 12763 Modified: core/trunk/documentation/manual/en-US/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/es-ES/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/fr-FR/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/ja-JP/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/ko-KR/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/pt-BR/src/main/docbook/modules/query_sql.xml core/trunk/documentation/manual/zh-CN/src/main/docbook/modules/query_sql.xml Log: [HHH-2719] adddress --> address Modified: core/trunk/documentation/manual/en-US/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/en-US/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/en-US/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -425,12 +425,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -461,12 +461,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> Modified: core/trunk/documentation/manual/es-ES/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/es-ES/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/es-ES/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -139,12 +139,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> Modified: core/trunk/documentation/manual/fr-FR/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/fr-FR/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/fr-FR/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -276,12 +276,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern &lt;/sql-query&gt;</programlisting> @@ -315,12 +315,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern &lt;/sql-query&gt;</programlisting> Modified: core/trunk/documentation/manual/ja-JP/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/ja-JP/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/ja-JP/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -391,12 +391,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -429,12 +429,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> Modified: core/trunk/documentation/manual/ko-KR/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/ko-KR/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/ko-KR/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -394,12 +394,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -428,12 +428,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> Modified: core/trunk/documentation/manual/pt-BR/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/pt-BR/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/pt-BR/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -1,4 +1,4 @@ -<?xml version="1.0" encoding="ISO-8859-1"?> +<?xml version="1.0" encoding="ISO-8859-1"?> <chapter id="querysql" revision="2"> <title>Native SQL</title> @@ -425,12 +425,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -461,12 +461,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -601,10 +601,10 @@ <itemizedlist spacing="compact"> <listitem> <para> - A funçãp deve retornar um result set. O primeiro parâmetro da procedure - dever ser uma <literal>SAÍDA</literal> que retorne um result set. Isto é feito - usando o tipo a <literal>SYS_REFCURSOR</literal> no Oracle 9 ou 10. No Oracle é - necessário definir o tipo <literal>REF CURSOR</literal>, veja a documentação do Oracle. + A fun��p deve retornar um result set. O primeiro par�metro da procedure + dever ser uma <literal>SA�DA</literal> que retorne um result set. Isto � feito + usando o tipo a <literal>SYS_REFCURSOR</literal> no Oracle 9 ou 10. No Oracle � + necess�rio definir o tipo <literal>REF CURSOR</literal>, veja a documenta��o do Oracle. </para> </listitem> </itemizedlist> @@ -615,16 +615,16 @@ <listitem> <para> A procedure deve retornar um result set. Veja que este servidor pode retornar - múltiplos result sets e update counts. O Hibernate ira iterar os resultados e - pegar o primeiro resultado que é o valor de retorno do result set. - O resto será descartado. + m�ltiplos result sets e update counts. O Hibernate ira iterar os resultados e + pegar o primeiro resultado que � o valor de retorno do result set. + O resto ser� descartado. </para> </listitem> <listitem> <para> - Se você habilitar <literal>SET NOCOUNT ON</literal> na sua procedure, ela - provavelmente será mais eficiente. Mas, isto não é obrigatório</para> + Se voc� habilitar <literal>SET NOCOUNT ON</literal> na sua procedure, ela + provavelmente ser� mais eficiente. Mas, isto n�o � obrigat�rio</para> </listitem> </itemizedlist> </sect3> @@ -642,9 +642,9 @@ <literal>&lt;sql-delete&gt;</literal>, and <literal>&lt;sql-update&gt;</literal> override these strings: - Hibernate3 pode usar SQL customizado para operações de create, update e delete. - A persistência de classe e collection no hibernate já contem alguma strings - de configurações (insertsql, deletesql, updatesql etc.). + Hibernate3 pode usar SQL customizado para opera��es de create, update e delete. + A persist�ncia de classe e collection no hibernate j� contem alguma strings + de configura��es (insertsql, deletesql, updatesql etc.). O mapaemento das tags <literal>&lt;sql-insert&gt;</literal>, <literal>&lt;sql-delete&gt;</literal>, e @@ -663,13 +663,13 @@ </class>]]></programlisting> <para> - O SQL é executado diretamente no seu banco de dados, então você pode usar qualquer + O SQL � executado diretamente no seu banco de dados, ent�o voc� pode usar qualquer linguagem que quiser. Isto com certeza reduzira a portabilidade do seu mapeamento se - você utilizar um SQL para um banco de dados especifico. + voc� utilizar um SQL para um banco de dados especifico. </para> <para> - Stored Procedures são suportadas se o atributo the + Stored Procedures s�o suportadas se o atributo the <literal>callable</literal> estiver ativado: </para> @@ -684,22 +684,22 @@ </class>]]></programlisting> <para> - A ordem de posições dos parâmetros são vitais, pois eles devem estar na mesma seqüência + A ordem de posi��es dos par�metros s�o vitais, pois eles devem estar na mesma seq��ncia esperada pelo Hibernate. </para> - <para>Você pode ver a ordem esperada ativando o debug logging no nível - <literal>org.hibernate.persister.entity</literal>. Com este nível ativado, o Hibernate - irá imprimir o SQL estático que foi usado para create, update, delete, etc. - Entidades. (Para ver a seqüência esperada, lembre-se de não incluir seu SQL - customizado no arquivo de mapeamento, pois ele irá sobreecreve o SQL - estático gerado pelo Hibernate). + <para>Voc� pode ver a ordem esperada ativando o debug logging no n�vel + <literal>org.hibernate.persister.entity</literal>. Com este n�vel ativado, o Hibernate + ir� imprimir o SQL est�tico que foi usado para create, update, delete, etc. + Entidades. (Para ver a seq��ncia esperada, lembre-se de n�o incluir seu SQL + customizado no arquivo de mapeamento, pois ele ir� sobreecreve o SQL + est�tico gerado pelo Hibernate). </para> - <para>As stored procedures são na maioria dos casos (leia: melhor não fazer) requeridas para + <para>As stored procedures s�o na maioria dos casos (leia: melhor n�o fazer) requeridas para retornar o numero de linhas inseridas/atualizadas/deletadas. O hibernate tem algumas - verificações em tempo de execução para o sucesso da declaração. Hibernate sempre registra - o primeiro parâmetro da declaração como uma saída numérica para operações CRUD. + verifica��es em tempo de execu��o para o sucesso da declara��o. Hibernate sempre registra + o primeiro par�metro da declara��o como uma sa�da num�rica para opera��es CRUD. </para> <programlisting><![CDATA[CREATE OR REPLACE FUNCTION updatePerson (uid IN NUMBER, uname IN VARCHAR2) @@ -723,7 +723,7 @@ <title>SQL customizado para carga</title> <para> - Você pode declarar sua própria query SQL (ou HQL) para iniciar entidades: + Voc� pode declarar sua pr�pria query SQL (ou HQL) para iniciar entidades: </para> <programlisting><![CDATA[<sql-query name="person"> @@ -735,8 +735,8 @@ </sql-query>]]></programlisting> <para> - Este é apenas uma declaração de query com nome, como discutido anteriormente. - Você pode referenciar esta query com nome em um mapeamento de classe: + Este � apenas uma declara��o de query com nome, como discutido anteriormente. + Voc� pode referenciar esta query com nome em um mapeamento de classe: </para> <programlisting><![CDATA[<class name="Person"> @@ -747,10 +747,10 @@ <loader query-ref="person"/> </class>]]></programlisting> - <para>Isto também funciona com stored procedures. + <para>Isto tamb�m funciona com stored procedures. </para> - <para>Você pode tembém definir uma query para iniciar collection: + <para>Voc� pode temb�m definir uma query para iniciar collection: </para> <programlisting><![CDATA[<set name="employments" inverse="true"> Modified: core/trunk/documentation/manual/zh-CN/src/main/docbook/modules/query_sql.xml =================================================================== --- core/trunk/documentation/manual/zh-CN/src/main/docbook/modules/query_sql.xml 2007-07-12 23:17:46 UTC (rev 12762) +++ core/trunk/documentation/manual/zh-CN/src/main/docbook/modules/query_sql.xml 2007-07-13 04:14:38 UTC (rev 12763) @@ -377,12 +377,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting> @@ -417,12 +417,12 @@ SELECT person.NAME AS {person.name}, person.AGE AS {person.age}, person.SEX AS {person.sex}, - adddress.STREET AS {address.street}, - adddress.CITY AS {address.city}, - adddress.STATE AS {address.state}, - adddress.ZIP AS {address.zip} + address.STREET AS {address.street}, + address.CITY AS {address.city}, + address.STATE AS {address.state}, + address.ZIP AS {address.zip} FROM PERSON person - JOIN ADDRESS adddress + JOIN ADDRESS address ON person.ID = address.PERSON_ID AND address.TYPE='MAILING' WHERE person.NAME LIKE :namePattern </sql-query>]]></programlisting>