java.lang.Object
- fr.dyade.aaa.util.BaseTransaction
- - fr.dyade.aaa.util.AbstractTransaction
  - - fr.dyade.aaa.util.DBTransaction
    - - fr.dyade.aaa.ext.JDBCTransaction

All Implemented Interfaces:

JDBCTransactionMBean, DBTransactionMBean, Transaction, TransactionMBean
```
public class JDBCTransaction
extends DBTransaction
implements JDBCTransactionMBean
```

Nested Class Summary
- Nested classes/interfaces inherited from class fr.dyade.aaa.util.AbstractTransaction
  AbstractTransaction.Context

Field Summary

Fields
Modifier and Type	Field	Description
`private String`	`connurl`
`private String`	`dbinit`
`private String`	`dbname`
`static String`	`DFLT_JDBC_DB_PREFIX`
`private String`	`driver`
`private String`	`host`
`static String`	`JDBC_CONNECT_RETRY_COUNT_PROP`	This property is used to set the number of reconnection attempts after a failure, by default 5.
`static String`	`JDBC_CONNECT_RETRY_MAX_PERIOD_PROP`	This property is used to set the maximum time trying to reconnect after a failure, by default 60.000 (60 seconds).
`static String`	`JDBC_CONNECT_RETRY_MIN_DELAY_PROP`	This property is used to set the minimum time between two attempts to reconnect after a failure, by default 1.000 (1 seconds).
`static String`	`JDBC_DB_CLOSE_PROP`	This property is used to define the SQL statement executed at the end of the module, by default none.
`static String`	`JDBC_DB_DELETE_PROP`	This property allows to define the SQL statement allowing to delete an entry in the table used by the module, by default: "DELETE FROM <table> WHERE name=?"
`static String`	`JDBC_DB_HOST_PROP`	This property allows to define the hostname of the URL used to establish the connection.
`static String`	`JDBC_DB_INIT_PROP`	This property allows to define the SQL statement allowing to create the table used by the module, for example: "CREATE TABLE JoramDB (name VARCHAR(256), content LONG VARCHAR FOR BIT DATA, PRIMARY KEY(name))" This property can be set only at first launching.
`static String`	`JDBC_DB_INSERT_PROP`	This property allows to define the SQL statement allowing to insert an entry in the table used by the module, by default: "INSERT INTO <table> VALUES (?
`static String`	`JDBC_DB_LOAD_PROP`	This property allows to define the SQL statement allowing to load an entry from the table used by the module, by default: "SELECT content FROM <table> WHERE name=?"
`static String`	`JDBC_DB_NAME_PROP`	This property allows to define the database name of the URL used to establish the connection, by default "JoramDB".
`static String`	`JDBC_DB_PASS_PROP`	This property allows to define the password of database user on whose behalf the connection is being made.
`static String`	`JDBC_DB_PORT_PROP`	This property allows to define the port of the URL used to establish the connection.
`static String`	`JDBC_DB_PROTOCOL_PROP`	This property allows to define the protocol part of the URL used to establish the connection, for example "jdbc:mysql".
`static String`	`JDBC_DB_UPDATE_PROP`	This property allows to define the SQL statement allowing to update an entry in the table used by the module, by default: "UPDATE <table> SET content=?
`static String`	`JDBC_DB_USER_PROP`	This property allows to define the name of database user on whose behalf the connection is being made.
`static String`	`JDBC_DRIVER_PROP`	This property allows to define the class that implements the JDBC driver, for example "com.mysql.jdbc.Driver".
`static String`	`JDBC_PROPS_FILE_PROP`	This property allows to define the name of a file containing a list of arbitrary string tag/value pairs as connection arguments; normally at least a "user" and "password" property should be included.
`static String`	`JDBC_TRANSACTION_PREFIX`
`static String`	`JDBC_URL_PROP`	This property allows to define the database url of the form "jdbc:subprotocol://host:port/dbname".
`private String`	`password`
`private String`	`path`
`private String`	`port`
`private Properties`	`props`
`private String`	`protocol`
`private String`	`user`

Fields inherited from class fr.dyade.aaa.util.DBTransaction
conn, connectRetryCount, connectRetryMaxPeriod, connectRetryMinDelay, DB_TRANSACTION_PREFIX, dbclose, dbdelete, dbinsert, dbload, dbtable, dbupdate, DFLT_TABLE_PREFIX, JDBC_CONNECT_RETRY_COUNT_DFLT, JDBC_CONNECT_RETRY_MAX_PERIOD_DFLT, JDBC_CONNECT_RETRY_MIN_DELAY_DFLT, TABLE_NAME_PROP

Fields inherited from class fr.dyade.aaa.util.AbstractTransaction
average, dir, logmon, MONITOR, OOS_STREAM_HEADER, PERIODS, perThreadContext, phase, startTime

Fields inherited from class fr.dyade.aaa.util.BaseTransaction
DEBUG

Fields inherited from interface fr.dyade.aaa.util.Transaction
BACKUP, COMMIT, FINALIZE, FREE, GARBAGE, INIT, Kb, Mb, PhaseInfo, ROLLBACK, RUN

Constructor Summary

Constructors
Constructor Description

JDBCTransaction()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected void`	`connectDB()`	This method try to reconnect to the database, it is used in case of failure during commit.
`protected void`	`dumpProperties(StringBuilder strbuf)`
`Properties`	`getClientInfo()`
`String`	`getDBInitStatement()`
`String`	`getDBName()`
`String`	`getDriver()`
`String`	`getPropertiesPath()`
`String`	`getURL()`
`String`	`getUser()`
`protected void`	`initDB()`	Instantiates the database driver and creates the table if necessary

Methods inherited from class fr.dyade.aaa.util.DBTransaction
backup, close, commit, delete, dumpProperties, getBadInserts, getBadUpdates, getCommitBytes, getCommitCount, getDBCloseStatement, getDBDeleteStatement, getDBInsertStatement, getDBLoadStatement, getDBTableName, getDBUpdateStatement, getFromLog, getList, getLogThresholdOperation, getNbDeletes, getNbInserts, getNbUpdates, getPersistenceDir, initRepository, loadAll, loadByteArray, saveInLog, setPhase, stop, useLoadAll

Methods inherited from class fr.dyade.aaa.util.AbstractTransaction
begin, containsOperations, create, create, createByteArray, createByteArray, delete, getAverageCommitTime, getOperationCount, getPhase, getPhaseInfo, getStartTime, init, isPersistent, load, load, loadByteArray, loadFromByteArray, release, save, save, save, saveByteArray, saveByteArray, saveByteArray

Methods inherited from class fr.dyade.aaa.util.BaseTransaction
dumpObjectList, freeze, getBoolean, getInteger, getInteger, getObject, getObjectList, getProperty, getProperty, loadProperties, saveProperties

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface fr.dyade.aaa.util.DBTransactionMBean
dumpProperties, getAverageCommitTime, getBadInserts, getBadUpdates, getCommitBytes, getDBCloseStatement, getDBDeleteStatement, getDBInsertStatement, getDBLoadStatement, getDBTableName, getDBUpdateStatement, getLogThresholdOperation, getNbDeletes, getNbInserts, getNbUpdates, getPhase, getPhaseInfo

Methods inherited from interface fr.dyade.aaa.util.TransactionMBean
backup, dumpObjectList, getCommitCount, getObject, getObjectList, getStartTime, isPersistent, useLoadAll

- Field Detail
  - JDBC_TRANSACTION_PREFIX
```
public static final String JDBC_TRANSACTION_PREFIX
```
    See Also:
    
    Constant Field Values
  - JDBC_DRIVER_PROP
```
public static final String JDBC_DRIVER_PROP
```
    This property allows to define the class that implements the JDBC driver, for example "com.mysql.jdbc.Driver". This class needs to be in the classpath of the server.
    
    See Also:
    
    Constant Field Values
  - JDBC_URL_PROP
```
public static final String JDBC_URL_PROP
```
    This property allows to define the database url of the form "jdbc:subprotocol://host:port/dbname". If this property is defined, the properties "protocol", "host", "port" and "dbname" below are ignored.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_PROTOCOL_PROP
```
public static final String JDBC_DB_PROTOCOL_PROP
```
    This property allows to define the protocol part of the URL used to establish the connection, for example "jdbc:mysql". It is ignored if the url property is defined.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_HOST_PROP
```
public static final String JDBC_DB_HOST_PROP
```
    This property allows to define the hostname of the URL used to establish the connection. It is ignored if the url property is defined.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_PORT_PROP
```
public static final String JDBC_DB_PORT_PROP
```
    This property allows to define the port of the URL used to establish the connection. It is ignored if the url property is defined.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_NAME_PROP
```
public static final String JDBC_DB_NAME_PROP
```
    This property allows to define the database name of the URL used to establish the connection, by default "JoramDB". It is ignored if the url property is defined.
    
    See Also:
    
    Constant Field Values
  - DFLT_JDBC_DB_PREFIX
```
public static final String DFLT_JDBC_DB_PREFIX
```
    See Also:
    
    Constant Field Values
  - JDBC_PROPS_FILE_PROP
```
public static final String JDBC_PROPS_FILE_PROP
```
    This property allows to define the name of a file containing a list of arbitrary string tag/value pairs as connection arguments; normally at least a "user" and "password" property should be included.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_USER_PROP
```
public static final String JDBC_DB_USER_PROP
```
    This property allows to define the name of database user on whose behalf the connection is being made. If this value is already set in properties it is ignored.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_PASS_PROP
```
public static final String JDBC_DB_PASS_PROP
```
    This property allows to define the password of database user on whose behalf the connection is being made. If this value is already set in properties it is ignored.
    
    See Also:
    
    Constant Field Values
  - JDBC_CONNECT_RETRY_COUNT_PROP
```
public static final String JDBC_CONNECT_RETRY_COUNT_PROP
```
    This property is used to set the number of reconnection attempts after a failure, by default 5.
    
    See Also:
    
    Constant Field Values
  - JDBC_CONNECT_RETRY_MIN_DELAY_PROP
```
public static final String JDBC_CONNECT_RETRY_MIN_DELAY_PROP
```
    This property is used to set the minimum time between two attempts to reconnect after a failure, by default 1.000 (1 seconds).
    
    See Also:
    
    Constant Field Values
  - JDBC_CONNECT_RETRY_MAX_PERIOD_PROP
```
public static final String JDBC_CONNECT_RETRY_MAX_PERIOD_PROP
```
    This property is used to set the maximum time trying to reconnect after a failure, by default 60.000 (60 seconds).
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_INIT_PROP
```
public static final String JDBC_DB_INIT_PROP
```
    This property allows to define the SQL statement allowing to create the table used by the module, for example: "CREATE TABLE JoramDB (name VARCHAR(256), content LONG VARCHAR FOR BIT DATA, PRIMARY KEY(name))" This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_INSERT_PROP
```
public static final String JDBC_DB_INSERT_PROP
```
    This property allows to define the SQL statement allowing to insert an entry in the table used by the module, by default: "INSERT INTO <table> VALUES (?, ?)" This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_UPDATE_PROP
```
public static final String JDBC_DB_UPDATE_PROP
```
    This property allows to define the SQL statement allowing to update an entry in the table used by the module, by default: "UPDATE <table> SET content=? WHERE name=?" This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_LOAD_PROP
```
public static final String JDBC_DB_LOAD_PROP
```
    This property allows to define the SQL statement allowing to load an entry from the table used by the module, by default: "SELECT content FROM <table> WHERE name=?" This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_DELETE_PROP
```
public static final String JDBC_DB_DELETE_PROP
```
    This property allows to define the SQL statement allowing to delete an entry in the table used by the module, by default: "DELETE FROM <table> WHERE name=?" This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - JDBC_DB_CLOSE_PROP
```
public static final String JDBC_DB_CLOSE_PROP
```
    This property is used to define the SQL statement executed at the end of the module, by default none. This property can be set only at first launching.
    
    See Also:
    
    Constant Field Values
  - driver
```
private String driver
```
  - connurl
```
private String connurl
```
  - protocol
```
private String protocol
```
  - host
```
private String host
```
  - port
```
private String port
```
  - user
```
private String user
```
  - password
```
private String password
```
  - dbname
```
private String dbname
```
  - dbinit
```
private String dbinit
```
  - path
```
private String path
```
  - props
```
private Properties props
```
- Constructor Detail
  - JDBCTransaction
```
public JDBCTransaction()
```
- Method Detail
  - getDBName
```
public String getDBName()
```
    Specified by:
    
    getDBName in interface JDBCTransactionMBean
  - getDBInitStatement
```
public String getDBInitStatement()
```
    Specified by:
    
    getDBInitStatement in interface JDBCTransactionMBean
  - initDB
```
protected void initDB()
               throws IOException
```
    Description copied from class: DBTransaction
    
    Instantiates the database driver and creates the table if necessary
    
    Specified by:
    
    initDB in class DBTransaction
    
    Throws:
    
    IOException - an error occurs.
  - connectDB
```
protected void connectDB()
                  throws IOException
```
    Description copied from class: DBTransaction
    
    This method try to reconnect to the database, it is used in case of failure during commit. Be careful, unless a connection pool is used, we need to recreate the prepared statement.
    
    Specified by:
    
    connectDB in class DBTransaction
    
    Throws:
    
    IOException - The reconnection has failed.
  - getDriver
```
public String getDriver()
```
    Specified by:
    
    getDriver in interface JDBCTransactionMBean
  - getURL
```
public String getURL()
```
    Specified by:
    
    getURL in interface JDBCTransactionMBean
  - getClientInfo
```
public Properties getClientInfo()
```
    Specified by:
    
    getClientInfo in interface JDBCTransactionMBean
  - getUser
```
public String getUser()
```
    Specified by:
    
    getUser in interface JDBCTransactionMBean
  - getPropertiesPath
```
public String getPropertiesPath()
```
    Specified by:
    
    getPropertiesPath in interface JDBCTransactionMBean
  - dumpProperties
```
protected void dumpProperties(StringBuilder strbuf)
```
    Overrides:
    
    dumpProperties in class DBTransaction

Class JDBCTransaction

Nested Class Summary

Nested classes/interfaces inherited from class fr.dyade.aaa.util.AbstractTransaction

Field Summary

Fields inherited from class fr.dyade.aaa.util.DBTransaction

Fields inherited from class fr.dyade.aaa.util.AbstractTransaction

Fields inherited from class fr.dyade.aaa.util.BaseTransaction

Fields inherited from interface fr.dyade.aaa.util.Transaction

Constructor Summary

Method Summary

Methods inherited from class fr.dyade.aaa.util.DBTransaction

Methods inherited from class fr.dyade.aaa.util.AbstractTransaction

Methods inherited from class fr.dyade.aaa.util.BaseTransaction

Methods inherited from class java.lang.Object

Methods inherited from interface fr.dyade.aaa.util.DBTransactionMBean

Methods inherited from interface fr.dyade.aaa.util.TransactionMBean

Field Detail

JDBC_TRANSACTION_PREFIX

JDBC_DRIVER_PROP

JDBC_URL_PROP

JDBC_DB_PROTOCOL_PROP

JDBC_DB_HOST_PROP

JDBC_DB_PORT_PROP

JDBC_DB_NAME_PROP

DFLT_JDBC_DB_PREFIX

JDBC_PROPS_FILE_PROP

JDBC_DB_USER_PROP

JDBC_DB_PASS_PROP

JDBC_CONNECT_RETRY_COUNT_PROP

JDBC_CONNECT_RETRY_MIN_DELAY_PROP

JDBC_CONNECT_RETRY_MAX_PERIOD_PROP

JDBC_DB_INIT_PROP

JDBC_DB_INSERT_PROP

JDBC_DB_UPDATE_PROP

JDBC_DB_LOAD_PROP

JDBC_DB_DELETE_PROP

JDBC_DB_CLOSE_PROP

driver

connurl

protocol

host

port

user

password

dbname

dbinit

path

props

Constructor Detail

JDBCTransaction

Method Detail

getDBName

getDBInitStatement

initDB

connectDB

getDriver

getURL

getClientInfo

getUser

getPropertiesPath

dumpProperties