2 * Copyright 2021 ZTE Corporation.
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
16 package org.onap.holmes.common.database;
18 import org.jdbi.v3.core.Jdbi;
19 import org.jdbi.v3.postgres.PostgresPlugin;
20 import org.jdbi.v3.sqlobject.SqlObjectPlugin;
21 import org.springframework.beans.factory.annotation.Value;
22 import org.springframework.context.annotation.Bean;
23 import org.springframework.context.annotation.Configuration;
24 import org.springframework.jdbc.datasource.DriverManagerDataSource;
26 import javax.sql.DataSource;
29 public class DatabaseConfiguration {
31 @Value("${spring.datasource.url}")
34 @Value("${spring.datasource.username}")
35 private String username;
37 @Value("${spring.datasource.password}")
40 @Value("${spring.datasource.dirver-class-name}")
41 private String driverClass;
44 public DataSource driverManagerDataSource() {
45 DriverManagerDataSource ds = new DriverManagerDataSource();
46 ds.setDriverClassName(driverClass);
48 ds.setUsername(username);
54 public Jdbi jdbi(DataSource dataSource) {
55 return Jdbi.create(dataSource)
56 .installPlugin(new SqlObjectPlugin())
57 .installPlugin(new PostgresPlugin());