View Javadoc
1   package fr.ifremer.quadrige3.core.dao.technical;
2   
3   /*-
4    * #%L
5    * Quadrige3 Core :: Client API
6    * %%
7    * Copyright (C) 2017 Ifremer
8    * %%
9    * This program is free software: you can redistribute it and/or modify
10   * it under the terms of the GNU Affero General Public License as published by
11   * the Free Software Foundation, either version 3 of the License, or
12   * (at your option) any later version.
13   * 
14   * This program is distributed in the hope that it will be useful,
15   * but WITHOUT ANY WARRANTY; without even the implied warranty of
16   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17   * GNU General Public License for more details.
18   * 
19   * You should have received a copy of the GNU Affero General Public License
20   * along with this program.  If not, see <http://www.gnu.org/licenses/>.
21   * #L%
22   */
23  
24  import org.apache.commons.dbcp2.BasicDataSource;
25  import org.apache.commons.lang3.StringUtils;
26  
27  import java.sql.Connection;
28  import java.sql.SQLException;
29  
30  public class TimezoneEnabledDataSource extends BasicDataSource {
31  
32      private String timezone;
33  
34      public String getTimezone() {
35          return timezone;
36      }
37  
38      public void setTimezone(String timezone) {
39          this.timezone = timezone;
40      }
41  
42      @Override
43      public Connection getConnection() throws SQLException {
44          Connection c = super.getConnection();
45  
46          if (Daos.isHsqlDatabase(c.getMetaData().getURL()) && StringUtils.isNotBlank(timezone)) {
47              Daos.setTimezone(c, timezone);
48          }
49          return c;
50      }
51  
52  }