Package org.apache.log.output.db

Class 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 HashMap	m_categoryIDs
private HashMap	m_priorityIDs

Constructor Summary

Constructors

Constructor	Description
NormalizedJDBCTarget(DataSource dataSource, String table, ColumnInfo[] columns)

Method Summary

Modifier and Type	Method	Description
protected int	getID(String tableName, HashMap idMap, String instance)
protected void	specifyColumn(PreparedStatement statement, int index, LogEvent event)	Adds a single object into statement.

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

closeConnection, getColumn, getStatementSQL, getTable, isStale, openConnection, output

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 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

m_categoryIDs

private HashMap m_categoryIDs

m_priorityIDs

private HashMap m_priorityIDs

Constructor Details

NormalizedJDBCTarget

public NormalizedJDBCTarget(DataSource dataSource,
 String table,
 ColumnInfo[] columns)

Method Details

specifyColumn

protected void specifyColumn(PreparedStatement statement,
 int index,
 LogEvent event)
                      throws 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:

SQLException - if an SQL related error occurs

getID

protected int getID(String tableName,
 HashMap idMap,
 String instance)
             throws SQLException

Throws:

SQLException