search cancel

Could not load driver - CA APM DB migration to Oracle

book

Article ID: 254257

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

We have migrated APM Database to Postgress to Oracle with the migration instructions and after migration the tess-db-cfg.xml is not updated automatically. We have updated the details manually but the Enterprise manager is not starting and throwing error "

-HelperThread-#1] [com.mchange.v2.c3p0.DriverManagerDataSource] Could not load driverClass org.Oracle.Driver
java.lang.ClassNotFoundException: org.Oracle.Driver".

Environment

Release : 10.7.0

Resolution

You have :

 <property name="hibernate.connection.driver_class">org.Oracle.Driver</property>

It should be 

<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>  

 

Overall:

<hibernate-configuration>
    <session-factory>
      <property name="em.dbtype">Oracle</property>
      <property name="hibernate.connection.username">apmdb</property>
      <property name="hibernate.connection.password">PLAIN_TEXT_PASSWORD</property>
      <property name="plainTextPasswords">true</property>
      <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
      <property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
      <property name="hibernate.connection.url">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DATABASE_HOSTNAME)(PORT=DATABASE_LISTENER_PORT))(CONNECT_DATA=(SERVICE_NAME=ORACLE_SERVICE_NAME)))</property>
      <property name="hibernate.connection.tcpKeepAlive">true</property>
    </session-factory>
</hibernate-configuration>