关闭

JDBC访问GreenPlum

标签: GreenPlumPostgreSQL
4543人阅读 评论(0) 收藏 举报
分类:

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation.
In this short article we’ll see how to use it.


## Download and install
It is possible to download the JDBC for Greenplum directly from the Greenplum Community Edition site (http://www.greenplum.com/community/downloads/database-ce/).
Look for the *”Connectivity Tools”* file.
You will receive a link to download the archive file.
Extract the archive and run the binary extracted. Then follow the instructions on screen and in less than a minute you have installed JDBC.
## Prepare the Greenplum server
After a successful installation, make sure that the server accepts TCP connections from the desired hosts. Check that *listen_addresses* is properly set in postgresql.conf.
**Note:** by default, Greenplum listens to any address.
Another aspect you have to consider is the user authentication, which is delegated to the pg_hba.conf file (please refer to page 36 of Greenplum AdminGuide for more information).
After you have verified the user is able to connect to the database, you can go on and test JDBC.
Connecting to a Greenplum Database with JDBC is a three steps procedure:
* Import JDBC
* Load the driver
* Connect to the database

Remember that the *forName* function can throw a *ClassNotFoundException* if the driver is not available. We do not try to catch that exception in the simple example below. You should in your production environment.
To connect to a database using JDBC, you have to use a connection URL. It can be in one of these three forms:
* jdbc:postgresql:databasename
* jdbc:postgresql://host/databasename
* jdbc:postgresql://host:port/databasename
Build an URL that suits your needs and use it with the getConnection function. For example:

package com.gp.dbtest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GPDBTest {

	public static void main(String[] args) {
		try {
			Class.forName("org.postgresql.Driver");
			Connection db = DriverManager.getConnection("jdbc:postgresql://192.168.1.23:5432/zwcdb","zhongwc","zhongwc");
			Statement st = db.createStatement();
			ResultSet rs = st.executeQuery("select * from tab_gp 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();
		}
	}
}



0
0

猜你在找
【直播】机器学习&数据挖掘7周实训--韦玮
【套餐】系统集成项目管理工程师顺利通关--徐朋
【直播】3小时掌握Docker最佳实战-徐西宁
【套餐】机器学习系列套餐(算法+实战)--唐宇迪
【直播】计算机视觉原理及实战--屈教授
【套餐】微信订阅号+服务号Java版 v2.0--翟东平
【直播】机器学习之矩阵--黄博士
【套餐】微信订阅号+服务号Java版 v2.0--翟东平
【直播】机器学习之凸优化--马博士
【套餐】Javascript 设计模式实战--曾亮
查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:664063次
    • 积分:8306
    • 等级:
    • 排名:第2358名
    • 原创:216篇
    • 转载:17篇
    • 译文:0篇
    • 评论:60条
    最新评论