com.goldencode.p2j.persist.orm

Class SQLLoggingDatabaseHelper

java.lang.Object

com.goldencode.p2j.persist.orm.SQLLoggingDatabaseHelper

public class SQLLoggingDatabaseHelper
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connection Database connection
private static java.util.Map<java.lang.String,SQLLoggingDatabaseHelper>	dbHelpers Map that includes a helper for each given database.
private static CentralLogger	LOG Logger.

Constructor Summary

Constructors

Constructor and Description
SQLLoggingDatabaseHelper(java.lang.String filename, java.lang.String user, java.lang.String pass) Constructor to instantiate a helper

Method Summary

Modifier and Type	Method and Description
private void	closeConnection() Close the current connection.
static SQLLoggingDatabaseHelper	getDbHelper(java.lang.String databaseName, java.lang.String fileName, java.lang.String user, java.lang.String pass) Get the logging database helper of a specific database.
java.lang.Long	insertSQLQueryProfiling(java.lang.String databaseName, java.lang.String statement, java.lang.Double executionTime, int batchSize, java.lang.String stackTrace) Insert a SQL query profiling record.
private void	openConnection(java.lang.String url, java.lang.String user, java.lang.String pass) Open a new connection to the database (if one already opened, it will close it first).

Methods inherited from class java.lang.Object

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

Field Detail

LOG

private static final CentralLogger LOG

Logger.

dbHelpers

private static final java.util.Map<java.lang.String,SQLLoggingDatabaseHelper> dbHelpers

Map that includes a helper for each given database.

connection

private java.sql.Connection connection

Database connection

Constructor Detail

SQLLoggingDatabaseHelper

public SQLLoggingDatabaseHelper(java.lang.String filename,
                                java.lang.String user,
                                java.lang.String pass)

Constructor to instantiate a helper

Parameters:

filename - The filename of the h2 database to be created.

user - The user of the h2 database to be created.

pass - The password of the h2 database to be created.

Method Detail

getDbHelper

public static SQLLoggingDatabaseHelper getDbHelper(java.lang.String databaseName,
                                                   java.lang.String fileName,
                                                   java.lang.String user,
                                                   java.lang.String pass)

Get the logging database helper of a specific database.

Parameters:

databaseName - The name of the database in use.

fileName - The filename of the H2 database.

user - The user of the H2 database.

pass - The password of the H2 database.

Returns:

If it exists, an already created helper for that database, or a new one otherwise.

insertSQLQueryProfiling

public java.lang.Long insertSQLQueryProfiling(java.lang.String databaseName,
                                              java.lang.String statement,
                                              java.lang.Double executionTime,
                                              int batchSize,
                                              java.lang.String stackTrace)

Insert a SQL query profiling record.

Parameters:

databaseName - The FWD database on which profiling is done.

statement - The SQL statement that is profiled.

executionTime - The execution time of the profiled SQL Query.

batchSize - The batch size of the profiled SQL Query.

stackTrace - The stack trace of the profiled SQL Query.

Returns:

Primary key of the created record.

openConnection

private void openConnection(java.lang.String url,
                            java.lang.String user,
                            java.lang.String pass)

Open a new connection to the database (if one already opened, it will close it first).

Parameters:

url - The connection URL of the database.

user - The database user configured in directory.xml

pass - The database password configured in directory.xml

closeConnection

private void closeConnection()

Close the current connection.