Failed to Instantiate Database Driver Error

Reported for version 10

Problem

The following error is thrown after defining a new database connection:

Error code

13.05.2015 12:05:17 [FATAL]    java.lang.IllegalStateException: Failed to instantiate database driver 'oracle.jdbc.OracleDriver'
java.lang.IllegalStateException: Failed to instantiate database driver 'oracle.jdbc.OracleDriver'
        at com.ataccama.dqc.commons.sql.util.SimpleDataSource.<init>(SimpleDataSource.java:64)
        at com.ataccama.dqc.commons.sql.util.PoolingDataSource.<init>(PoolingDataSource.java:49)
        at com.ataccama.dqc.commons.sql.PooledDatabaseSupport.registerDS(PooledDatabaseSupport.java:156)
        at com.ataccama.dqc.server.runtime.ServerRuntimeImpl.initDatabaseSupport(ServerRuntimeImpl.java:287)
        at com.ataccama.dqc.server.runtime.ServerRuntimeImpl.startServer(ServerRuntimeImpl.java:161)
        at com.ataccama.dqc.server.runtime.ServerRuntimeImpl.startServer(ServerRuntimeImpl.java:115)
        at com.ataccama.dqc.server.bin.OnlineCtl.startServer(OnlineCtl.java:259)
        at com.ataccama.dqc.server.bin.OnlineCtl.run(OnlineCtl.java:133)
        at com.ataccama.dqc.server.bin.OnlineCtl.main(OnlineCtl.java:99)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.ataccama.dqc.bootstrap.DqcBootstrap.run(DqcBootstrap.java:127)
        at com.ataccama.dqc.bootstrap.DqcBootstrap.execute(DqcBootstrap.java:71)
        at com.ataccama.dqc.bootstrap.DqcBootstrap.main(DqcBootstrap.java:57)

Solution

This error occurs when you have a database connection defined in your runtime configuration file (by default, default.runtimeConfig), but the appropriate JDBC driver has not been placed into the runtime/lib folder of the DQC runtime.

Database Connection in Runtime Configuration

<runtimeconfig>
	...
    <dataSources>
		<dataSource 
			driverclass="oracle.jdbc.OracleDriver" 
			name="TransactionLog" 
			user="username" 
			password="password" 
			url="jdbc:oracle:thin:@localhost:1521:test1"
		/>
	</dataSources>
	...
</runtimeconfig>

Resolve this problem by installing the appropriate JDBC driver: copy its .jar file (located at [PRODUCT INSTALLATION FOLDER]/runtime/lib/jdbc/[database type]) to [PRODUCT INSTALLATION FOLDER]/runtime/lib .

Problem

Solution

Related articles