root / trunk / org.gvsig.postgresql / org.gvsig.postgresql.provider / src / main / java / org / gvsig / fmap / dal / store / postgresql / PostgreSQLResource.java @ 5
History | View | Annotate | Download (3.24 KB)
1 | 5 | jldominguez | /* gvSIG. Geographic Information System of the Valencian Government
|
---|---|---|---|
2 | *
|
||
3 | * Copyright (C) 2007-2008 Infrastructures and Transports Department
|
||
4 | * of the Valencian Government (CIT)
|
||
5 | *
|
||
6 | * This program is free software; you can redistribute it and/or
|
||
7 | * modify it under the terms of the GNU General Public License
|
||
8 | * as published by the Free Software Foundation; either version 2
|
||
9 | * of the License, or (at your option) any later version.
|
||
10 | *
|
||
11 | * This program is distributed in the hope that it will be useful,
|
||
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
14 | * GNU General Public License for more details.
|
||
15 | *
|
||
16 | * You should have received a copy of the GNU General Public License
|
||
17 | * along with this program; if not, write to the Free Software
|
||
18 | * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
|
||
19 | * MA 02110-1301, USA.
|
||
20 | *
|
||
21 | */
|
||
22 | |||
23 | /*
|
||
24 | * AUTHORS (In addition to CIT):
|
||
25 | * 2009 IVER T.I {{Task}}
|
||
26 | */
|
||
27 | |||
28 | package org.gvsig.fmap.dal.store.postgresql; |
||
29 | |||
30 | import java.text.MessageFormat; |
||
31 | |||
32 | import javax.sql.DataSource; |
||
33 | |||
34 | import org.apache.commons.dbcp.BasicDataSource; |
||
35 | import org.gvsig.fmap.dal.exception.DataException; |
||
36 | import org.gvsig.fmap.dal.exception.InitializeException; |
||
37 | import org.gvsig.fmap.dal.resource.exception.AccessResourceException; |
||
38 | import org.gvsig.fmap.dal.store.jdbc.JDBCResource; |
||
39 | |||
40 | public class PostgreSQLResource extends JDBCResource { |
||
41 | |||
42 | public final static String NAME = "PostgreSQLResource"; |
||
43 | public static final String DESCRIPTION = "PostgreSQL Connection"; |
||
44 | |||
45 | public PostgreSQLResource(PostgreSQLResourceParameters parameters)
|
||
46 | throws InitializeException {
|
||
47 | super(parameters);
|
||
48 | } |
||
49 | |||
50 | public String getName() throws AccessResourceException { |
||
51 | PostgreSQLResourceParameters params = (PostgreSQLResourceParameters) this.getParameters();
|
||
52 | return MessageFormat.format("PostgreSQLResource({0},{1})", |
||
53 | new Object[] { params.getUrl(),params.getUser() }); |
||
54 | } |
||
55 | |||
56 | protected void connectToDB() throws DataException { |
||
57 | super.connectToDB();
|
||
58 | } |
||
59 | |||
60 | protected DataSource createDataSource() { |
||
61 | PostgreSQLResourceParameters jdbcParams = (PostgreSQLResourceParameters) this
|
||
62 | .getParameters(); |
||
63 | BasicDataSource dataSource = new BasicDataSource();
|
||
64 | dataSource.setDriverClassName(jdbcParams.getJDBCDriverClassName()); |
||
65 | dataSource.setUsername(jdbcParams.getUser()); |
||
66 | dataSource.setPassword(jdbcParams.getPassword()); |
||
67 | dataSource.setUrl(jdbcParams.getUrl()); |
||
68 | |||
69 | dataSource.setMaxWait(60L * 1000); // FIXME |
||
70 | |||
71 | // FIXME Set Pool parameters:
|
||
72 | /*
|
||
73 | dataSource.setMaxActive(maxActive);
|
||
74 | dataSource.setMaxIdle(maxActive);
|
||
75 | dataSource.setMaxOpenPreparedStatements(maxActive);
|
||
76 | dataSource.setMaxWait(maxActive);
|
||
77 | dataSource.setInitialSize(initialSize);
|
||
78 | dataSource.setDefaultReadOnly(defaultReadOnly);
|
||
79 | dataSource.setDefaultTransactionIsolation(defaultTransactionIsolation);
|
||
80 | dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
|
||
81 | dataSource.setMinIdle(minIdle);
|
||
82 | dataSource.setTestOnBorrow(testOnBorrow);
|
||
83 | dataSource.setTestOnReturn(testOnReturn);
|
||
84 | dataSource.setTestWhileIdle(testOnReturn);
|
||
85 | dataSource
|
||
86 | .setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
|
||
87 | |||
88 | dataSource.setAccessToUnderlyingConnectionAllowed(allow);
|
||
89 | dataSource.setLoginTimeout(seconds);
|
||
90 | dataSource.setLogWriter(out);
|
||
91 | */
|
||
92 | return dataSource;
|
||
93 | } |
||
94 | |||
95 | } |