1 /*
2 * This file is part of Waarp Project (named also Waarp or GG).
3 *
4 * Copyright (c) 2019, Waarp SAS, and individual contributors by the @author
5 * tags. See the COPYRIGHT.txt in the distribution for a full listing of
6 * individual contributors.
7 *
8 * All Waarp Project is free software: you can redistribute it and/or
9 * modify it under the terms of the GNU General Public License as published by
10 * the Free Software Foundation, either version 3 of the License, or (at your
11 * option) any later version.
12 *
13 * Waarp is distributed in the hope that it will be useful, but WITHOUT ANY
14 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 * A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License along with
18 * Waarp . If not, see <http://www.gnu.org/licenses/>.
19 */
20 package org.waarp.common.database;
21
22 import org.waarp.common.database.model.DbType;
23 import org.waarp.common.logging.WaarpLogger;
24 import org.waarp.common.logging.WaarpLoggerFactory;
25
26 import java.sql.SQLException;
27
28 /**
29 * Constants value for database
30 */
31 public class DbConstant {
32 /**
33 * Internal Logger
34 */
35 private static final WaarpLogger logger =
36 WaarpLoggerFactory.getLogger(DbConstant.class);
37 /**
38 * Illegal value as SpecialId of transfer (any value above is valid)
39 */
40 public static final long ILLEGALVALUE = Long.MIN_VALUE;
41 /**
42 * The current DbAdmin object
43 */
44 public static DbAdmin admin;
45 /**
46 * The no-commit DbAdmin object
47 */
48 public static DbAdmin noCommitAdmin;
49 /**
50 * How long to wait in second for a validation of connection (isValid(time))
51 */
52 public static final int VALIDTESTDURATION = 2;
53 /**
54 * Number of Database max connection (if pooled)
55 */
56 public static final int MAXCONNECTION = 5000;
57 /**
58 * Delay in second to try to connect
59 */
60 public static final int DELAYMAXCONNECTION = 30;
61
62 /**
63 * Print the error from SQLException
64 *
65 * @param ex
66 */
67 public static void error(final SQLException ex) {
68 // handle any errors
69 logger.error(
70 "SQLException: " + ex.getMessage() + " SQLState: " + ex.getSQLState() +
71 " VendorError: " + ex.getErrorCode());
72 }
73
74 /**
75 * @return True if Db is used
76 */
77 public static boolean isDbUsed() {
78 return admin != null && admin.getTypeDriver() != null &&
79 admin.getTypeDriver() != DbType.none;
80 }
81 }