Datahub Server Start Error : Datasource connection

[shrikant_nikam]

Have default Datasource configurations defined: As below URL

https://help.sap.com/viewer/c65fa30c12ec4c2dbe04becf73f0943d/2005/en-US/601c8ce1420641d7acc1da5df7d1...

Exception Trace :

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/hybris/datahub/persistence/jpa/config/DataSourceConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: java.lang.NoClassDefFoundError: Could not initialize class org.hsqldb.lib.FileUtil

Exact Issue: DH build is successful, server starting error.

Datahub Version: 20.11.13

SAP Commerce Version : 2011.15

[Slava]

I suspect it's a conflict of the hsqldb driver version. Have you placed the db driver onto the class path? DH is distributed with the driver, which indeed does not contain org.hsqldb.lib.FileUtil. So, it looks like at runtime it's a different version. Do you have custom classes with compile dependency on the hsqldb driver jar?

Also, make sure you use correct classes in the configuration. For example, these are the properties we test hsqldb with:

#dataSource.className=org.hsqldb.jdbc.JDBCDataSource
#dataSource.jdbcUrl="jdbc:hsqldb:mem:datahub;hsqldb.tx=mvcc"

The problem must be somewhere in the project setup or in the deployed libraries/configuration. It's hard to say more specifically without seeing your project/deployment.