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 java.io.Serializable;
44 import javax.persistence.Column;
45 import javax.persistence.Entity;
46 import javax.persistence.Id;
47 import javax.persistence.Table;
48 import javax.validation.constraints.NotNull;
49 import javax.validation.constraints.Size;
50 import lombok.AllArgsConstructor;
52 import lombok.NoArgsConstructor;
54 import org.hibernate.validator.constraints.SafeHtml;
57 CREATE TABLE `schema_info` (
58 `SCHEMA_ID` varchar(25) NOT NULL,
59 `SCHEMA_DESC` varchar(75) NOT NULL,
60 `DATASOURCE_TYPE` varchar(100) DEFAULT NULL,
61 `CONNECTION_URL` varchar(200) NOT NULL,
62 `USER_NAME` varchar(45) NOT NULL,
63 `PASSWORD` varchar(45) DEFAULT NULL,
64 `DRIVER_CLASS` varchar(100) NOT NULL,
65 `MIN_POOL_SIZE` int(11) NOT NULL,
66 `MAX_POOL_SIZE` int(11) NOT NULL,
67 `IDLE_CONNECTION_TEST_PERIOD` int(11) NOT NULL
71 @Table(name = "schema_info")
77 public class SchemaInfo implements Serializable {
79 @Column(name = "SCHEMA_ID", length = 25, nullable = false)
82 private String schemaId;
83 @Column(name = "SCHEMA_DESC", length = 75, nullable = false)
87 private String schemaDesc;
88 @Column(name = "DATASOURCE_TYPE", length = 100, columnDefinition = "varchar(100) DEFAULT NULL")
91 private String datasourceType;
92 @Column(name = "CONNECTION_URL", length = 200, nullable = false)
96 private String connectionUrl;
97 @Column(name = "USER_NAME", length = 45, nullable = false)
101 private String userName;
102 @Column(name = "PASSWORD", length = 45, columnDefinition = "varchar(45) default null")
105 private String password;
106 @Column(name = "DRIVER_CLASS", length = 100, nullable = false)
110 private String driverClass;
111 @Column(name = "MIN_POOL_SIZE", nullable = false)
113 private Long minPoolSize;
114 @Column(name = "MAX_POOL_SIZE", nullable = false)
116 private Long maxPoolSize;
117 @Column(name = "IDLE_CONNECTION_TEST_PERIOD", nullable = false)
119 private Long idleConnectionTestPeriod;