org.apache.avalon.excalibur.datasource.InformixDataSource Maven / Gradle / Ivy
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
* implied.
*
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.avalon.excalibur.datasource;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import javax.sql.ConnectionPoolDataSource;
import org.apache.avalon.framework.configuration.Configuration;
import org.apache.avalon.framework.configuration.ConfigurationException;
import org.apache.avalon.framework.logger.AbstractLogEnabled;
/**
* The Informix implementation for DataSources in Excalibur. This uses the
* com.informix.jdbcx.IfxConnectionPoolDataSource object. It uses
* the following format for configuration (italics mark information you change):
*
*
* <informix>
* <pool-controller init="5" min="5" max="10"/>
* <dbname>dbname</dbname>
* <servername>servername</servername>
* <host port="2000">host</host>
* <user>user</user>
* <password>password</password>
* <tracing>
* <jdbc> file="filename" level="level"</jdbc>
* <sqli> file="filename" level="level"</sqli>
* </tracing>
* <informix>
*
*
*
* Informix doesn't like the JdbcDataSource Component, so we gave it it's own.
* Do not use this datasource if you are planning on using your J2EE server's
* connection pooling.
*
*
*
* You must have Informix's JDBC 2.2 or higher jar file, as well as the
* extensions jar file (ifxjdbc.jar and ifxjdbcx.jar).
* Also, this DataSource requires the Avalon Cadastre package because it uses
* the MemoryContext.
*
*
*
* The tracing settings optionally enable Informix's tracing support
* within the jdbc driver. Note, for this to work, the
* ifxjdbc-g.jar and ifxjdbcx-g.jar jar files are
* required (the options have no effect when using the non -g jar files).
*
*
*
* jdbc tracing enables general logging information about the driver
* itself. sqli tracing enables logging of native sqli messages sent
* between the jdbc driver and the database server.
*
*
*
* The attribute file specifies where to write tracing information
* to, and level specifies the tracing level to be used, as
* documented in the Informix JDBC programmers guide.
*
*
* @avalon.component
* @avalon.service type=DataSourceComponent
* @x-avalon.info name=informix
* @x-avalon.lifestyle type=singleton
*
* @author Avalon Development Team
* @version CVS $Revision: 1.4 $ $Date: 2004/02/28 11:47:14 $
* @since 4.0
*/
public class InformixDataSource
extends AbstractLogEnabled
implements DataSourceComponent
{
private DataSource m_dataSource;
private boolean m_autocommit;
private static boolean INIT_FACTORY = false;
/**
* Set up the system property for the context factory if it hasn't been
* done already. This is not done in a static initializer due to the
* existence of the J2eeDataSource.
*/
public InformixDataSource()
{
if( !InformixDataSource.INIT_FACTORY )
{
System.setProperty( Context.INITIAL_CONTEXT_FACTORY,
"org.codehaus.spice.jndikit.memory.MemoryInitialContextFactory" );
}
}
/**
* Return an Informix Connection object
*/
public Connection getConnection() throws SQLException
{
Connection conn = m_dataSource.getConnection();
if( conn.getAutoCommit() != m_autocommit )
{
conn.setAutoCommit( m_autocommit );
}
return conn;
}
/**
* Set up the Informix driver for direct use.
*/
public void configure( Configuration conf ) throws ConfigurationException
{
Configuration poolController = conf.getChild( "pool-controller" );
String dbname = conf.getChild( "dbname" ).getValue( "ifx" );
ConnectionPoolDataSource pooledDataSource = (ConnectionPoolDataSource) getInstance( "com.informix.jdbcx.IfxConnectionPoolDataSource" );
m_autocommit = conf.getChild( "autocommit" ).getValueAsBoolean( true );
setProperty(pooledDataSource, "IfxCPMInitPoolSize", new Integer(poolController.getAttributeAsInteger( "init", 5 ) ) );
setProperty(pooledDataSource, "IfxCPMMinPoolSize", new Integer(poolController.getAttributeAsInteger( "min", 5 ) ) );
setProperty(pooledDataSource, "IfxCPMMaxPoolSize", new Integer(poolController.getAttributeAsInteger( "max", 10 ) ) );
setProperty(pooledDataSource, "IfxCPMServiceInterval", new Long( 100 ) );
setProperty(pooledDataSource, "ServerName", conf.getChild( "servername" ).getValue() );
setProperty(pooledDataSource, "DatabaseName", conf.getChild( "dbname" ).getValue() );
setProperty(pooledDataSource, "IfxIFXHOST", conf.getChild( "host" ).getValue() );
setProperty(pooledDataSource, "PortNumber", new Integer( conf.getChild( "host" ).getAttributeAsInteger( "port" ) ) );
setProperty(pooledDataSource, "User", conf.getChild( "user" ).getValue() );
setProperty(pooledDataSource, "Password", conf.getChild( "password" ).getValue() );
try
{
Context context = new InitialContext();
context.bind( dbname + "pool", pooledDataSource );
m_dataSource = (DataSource) getInstance( "com.informix.jdbcx.IfxDataSource" );
setProperty(m_dataSource, "DataSourceName", dbname + "pool" );
setProperty(m_dataSource, "ServerName", conf.getChild( "servername" ).getValue() );
setProperty(m_dataSource, "DatabaseName", conf.getChild( "dbname" ).getValue() );
setProperty(m_dataSource, "IfxIFXHOST", conf.getChild( "host" ).getValue() );
setProperty(m_dataSource, "PortNumber", new Integer( conf.getChild( "host" ).getAttributeAsInteger( "port" ) ) );
setProperty(m_dataSource, "User", conf.getChild( "user" ).getValue() );
setProperty(m_dataSource, "Password", conf.getChild( "password" ).getValue() );
configureTracing( conf.getChild( "tracing", false ) );
context.bind( dbname, m_dataSource );
}
catch( Exception e )
{
if( getLogger().isErrorEnabled() )
{
getLogger().error( "There was an error trying to bind the connection pool", e );
}
throw new ConfigurationException( "There was an error trying to bind the connection pool", e );
}
}
/**
* Helper method to enable tracing support in the Informix driver.
*
* @param config a Configuration value
* @exception ConfigurationException if an error occurs
*/
private void configureTracing( final Configuration config )
throws ConfigurationException
{
if ( config != null )
{
Configuration child = config.getChild( "jdbc", false );
if (child != null)
{
// enables tracing on the jdbc driver itself
setProperty(m_dataSource, "IfxTRACE", new Integer( child.getAttributeAsInteger( "level" ) ) );
setProperty(m_dataSource, "IfxTRACEFILE", child.getAttribute( "file" ) );
}
child = config.getChild( "sqli", false );
if (child != null)
{
// enables sqli message tracing
setProperty(m_dataSource, "IfxPROTOCOLTRACE", new Integer( child.getAttributeAsInteger( "level" ) ) );
setProperty(m_dataSource, "IfxPROTOCOLTRACEFILE", child.getAttribute( "file" ) );
}
}
}
private Object getInstance(String className)
throws ConfigurationException
{
Object instance = null;
try
{
instance = Thread.currentThread().getContextClassLoader().loadClass(className).newInstance();
}
catch (Exception e)
{
throw new ConfigurationException("Could not load class", e);
}
return instance;
}
private void setProperty(Object obj, String propertyName, Object value)
throws ConfigurationException
{
Class valueClass = value.getClass();
if ( value instanceof Integer )
{
valueClass = Integer.TYPE;
}
else if ( value instanceof Long )
{
valueClass = Long.TYPE;
}
try
{
Method meth = obj.getClass().getMethod("set" + propertyName, new Class[]{valueClass});
meth.invoke(obj, new Object[]{value});
}
catch (Exception e)
{
throw new ConfigurationException("Could not set property", e);
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy