Relational database logging

Last updated last month

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 and Oracle:

<Resource
name="jdbc/oracle"
driverClassName="net.sf.log4jdbc.DriverSpy"
auth="Container"
type="javax.sql.DataSource"
initialSize="3"
maxActive="10"
maxIdle="10"
maxWait="30000"
poolPreparedStatements="true"
testOnBorrow="true"
validationQuery="select * from dual"
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:.

See also