NormalizedJDBCTarget

java.lang.Object
- org.apache.log.output.AbstractTarget
- - org.apache.log.output.db.AbstractJDBCTarget
  - - org.apache.log.output.db.DefaultJDBCTarget
    - - org.apache.log.output.db.NormalizedJDBCTarget

All Implemented Interfaces:

ErrorAware, LogTarget, Closeable
```
public class NormalizedJDBCTarget
extends DefaultJDBCTarget
```
JDBC target that writes to normalized tables. This reduces overhead and cost of querying/storing logs.
Parts based on JDBC logger from prottomatter by Nate Sammons

Author:

Peter Donald

Field Summary

Fields
Modifier and Type Field Description

private java.util.HashMap m_categoryIDs

private java.util.HashMap m_priorityIDs

Fields
Modifier and Type	Field	Description
`private java.util.HashMap`	`m_categoryIDs`
`private java.util.HashMap`	`m_priorityIDs`

Constructor Summary

Constructors
Constructor Description

NormalizedJDBCTarget(javax.sql.DataSource dataSource, java.lang.String table, ColumnInfo[] columns)

Constructors
Constructor	Description
`NormalizedJDBCTarget(javax.sql.DataSource dataSource, java.lang.String table, ColumnInfo[] columns)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected int`	`getID(java.lang.String tableName, java.util.HashMap idMap, java.lang.String instance)`
`protected void`	`specifyColumn(java.sql.PreparedStatement statement, int index, LogEvent event)`	Adds a single object into statement.

Methods inherited from class org.apache.log.output.db.AbstractJDBCTarget
checkConnection, close, doProcessEvent, getConnection, open

Methods inherited from class org.apache.log.output.AbstractTarget
getErrorHandler, isOpen, processEvent, setErrorHandler

Methods inherited from class org.apache.log.output.db.DefaultJDBCTarget
closeConnection, getColumn, getStatementSQL, getTable, isStale, openConnection, output

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

Field Detail

m_categoryIDs

private java.util.HashMap m_categoryIDs

m_priorityIDs

private java.util.HashMap m_priorityIDs

Constructor Detail

NormalizedJDBCTarget

public NormalizedJDBCTarget(javax.sql.DataSource dataSource,
                            java.lang.String table,
                            ColumnInfo[] columns)

Method Detail

specifyColumn

protected void specifyColumn(java.sql.PreparedStatement statement,
                             int index,
                             LogEvent event)
                      throws java.sql.SQLException

Adds a single object into statement.

Overrides:: specifyColumn in class DefaultJDBCTarget
Parameters:: statement - the prepard statement; index - the index; event - the log event
Throws:: java.sql.SQLException - if an SQL related error occurs

getID

protected int getID(java.lang.String tableName,
                    java.util.HashMap idMap,
                    java.lang.String instance)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

Class NormalizedJDBCTarget

Field Summary

Constructor Summary

Method Summary

Methods inherited from class org.apache.log.output.db.AbstractJDBCTarget

Methods inherited from class org.apache.log.output.AbstractTarget

Methods inherited from class org.apache.log.output.db.DefaultJDBCTarget

Methods inherited from class java.lang.Object

Field Detail

m_categoryIDs

m_priorityIDs

Constructor Detail

NormalizedJDBCTarget

Method Detail

specifyColumn

getID