<dependency>
			<groupId>com.oracle.jdbc</groupId>
			<artifactId>ojdbc5</artifactId>
			<version>11.1.0.7.0</version>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>weblogic-server</groupId>
			<artifactId>weblogic</artifactId>
			<version>8.1.4.0</version>
			<optional>true</optional>
		</dependency>

		
DROP TABLE BISKINLER.LOG CASCADE CONSTRAINTS;

CREATE TABLE BISKINLER.LOG
(
  LOG_ID      NUMBER(19) NOT NULL,
  LOG_DATE    TIMESTAMP(6),
  LOG_FILE    VARCHAR2(255 CHAR),
  LOG_METHOD  VARCHAR2(255 CHAR),
  LOG_TEXT    CLOB,
  LOG_TYPE    VARCHAR2(255 CHAR)
)

package com.biskinler.lo4j.appander;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import org.apache.log4j.jdbc.JDBCAppender;
import org.apache.log4j.spi.ErrorCode;

/**
 * Extension of the log4j {@link JDBCAppender} to allow using a JNDI data source
 * rather than a direct connection.
 * 
 * <p>
 * Example configuration:
 * 
 * log4j.appender.JNDI=com.biskinler.lo4j.appander.JndiCapableJdbcAppender
 * log4j.appender.JNDI.factoryInitial=weblogic.jndi.WLInitialContextFactory
 * log4j.appender.JNDI.jndiDataSource=dataSoruce
 * log4j.appender.JNDI.jndiProviderURL=t3://10.11.12.13:10000
 * 
 * @author Bart Bakker
 * @author Ahmet Faruk Bişkinler
 * @email ahmet @ biskinler.com
 */
public class JndiPoolAppender extends JDBCAppender {

	private static final Pattern SQL_VALUE_PATTERN = Pattern.compile( "'(.*?)'(?=\\s*[,)])", Pattern.MULTILINE);
	private String factoryInitial;
	private String jndiProviderURL;
	private String jndiDataSource;

	/** {@inheritDoc} */
	@Override
	protected Connection getConnection() throws SQLException {
		if (jndiDataSource == null) {
			return super.getConnection();
		} else {
			return lookupDataSource().getConnection();
		}
	}
	
	/**
	 * Looks up the datasource in the naming context specified by the
	 * {@link #jndiDataSource}.
	 * 
	 * @return the datasource.
	 */
	private DataSource lookupDataSource() {
		try {
			Hashtable<String, String> props = new Hashtable<String, String>();
			props.put("java.naming.factory.initial", factoryInitial);
			props.put("java.naming.provider.url", jndiProviderURL);
			Context ctx = new InitialContext(props);
			DataSource ds = (DataSource) ctx.lookup(jndiDataSource);
			
			return ds;
		} catch (NamingException e) {
			throw new RuntimeException("Cannot find JNDI DataSource: " + jndiDataSource, e);
		}
	}

	@Override
	protected void closeConnection(Connection con) {
		try {
			con.close();
		} catch (SQLException e) {
			errorHandler.error("Failed to close connection", e, ErrorCode.CLOSE_FAILURE);
		}
	}

	/**
	 * Executes the specified SQL statement, by parsing its values and turning
	 * them into parameters, so that characters that must be escaped in a SQL
	 * statement are supported.
	 */
	@Override
	protected void execute(String sql) throws SQLException {
		String statement = sql;
		ArrayList<String> args = new ArrayList<String>();
		Matcher m = SQL_VALUE_PATTERN.matcher(sql);
		while (m.find()) {
			args.add(m.group(1));
			statement = statement.replace(m.group(), "?");
		}

		executeStatement(statement, args.toArray(new String[args.size()]));
	}

	/**
	 * Executes the statement settings its parameters to the specified
	 * arguments.
	 * 
	 * @param statement the statement to execute.
	 * @param args the parameter values.
	 */
	protected void executeStatement(String statement, String[] args)throws SQLException {
		Connection con = getConnection();
		PreparedStatement stmt = null;
		try {
			stmt = con.prepareStatement(statement);
			for (int i = 0; i < args.length; i++) {
				stmt.setString(i + 1, args[i]);
			}
			stmt.executeUpdate();
		} catch (SQLException e) {
			if (stmt != null) {
				stmt.close();
			}
			throw e;
		}
		stmt.close();
		closeConnection(con);
	}
	

	public String getFactoryInitial() {
		return factoryInitial;
	}

	public void setFactoryInitial(String factoryInitial) {
		this.factoryInitial = factoryInitial;
	}

	public String getJndiProviderURL() {
		return jndiProviderURL;
	}

	public void setJndiProviderURL(String jndiProviderURL) {
		this.jndiProviderURL = jndiProviderURL;
	}

	public String getJndiDataSource() {
		return jndiDataSource;
	}

	public void setJndiDataSource(String jndiDataSource) {
		this.jndiDataSource = jndiDataSource;
	}
	
}

# JNDI Appender Log Configuration
log4j.appender.JNDI=com.biskinler.testapp.log.JndiPoolAppender
log4j.appender.JNDI.Threshold=INFO
log4j.appender.JNDI.jndiProviderURL=t3://10.11.12.13:10000

#Weblogic
	#log4j.appender.JNDI.factoryInitial=weblogic.jndi.WLInitialContextFactory
	#log4j.appender.JNDI.jndiDataSource=testapp10g
#Tomcat
	log4j.appender.JNDI.factoryInitial=org.apache.naming.java.javaURLContextFactory
	log4j.appender.JNDI.jndiDataSource=java:comp/env/testapp10g

log4j.appender.JNDI.layout=org.apache.log4j.PatternLayout
log4j.appender.JNDI.layout.ConversionPattern=insert into log (LOG_DATE, LOG_TYPE, LOG_FILE, LOG_METHOD, LOG_TEXT) values (sysdate, '%p', '%F', '%l', '%m')