Relational Database Logging

• Introduction
• Configuration

Introduction

In case of issues when using Orbeon Forms with a relational database, you might want to see what's happening between Orbeon Forms and said database. We have found that log4jdbc is a useful tool for troubleshooting this scenario.

Configuration

Download and install log4jdbc.

Then update your datasource configuration. For example, with Tomcat:

<Resource
    name="jdbc/oracle"
    auth="Container"
    type="javax.sql.DataSource"
    initialSize="3"
    maxActive="10"
    maxIdle="20"
    maxWait="30000"
    validationQuery="select * from dual"
    driverClassName="net.sf.log4jdbc.DriverSpy"
    poolPreparedStatements="true"
    username="orbeon"
    password="**password**"
    url="jdbc:log4jdbc:oracle:thin:@//localhost:1521/globaldb"/>

Note the driverClassName set to net.sf.log4jdbc.DriverSpy, and the url starting with jdbc:log4jdbc:, followed by the usual driver prefix, here oracle:.