Skip to main content

Search

Welcome to Tibero GTS!

How to Integrate Tibero Using log4jdbc

Document Type | Technical Information

Category | Interface/Integration

Document Number | TIITI015

 

Overview

log4jdbc is a tool that allows logging of SQL execution details through JDBC.
Since Tibero does not natively support the driver class name in log4jdbc, you must specify the driver name directly using the log4jdbc.drivers option.
Note
The configuration examples in this document are based on the JEUS (Web Application Server) environment.
 
 
 
 

Method

Databases Supported by log4jdbc

The following database driver classes are supported by default in log4jdbc.
Driver Class
Database Type
oracle.jdbc.driver.OracleDriver
Older Oracle Driver
oracle.jdbc.OracleDriver
Newer Oracle Driver
com.sybase.jdbc2.jdbc.SybDriver
Sybase
net.sourceforge.jtds.jdbc.Driver
jTDS SQL Server & Sybase driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
Microsoft SQL Server 2000 driver
com.microsoft.sqlserver.jdbc.SQLServerDriver
Microsoft SQL Server 2005 driver
weblogic.jdbc.sqlserver.SQLServerDriver
Weblogic SQL Server driver
com.informix.jdbc.IfxDriver
Informix
org.apache.derby.jdbc.ClientDriver
Apache Derby client/server driver, aka the Java DB
org.apache.derby.jdbc.EmbeddedDriver
Apache Derby embedded driver, aka the Java DB
com.mysql.jdbc.Driver
MySQL
org.postgresql.Driver
PostgresSQL
org.hsqldb.jdbcDriver
HSQLDB pure Java database
org.h2.Driver
H2 pure Java database
Since Tibero is not included in the above list, you need to specify the driver as follows.
-Dlog4jdbc.drivers=com.tmax.tibero.jdbc.TbDriver
-Dlog4jdbc.auto.load.popular.drivers=false
  • log4jdbc.drivers: Specifies the Tibero JDBC driver
  • log4jdbc.auto.load.popular.drivers: Disables loading of default JDBC classes (optional)

 

JEUS Environment Configuration Example

engine-container Configuration

<engine-container>
    <name>container1</name>
    <command-option>-Xms256m -Xmx512m -XX:MaxPermSize=128m -Xss256k
Djava.awt.headless=true -Djeus.jdbc.sql.log.level=FINE
    -verbose:gc -Xloggc:/logs/jeus6008/gc/con1.gc
    -XX:+PrintGCDetails
    -XX:+PrintGCTimeStamps -XX:+PrintHeapAtGC
    -Dlog4jdbc.drivers=com.tmax.tibero.jdbc.TbDriver
    </command-option>

 

URL and DriverClassName Configuration Example (JEUSMain.xml)

<database>
    <vendor>others</vendor>
    <export-name>datasource</export-name>
    <data-source-class-name>
        jeus.jdbc.driver.blackbox.BlackboxConnectionPoolDataSource
    </data-source-class-name>
    <data-source-type>ConnectionPoolDataSource</data-source-type>
    <user>tibero</user>
    <password>tmax</password>

    <property>
        <name>URL</name>
        <type>java.lang.String</type>
        <value>jdbc:log4jdbc:tibero:thin:@127.0.0.1:8629:tibero</value>
    </property>

    <property>
        <name>DriverClassName</name>
        <type>java.lang.String</type>
        <value>net.sf.log4jdbc.DriverSpy</value>
    </property>

    <connection-pool>
        <pooling>
            <min>10</min>
            <max>40</max>
            <step>5</step>
            <period>300000</period>
        </pooling>
        <wait-free-connection>
            <enable-wait>true</enable-wait>
            <wait-time>10000</wait-time>
        </wait-free-connection>
        <check-query>SELECT 1 FROM dual</check-query>
        <check-query-period>300000</check-query-period>
    </connection-pool>
</database>

 

 

 

 

Related to