teradata.serverName=127.0.0.1 teradata.portNumber=1025 teradata.databaseName=myDatabase teradata.user=myUser teradata.password=myPassword teradata.pool.maxConnections=10 teradata.pool.minConnections=5 teradata.pool.idleTimeout=30000 teradata.pool.loginTimeout=10000 import java.io.InputStream; import java.util.Properties; import com.teradata.jdbc.TeraDriver; import org.apache.commons.pool2.impl.GenericObjectPoolConfig; ... Properties properties = new Properties(); InputStream inputStream = getClass().getClassLoader().getResourceAsStream("teradata-pool.properties"); properties.load(inputStream); GenericObjectPoolConfig<Connection> poolConfig = new GenericObjectPoolConfig<>(); poolConfig.setMaxTotal(Integer.parseInt(properties.getProperty("teradata.pool.maxConnections"))); poolConfig.setMinIdle(Integer.parseInt(properties.getProperty("teradata.pool.minConnections"))); poolConfig.setMaxIdle(Integer.parseInt(properties.getProperty("teradata.pool.maxConnections"))); poolConfig.setMinEvictableIdleTimeMillis(Long.parseLong(properties.getProperty("teradata.pool.idleTimeout"))); TeradataDataSource dataSource = new TeradataDataSource(new TeraDriver(), properties.getProperty("teradata.serverName"), Integer.parseInt(properties.getProperty("teradata.portNumber")), properties.getProperty("teradata.databaseName"), properties.getProperty("teradata.user"), properties.getProperty("teradata.password"), poolConfig);


上一篇:
下一篇:
切换中文