Setting up Derby for the Interwoven Event SubSystem

10 January 2009
by Gavin Colborne

You are trying to setup Derby database for use with the Interwoven Event SubSystem.
You have followed the installation instructions manual
You get the following error in the eventsubd.log when starting the Event Subsytem:
“Cannot create PoolableConnectionFactory”.

Potential Solution
Check where the testdb database file has been created as the default in the Interwoven instructions creates the db file in your current working directory. Derby looks for the database by default in it derby/bin
Other possible problems:
1. Check the database exists by connecting to it and doing a “show tables” as per the Interwoven instructions
2. Check the driver exists and is in the correct location (/usr/iw-home/eventsubsystem/lib/derbyclient.jar – is “374965” in size for TS 6.7.1)
3. Check your configuration in “/usr/iw-home/eventsubsystem/conf/jmsconfignew.xml”
Should be as follows:
evictionInterval=”3600″ />
EVENTSUBD_HOME is set to /usr/iw-home/eventsubsystem
The OpenJMS Group. (C) 1999-2004. All rights reserved.
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:
java.sql.SQLException: The connection was refused because the database testdb was not found.
at Source)
at Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection

Caused by: The connection was refused because the database testdb was not found.

Our Latest News