Another needed dependency is the JDBC driver to the database of choice, e.g., h2, oracle, mssql, postgresql and database connection pool managing library:
@AutowiredprivateEnvironmentenv;privatestaticfinalLoggerlog=LoggerFactory.getLogger(TestConfiguration.class);@BeanpublicDialectRegistrygetDialectRegistry(){DialectRegistryregistry=newDialectRegistry();registry.setDialect(env.getProperty("higson.database.dialect"));returnregistry;}@BeanpublicDialectTemplategetDialectTemplate(DialectRegistrydialectRegistry){returndialectRegistry.create();}@Bean(destroyMethod="close")publicDataSourcegetDataSource(DialectTemplatedialectTemplate){BasicDataSourcedataSource=newBasicDataSource();dataSource.setUsername(env.getProperty("higson.database.username"));dataSource.setPassword(env.getProperty("higson.database.password"));dataSource.setUrl(env.getProperty("higson.database.url"));dataSource.setInitialSize(4);dataSource.setDriverClassName(dialectTemplate.getJdbcDriverClassName());returndataSource;}@Bean(destroyMethod="destroy")publicHigsonEngineFactorygetHigsonEngineFactory(DataSourcedataSource){log.info("Engine factory begin creation...");HigsonEngineFactoryhigsonEngineFactory=newHigsonEngineFactory();higsonEngineFactory.setDataSource(dataSource);returnhigsonEngineFactory;}@BeanpublicHigsonEnginegetHigsonEngine(HigsonEngineFactoryhigsonEngineFactory){log.info("Engine begin creation...");returnhigsonEngineFactory.create();}
The application is ready to start. After successfully starting the application, you can see similar log output: