jdbc 配置连接greeplum数据，spring配置连接greeplum数据（简单配置学习）

spring数据源配置

greenplum.jdbc.driverClassName=org.postgresql.Driver
greenplum.jdbc.password=username
greenplum.jdbc.url=jdbc:postgresql://10.27.116.31:5432/dbname
greenplum.jdbc.username=password



<!-- ========================= -->
	<bean id="customerSingleViewDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName"><value>${greenplum.jdbc.driverClassName}</value></property>
		<property name="url"><value>${greenplum.jdbc.url}</value></property>
		<property name="username"><value>${greenplum.jdbc.username}</value></property>
		<property name="password"><value>${greenplum.jdbc.password}</value></property>
		<property name="initialSize" value="2"></property>
		<property name="maxIdle" value="10"></property>
		<property name="maxActive" value="20"></property>
		<property name="maxWait" value="1000"></property>
		<property name="testOnBorrow" value="true"></property>
		<property name="testOnReturn" value="true"></property>
		<property name="testWhileIdle" value="true"></property>
		<property name="removeAbandoned" value="true"></property>
		<property name="removeAbandonedTimeout" value="1000"></property>
		<property name="logAbandoned" value="true"></property>
    </bean> 

 

原生jdbc连接

import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;  
  
public class GPTest {  
  
    public static void main(String[] args) {  
        try {  
            Class.forName("org.postgresql.Driver");  
            Connection db = DriverManager.getConnection("jdbc:postgresql://10.27.116.31:5432/dbname","username","password");  
            Statement st = db.createStatement();  
            ResultSet rs = st.executeQuery("select * from vw_test limit 1 offset 0");  
            while (rs.next()) {  
                System.out.println(rs.getString(1));  
            }  
            rs.close();  
            st.close();  
        } catch (ClassNotFoundException e) {  
            e.printStackTrace();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
    }  
}

 

 

 

 

评论

1 楼 langke93 2016-10-25  

我发现greenplum 通过jdbc insert性能很差，每秒只有几条，不知道你有没有同样问题