2 * ============LICENSE_START==========================================
4 * ===================================================================
5 * Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
6 * ===================================================================
7 * Modifications Copyright (c) 2019 Samsung
8 * ===================================================================
10 * Unless otherwise specified, all software contained herein is licensed
11 * under the Apache License, Version 2.0 (the "License");
12 * you may not use this software except in compliance with the License.
13 * You may obtain a copy of the License at
15 * http://www.apache.org/licenses/LICENSE-2.0
17 * Unless required by applicable law or agreed to in writing, software
18 * distributed under the License is distributed on an "AS IS" BASIS,
19 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
20 * See the License for the specific language governing permissions and
21 * limitations under the License.
23 * Unless otherwise specified, all documentation contained herein is licensed
24 * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
25 * you may not use this documentation except in compliance with the License.
26 * You may obtain a copy of the License at
28 * https://creativecommons.org/licenses/by/4.0/
30 * Unless required by applicable law or agreed to in writing, documentation
31 * distributed under the License is distributed on an "AS IS" BASIS,
32 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
33 * See the License for the specific language governing permissions and
34 * limitations under the License.
36 * ============LICENSE_END============================================
41 package org.onap.portal.domain.db;
43 import javax.persistence.Column;
44 import javax.persistence.Entity;
45 import javax.persistence.Id;
46 import javax.persistence.Table;
47 import javax.validation.constraints.NotNull;
48 import javax.validation.constraints.Size;
49 import lombok.AllArgsConstructor;
51 import lombok.NoArgsConstructor;
53 import org.hibernate.validator.constraints.SafeHtml;
56 CREATE TABLE `schema_info` (
57 `SCHEMA_ID` varchar(25) NOT NULL,
58 `SCHEMA_DESC` varchar(75) NOT NULL,
59 `DATASOURCE_TYPE` varchar(100) DEFAULT NULL,
60 `CONNECTION_URL` varchar(200) NOT NULL,
61 `USER_NAME` varchar(45) NOT NULL,
62 `PASSWORD` varchar(45) DEFAULT NULL,
63 `DRIVER_CLASS` varchar(100) NOT NULL,
64 `MIN_POOL_SIZE` int(11) NOT NULL,
65 `MAX_POOL_SIZE` int(11) NOT NULL,
66 `IDLE_CONNECTION_TEST_PERIOD` int(11) NOT NULL
70 @Table(name = "schema_info")
76 public class SchemaInfo {
78 @Column(name = "SCHEMA_ID", length = 25, nullable = false)
81 private String schemaId;
82 @Column(name = "SCHEMA_DESC", length = 75, nullable = false)
86 private String schemaDesc;
87 @Column(name = "DATASOURCE_TYPE", length = 100, columnDefinition = "varchar(100) DEFAULT NULL")
90 private String datasourceType;
91 @Column(name = "CONNECTION_URL", length = 200, nullable = false)
95 private String connectionUrl;
96 @Column(name = "USER_NAME", length = 45, nullable = false)
100 private String userName;
101 @Column(name = "PASSWORD", length = 45, columnDefinition = "varchar(45) default null")
104 private String password;
105 @Column(name = "DRIVER_CLASS", length = 100, nullable = false)
109 private String driverClass;
110 @Column(name = "MIN_POOL_SIZE", nullable = false)
112 private Long minPoolSize;
113 @Column(name = "MAX_POOL_SIZE", nullable = false)
115 private Long maxPoolSize;
116 @Column(name = "IDLE_CONNECTION_TEST_PERIOD", nullable = false)
118 private Long idleConnectionTestPeriod;