blob: f877bd2208492f9b7109bdb687f06a915ff45b86 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
/*-
* ============LICENSE_START=======================================================
* ONAP : APPC
* ================================================================================
* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
* ================================================================================
* Copyright (C) 2017 Amdocs
* =============================================================================
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* ECOMP is a trademark and service mark of AT&T Intellectual Property.
* ============LICENSE_END=========================================================
*/
package org.onap.appc.dao.util;
import org.onap.appc.dao.util.api.JdbcConnectionFactory;
import org.onap.appc.dao.util.exception.JdbcRuntimeException;
import org.onap.appc.dao.util.message.Messages;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* @deprecated As of release 1802, replaced by {@link #(org.onap.appc.dao.util.dbcp.DBConnectionPool)}
* <p>
* This class provides the ability to access mysql database which has been deprecated because
* {@link #openDbConnection()} for each database request is not a good practice especially
* on appc performance.
* <p>
* If you would like to use appcctl (mysql database), bundle:appc-data-access-lib has created
* a database connection pool bean and exported as a service by using blueprint.
* If you would like to create a new database connection pool, refer to the way mentioned above.
* {@link org.onap.appc.dao.util.api.DBConnectionPoolService} has an example of how to use
* the connection pool.
*/
@Deprecated
public abstract class DefaultJdbcConnectionFactory implements JdbcConnectionFactory {
private static boolean driverRegistered = false;
private String jdbcURL;
private String jdbcUserName;
private String jdbcPassword;
public void setJdbcURL(String jdbcURL) {
this.jdbcURL = jdbcURL;
}
public void setJdbcUserName(String jdbcUserName) {
this.jdbcUserName = jdbcUserName;
}
public void setJdbcPassword(String jdbcPassword) {
this.jdbcPassword = jdbcPassword;
}
protected abstract void registedDriver() throws SQLException;
@Override
public Connection openDbConnection() {
try {
if (!driverRegistered) {
registedDriver();
driverRegistered = true;
}
return DriverManager.getConnection(jdbcURL, jdbcUserName, jdbcPassword);
} catch (SQLException e) {
throw new JdbcRuntimeException(Messages.EXP_JDBC_CONNECT.format(jdbcURL), e);
}
}
@Override
public void closeDbConnection(Connection connection) {
try {
connection.close();
} catch (SQLException e) {
throw new JdbcRuntimeException(Messages.EXP_JDBC_DISCONNECT.format(jdbcURL), e);
}
}
}
|