Database Connectivity

Every Repertoire Server most likely needs to be configure to reterive data from a database. Below you can find some information pertaining to each database system.

Oracle Database

Question :

Does Elixir Repertoire support Oracle (OCI) Thick Client Driver ? And what is the necessary steps to do to work with OCI thick client ?

Answer :

See http://myjdbc.tripod.com/basic/jdbcoci.html


Question: I encounter the following errors when starting the Repertoire Server using Oracle Drivers?
ERROR :

2009-03-04 13:45:35,580,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.pool.OracleConnectionCacheManager$1: java.la
ng.NoClassDefFoundError: oracle/ons/ONSException
2009-03-04 13:45:35,589,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.pool.OracleFailoverEventHandlerThread$1: jav
a.lang.NoClassDefFoundError: oracle/ons/ONSException
2009-03-04 13:45:35,590,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.pool.OracleFailoverEventHandlerThread: java.
lang.NoClassDefFoundError: oracle/ons/ONSException
2009-03-04 13:45:35,594,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.pool.OracleRuntimeLoadBalancingEventHandlerT
hread$1: java.lang.NoClassDefFoundError: oracle/ons/ONSException
2009-03-04 13:45:35,595,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.pool.OracleRuntimeLoadBalancingEventHandlerT
hread: java.lang.NoClassDefFoundError: oracle/ons/ONSException
2009-03-04 13:45:35,773,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleConnectionManager: java.lang
.NoClassDefFoundError: javax/resource/spi/ConnectionManager
2009-03-04 13:45:35,775,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleConnectionRequestInfo: java.
lang.NoClassDefFoundError: javax/resource/spi/ConnectionRequestInfo
2009-03-04 13:45:35,777,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleLocalTransaction: java.lang.
NoClassDefFoundError: javax/resource/spi/LocalTransaction
2009-03-04 13:45:35,779,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleManagedConnection: java.lang
.NoClassDefFoundError: javax/resource/spi/ManagedConnection
2009-03-04 13:45:35,781,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleManagedConnectionMetaData: j
ava.lang.NoClassDefFoundError: javax/resource/spi/ManagedConnectionMetaData
2009-03-04 13:45:35,784,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleManagedConnectionFactory: ja
va.lang.NoClassDefFoundError: javax/resource/spi/ManagedConnectionFactory
2009-03-04 13:45:35,785,main,ERROR, ext.MethodTableModel - Can't load class oracle.jdbc.connector.OracleResourceAdapter: java.lang.N
oClassDefFoundError: javax/resource/spi/ResourceAdapter

Answer :

This exception occurs when the ons.jar available from oracle is not included in the /ext folder of the Repertoire Server. In most situations, this can be ignored. To resolve this, please download ons.jar from oracle and include this in the /ext folder of the Repertoire Server