This example Hibernate source code file (batch.pot) 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
for, hibernate, hql, hql, in, jdbc, sql, tag, tag, the, the, this, this, you
The Hibernate batch.pot source code
#
# AUTHOR <EMAIL@ADDRESS>, YEAR.
#
msgid ""
msgstr ""
"Project-Id-Version: 0\n"
"POT-Creation-Date: 2010-02-11T05:38:15\n"
"PO-Revision-Date: 2010-02-11T05:38:15\n"
"Last-Translator: Automatically generated\n"
"Language-Team: None\n"
"MIME-Version: 1.0\n"
"Content-Type: application/x-publican; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
#. Tag: title
#, no-c-format
msgid "Batch processing"
msgstr ""
#. Tag: para
#, no-c-format
msgid "A naive approach to inserting 100,000 rows in the database using Hibernate might look like this:"
msgstr ""
#. Tag: para
#, no-c-format
msgid "This would fall over with an <literal>OutOfMemoryException somewhere around the 50,000th row. That is because Hibernate caches all the newly inserted Customer instances in the session-level cache. In this chapter we will show you how to avoid this problem."
msgstr ""
#. Tag: para
#, no-c-format
msgid "If you are undertaking batch processing you will need to enable the use of JDBC batching. This is absolutely essential if you want to achieve optimal performance. Set the JDBC batch size to a reasonable number (10-50, for example):"
msgstr ""
#. Tag: para
#, no-c-format
msgid "Hibernate disables insert batching at the JDBC level transparently if you use an <literal>identity identifier generator."
msgstr ""
#. Tag: para
#, no-c-format
msgid "You can also do this kind of work in a process where interaction with the second-level cache is completely disabled:"
msgstr ""
#. Tag: para
#, no-c-format
msgid "However, this is not absolutely necessary, since we can explicitly set the <literal>CacheMode to disable interaction with the second-level cache."
msgstr ""
#. Tag: title
#, no-c-format
msgid "Batch inserts"
msgstr ""
#. Tag: para
#, no-c-format
msgid "When making new objects persistent <literal>flush() and then clear() the session regularly in order to control the size of the first-level cache."
msgstr ""
#. Tag: title
#, no-c-format
msgid "Batch updates"
msgstr ""
#. Tag: para
#, no-c-format
msgid "For retrieving and updating data, the same ideas apply. In addition, you need to use <literal>scroll() to take advantage of server-side cursors for queries that return many rows of data."
msgstr ""
#. Tag: title
#, no-c-format
msgid "The StatelessSession interface"
msgstr ""
#. Tag: para
#, no-c-format
msgid "Alternatively, Hibernate provides a command-oriented API that can be used for streaming data to and from the database in the form of detached objects. A <literal>StatelessSession has no persistence context associated with it and does not provide many of the higher-level life cycle semantics. In particular, a stateless session does not implement a first-level cache nor interact with any second-level or query cache. It does not implement transactional write-behind or automatic dirty checking. Operations performed using a stateless session never cascade to associated instances. Collections are ignored by a stateless session. Operations performed via a stateless session bypass Hibernate's event model and interceptors. Due to the lack of a first-level cache, Stateless sessions are vulnerable to data aliasing effects. A stateless session is a lower-level abstraction that is much closer to the underlying JDBC."
msgstr ""
#. Tag: para
#, no-c-format
msgid "In this code example, the <literal>Customer instances returned by the query are immediately detached. They are never associated with any persistence context."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The <literal>insert(), update() and delete() operations defined by the StatelessSession interface are considered to be direct database row-level operations. They result in the immediate execution of a SQL INSERT, UPDATE or DELETE respectively. They have different semantics to the save(), saveOrUpdate() and delete() operations defined by the Session interface."
msgstr ""
#. Tag: title
#, no-c-format
msgid "DML-style operations"
msgstr ""
#. Tag: para
#, no-c-format
msgid "As already discussed, automatic and transparent object/relational mapping is concerned with the management of the object state. The object state is available in memory. This means that manipulating data directly in the database (using the SQL <literal>Data Manipulation Language (DML) the statements: INSERT, UPDATE, DELETE) will not affect in-memory state. However, Hibernate provides methods for bulk SQL-style DML statement execution that is performed through the Hibernate Query Language (HQL)."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The pseudo-syntax for <literal>UPDATE and DELETE statements is: ( UPDATE | DELETE ) FROM? EntityName (WHERE where_conditions)?."
msgstr ""
#. Tag: para
#, no-c-format
msgid "Some points to note:"
msgstr ""
#. Tag: para
#, no-c-format
msgid "In the from-clause, the FROM keyword is optional"
msgstr ""
#. Tag: para
#, no-c-format
msgid "There can only be a single entity named in the from-clause. It can, however, be aliased. If the entity name is aliased, then any property references must be qualified using that alias. If the entity name is not aliased, then it is illegal for any property references to be qualified."
msgstr ""
#. Tag: para
#, no-c-format
msgid "No <link linkend=\"queryhql-joins-forms\">joins, either implicit or explicit, can be specified in a bulk HQL query. Sub-queries can be used in the where-clause, where the subqueries themselves may contain joins."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The where-clause is also optional."
msgstr ""
#. Tag: para
#, no-c-format
msgid "As an example, to execute an HQL <literal>UPDATE, use the Query.executeUpdate() method. The method is named for those familiar with JDBC's PreparedStatement.executeUpdate():"
msgstr ""
#. Tag: para
#, no-c-format
msgid "In keeping with the EJB3 specification, HQL <literal>UPDATE statements, by default, do not effect the version or the timestamp property values for the affected entities. However, you can force Hibernate to reset the version or timestamp property values through the use of a versioned update. This is achieved by adding the VERSIONED keyword after the UPDATE keyword."
msgstr ""
#. Tag: para
#, no-c-format
msgid "Custom version types, <literal>org.hibernate.usertype.UserVersionType, are not allowed in conjunction with a update versioned statement."
msgstr ""
#. Tag: para
#, no-c-format
msgid "To execute an HQL <literal>DELETE, use the same Query.executeUpdate() method:"
msgstr ""
#. Tag: para
#, no-c-format
msgid "The <literal>int value returned by the Query.executeUpdate() method indicates the number of entities effected by the operation. This may or may not correlate to the number of rows effected in the database. An HQL bulk operation might result in multiple actual SQL statements being executed (for joined-subclass, for example). The returned number indicates the number of actual entities affected by the statement. Going back to the example of joined-subclass, a delete against one of the subclasses may actually result in deletes against not just the table to which that subclass is mapped, but also the \"root\" table and potentially joined-subclass tables further down the inheritance hierarchy."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The pseudo-syntax for <literal>INSERT statements is: INSERT INTO EntityName properties_list select_statement. Some points to note:"
msgstr ""
#. Tag: para
#, no-c-format
msgid "Only the INSERT INTO ... SELECT ... form is supported; not the INSERT INTO ... VALUES ... form."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The properties_list is analogous to the <literal>column specification in the SQL INSERT statement. For entities involved in mapped inheritance, only properties directly defined on that given class-level can be used in the properties_list. Superclass properties are not allowed and subclass properties do not make sense. In other words, INSERT statements are inherently non-polymorphic."
msgstr ""
#. Tag: para
#, no-c-format
msgid "select_statement can be any valid HQL select query, with the caveat that the return types must match the types expected by the insert. Currently, this is checked during query compilation rather than allowing the check to relegate to the database. This might, however, cause problems between Hibernate <literal>Types which are equivalent as opposed to equal. This might cause issues with mismatches between a property defined as a org.hibernate.type.DateType and a property defined as a org.hibernate.type.TimestampType, even though the database might not make a distinction or might be able to handle the conversion."
msgstr ""
#. Tag: para
#, no-c-format
msgid "For the id property, the insert statement gives you two options. You can either explicitly specify the id property in the properties_list, in which case its value is taken from the corresponding select expression, or omit it from the properties_list, in which case a generated value is used. This latter option is only available when using id generators that operate in the database; attempting to use this option with any \"in memory\" type generators will cause an exception during parsing. For the purposes of this discussion, in-database generators are considered to be <literal>org.hibernate.id.SequenceGenerator (and its subclasses) and any implementers of org.hibernate.id.PostInsertIdentifierGenerator. The most notable exception here is org.hibernate.id.TableHiLoGenerator, which cannot be used because it does not expose a selectable way to get its values."
msgstr ""
#. Tag: para
#, no-c-format
msgid "For properties mapped as either <literal>version or timestamp, the insert statement gives you two options. You can either specify the property in the properties_list, in which case its value is taken from the corresponding select expressions, or omit it from the properties_list, in which case the seed value defined by the org.hibernate.type.VersionType is used."
msgstr ""
#. Tag: para
#, no-c-format
msgid "The following is an example of an HQL <literal>INSERT statement execution:"
msgstr ""
Other Hibernate examples (source code examples)
Here is a short list of links related to this Hibernate batch.pot source code file: