Java Doc for BatchSqlUpdate.java in  » J2EE » spring-framework-2.5 » org » springframework » jdbc » object » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » J2EE » spring framework 2.5 » org.springframework.jdbc.object 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   org.springframework.jdbc.object.RdbmsOperation
      org.springframework.jdbc.object.SqlOperation
         org.springframework.jdbc.object.SqlUpdate
            org.springframework.jdbc.object.BatchSqlUpdate

BatchSqlUpdate
public class BatchSqlUpdate extends SqlUpdate (Code)
SqlUpdate subclass that performs batch update operations. Encapsulates queuing up records to be updated, and adds them as a single batch once flush is called or the given batch size has been met.

Note that this class is a non-thread-safe object, in contrast to all other JDBC operations objects in this package. You need to create a new instance of it for each use, or call reset before reuse within the same thread.
author:
   Keith Donald
author:
   Juergen Hoeller
since:
   1.1
See Also:   BatchSqlUpdate.flush
See Also:   BatchSqlUpdate.reset



Field Summary
public static  intDEFAULT_BATCH_SIZE
     Default number of inserts to accumulate before commiting a batch (5000).

Constructor Summary
public  BatchSqlUpdate()
     Constructor to allow use as a JavaBean.
public  BatchSqlUpdate(DataSource ds, String sql)
     Construct an update object with a given DataSource and SQL.
public  BatchSqlUpdate(DataSource ds, String sql, int[] types)
     Construct an update object with a given DataSource, SQL and anonymous parameters.
public  BatchSqlUpdate(DataSource ds, String sql, int[] types, int batchSize)
     Construct an update object with a given DataSource, SQL, anonymous parameters and specifying the maximum number of rows that may be affected.

Method Summary
public  int[]flush()
     Trigger any queued update operations to be added as a final batch.
public  intgetExecutionCount()
     Return the number of already executed statements.
public  intgetQueueCount()
     Return the current number of statements or statement parameters in the queue.
public  int[]getRowsAffected()
     Return the number of affected rows for all already executed statements.
public  voidreset()
     Reset the statement parameter queue, the rows affected cache, and the execution count.
public  voidsetBatchSize(int batchSize)
     Set the number of statements that will trigger an automatic intermediate flush.
public  voidsetTrackRowsAffected(boolean trackRowsAffected)
     Set whether to track the rows affected by batch updates performed by this operation object.

Default is "true".

protected  booleansupportsLobParameters()
     BatchSqlUpdate does not support BLOB or CLOB parameters.
public  intupdate(Object[] params)
     Overridden version of update that adds the given statement parameters to the queue rather than executing them immediately.

Field Detail
DEFAULT_BATCH_SIZE
public static int DEFAULT_BATCH_SIZE(Code)
Default number of inserts to accumulate before commiting a batch (5000).




Constructor Detail
BatchSqlUpdate
public BatchSqlUpdate()(Code)
Constructor to allow use as a JavaBean. DataSource and SQL must be supplied before compilation and use.
See Also:   BatchSqlUpdate.setDataSource
See Also:   BatchSqlUpdate.setSql



BatchSqlUpdate
public BatchSqlUpdate(DataSource ds, String sql)(Code)
Construct an update object with a given DataSource and SQL.
Parameters:
  ds - DataSource to use to obtain connections
Parameters:
  sql - SQL statement to execute



BatchSqlUpdate
public BatchSqlUpdate(DataSource ds, String sql, int[] types)(Code)
Construct an update object with a given DataSource, SQL and anonymous parameters.
Parameters:
  ds - DataSource to use to obtain connections
Parameters:
  sql - SQL statement to execute
Parameters:
  types - SQL types of the parameters, as defined in thejava.sql.Types class
See Also:   java.sql.Types



BatchSqlUpdate
public BatchSqlUpdate(DataSource ds, String sql, int[] types, int batchSize)(Code)
Construct an update object with a given DataSource, SQL, anonymous parameters and specifying the maximum number of rows that may be affected.
Parameters:
  ds - DataSource to use to obtain connections
Parameters:
  sql - SQL statement to execute
Parameters:
  types - SQL types of the parameters, as defined in thejava.sql.Types class
Parameters:
  batchSize - the number of statements that will triggeran automatic intermediate flush
See Also:   java.sql.Types




Method Detail
flush
public int[] flush()(Code)
Trigger any queued update operations to be added as a final batch. an array of the number of rows affected by each statement



getExecutionCount
public int getExecutionCount()(Code)
Return the number of already executed statements.



getQueueCount
public int getQueueCount()(Code)
Return the current number of statements or statement parameters in the queue.



getRowsAffected
public int[] getRowsAffected()(Code)
Return the number of affected rows for all already executed statements. Accumulates all of flush's return values until reset is invoked. an array of the number of rows affected by each statement
See Also:   BatchSqlUpdate.reset



reset
public void reset()(Code)
Reset the statement parameter queue, the rows affected cache, and the execution count.



setBatchSize
public void setBatchSize(int batchSize)(Code)
Set the number of statements that will trigger an automatic intermediate flush. update calls or the given statement parameters will be queued until the batch size is met, at which point it will empty the queue and execute the batch.

You can also flush already queued statements with an explicit flush call. Note that you need to this after queueing all parameters to guarantee that all statements have been flushed.




setTrackRowsAffected
public void setTrackRowsAffected(boolean trackRowsAffected)(Code)
Set whether to track the rows affected by batch updates performed by this operation object.

Default is "true". Turn this off to save the memory needed for the list of row counts.
See Also:   BatchSqlUpdate.getRowsAffected()




supportsLobParameters
protected boolean supportsLobParameters()(Code)
BatchSqlUpdate does not support BLOB or CLOB parameters.



update
public int update(Object[] params) throws DataAccessException(Code)
Overridden version of update that adds the given statement parameters to the queue rather than executing them immediately. All other update methods of the SqlUpdate base class go through this method and will thus behave similarly.

You need to call flush to actually execute the batch. If the specified batch size is reached, an implicit flush will happen; you still need to finally call flush to flush all statements.
Parameters:
  params - array of parameter objects the number of rows affected by the update (always -1,meaning "not applicable", as the statement is not actuallyexecuted by this method)
See Also:   BatchSqlUpdate.flush




Methods inherited from org.springframework.jdbc.object.SqlUpdate
protected void checkRowsAffected(int rowsAffected) throws JdbcUpdateAffectedIncorrectNumberOfRowsException(Code)(Java Doc)
public void setMaxRowsAffected(int maxRowsAffected)(Code)(Java Doc)
public void setRequiredRowsAffected(int requiredRowsAffected)(Code)(Java Doc)
public int update(Object[] params) throws DataAccessException(Code)(Java Doc)
public int update(Object[] params, KeyHolder generatedKeyHolder) throws DataAccessException(Code)(Java Doc)
public int update() throws DataAccessException(Code)(Java Doc)
public int update(int p1) throws DataAccessException(Code)(Java Doc)
public int update(int p1, int p2) throws DataAccessException(Code)(Java Doc)
public int update(long p1) throws DataAccessException(Code)(Java Doc)
public int update(long p1, long p2) throws DataAccessException(Code)(Java Doc)
public int update(String p) throws DataAccessException(Code)(Java Doc)
public int update(String p1, String p2) throws DataAccessException(Code)(Java Doc)
public int updateByNamedParam(Map paramMap) throws DataAccessException(Code)(Java Doc)
public int updateByNamedParam(Map paramMap, KeyHolder generatedKeyHolder) throws DataAccessException(Code)(Java Doc)

Methods inherited from org.springframework.jdbc.object.SqlOperation
final protected void compileInternal()(Code)(Java Doc)
protected ParsedSql getParsedSql()(Code)(Java Doc)
final protected PreparedStatementCreator newPreparedStatementCreator(Object[] params)(Code)(Java Doc)
final protected PreparedStatementCreator newPreparedStatementCreator(String sqlToUse, Object[] params)(Code)(Java Doc)
final protected PreparedStatementSetter newPreparedStatementSetter(Object[] params)(Code)(Java Doc)
protected void onCompileInternal()(Code)(Java Doc)

Fields inherited from org.springframework.jdbc.object.RdbmsOperation
final protected Log logger(Code)(Java Doc)

Methods inherited from org.springframework.jdbc.object.RdbmsOperation
public void afterPropertiesSet()(Code)(Java Doc)
protected boolean allowsUnusedParameters()(Code)(Java Doc)
protected void checkCompiled()(Code)(Java Doc)
final public void compile() throws InvalidDataAccessApiUsageException(Code)(Java Doc)
abstract protected void compileInternal() throws InvalidDataAccessApiUsageException(Code)(Java Doc)
public void declareParameter(SqlParameter param) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
protected List getDeclaredParameters()(Code)(Java Doc)
public String[] getGeneratedKeysColumnNames()(Code)(Java Doc)
public JdbcTemplate getJdbcTemplate()(Code)(Java Doc)
public int getResultSetType()(Code)(Java Doc)
public String getSql()(Code)(Java Doc)
public boolean isCompiled()(Code)(Java Doc)
public boolean isReturnGeneratedKeys()(Code)(Java Doc)
public boolean isUpdatableResults()(Code)(Java Doc)
public void setDataSource(DataSource dataSource)(Code)(Java Doc)
public void setFetchSize(int fetchSize)(Code)(Java Doc)
public void setGeneratedKeysColumnNames(String[] names)(Code)(Java Doc)
public void setJdbcTemplate(JdbcTemplate jdbcTemplate)(Code)(Java Doc)
public void setMaxRows(int maxRows)(Code)(Java Doc)
public void setParameters(SqlParameter[] parameters)(Code)(Java Doc)
public void setQueryTimeout(int queryTimeout)(Code)(Java Doc)
public void setResultSetType(int resultSetType)(Code)(Java Doc)
public void setReturnGeneratedKeys(boolean returnGeneratedKeys)(Code)(Java Doc)
public void setSql(String sql)(Code)(Java Doc)
public void setTypes(int[] types) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
public void setUpdatableResults(boolean updatableResults)(Code)(Java Doc)
protected boolean supportsLobParameters()(Code)(Java Doc)
protected void validateNamedParameters(Map parameters) throws InvalidDataAccessApiUsageException(Code)(Java Doc)
protected void validateParameters(Object[] parameters) throws InvalidDataAccessApiUsageException(Code)(Java Doc)

Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.