com.ziclix.python.sql.handler

Class UpdateCountDataHandler

java.lang.Object

com.ziclix.python.sql.DataHandler

com.ziclix.python.sql.FilterDataHandler

com.ziclix.python.sql.handler.UpdateCountDataHandler

public class UpdateCountDataHandler
extends FilterDataHandler

A data handler that keeps track of the update count for each execution of a Statement.

Note: MySql does not return the correct count for a delete statement that has no where clause. Therefore, to assure the correct update count is returned, either include a where clause, or understand that the value will always be 0.

See Also:

Statement.getUpdateCount()

Field Summary

Fields

Modifier and Type	Field and Description
int	updateCount The update count for the last executed statement.

Constructor Summary

Constructors

Constructor and Description
UpdateCountDataHandler(DataHandler datahandler) Handle capturing the update count.

Method Summary

Modifier and Type	Method and Description
void	postExecute(java.sql.Statement stmt) Gets the update count from the statement after successfully executing.
void	preExecute(java.sql.Statement stmt) Sets the update count to -1 prior to the statement being executed.

Methods inherited from class com.ziclix.python.sql.FilterDataHandler

__chain__, getPyObject, getRowId, setJDBCObject, setJDBCObject

Methods inherited from class com.ziclix.python.sql.DataHandler

checkNull, getMetaDataName, getProcedure, getPyObject, getSystemDataHandler, read, read, registerOut, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

updateCount

public int updateCount

The update count for the last executed statement.

Constructor Detail

UpdateCountDataHandler

public UpdateCountDataHandler(DataHandler datahandler)

Handle capturing the update count. The initial value of the updateCount is -1.

Method Detail

preExecute

public void preExecute(java.sql.Statement stmt)
                throws java.sql.SQLException

Sets the update count to -1 prior to the statement being executed.

Overrides:

preExecute in class FilterDataHandler

Throws:

java.sql.SQLException

postExecute

public void postExecute(java.sql.Statement stmt)
                 throws java.sql.SQLException

Gets the update count from the statement after successfully executing.

Overrides:

postExecute in class FilterDataHandler

Throws:

java.sql.SQLException