常用数据库通用连接方式

1、greenplum 通用连接

jdbc:pivotal:greenplum://10.168.2.34:5432;databaseName=yun_pai_db;user=yun_pai_db;password=Qwer6666!

Driver ：com.pivotal.jdbc.GreenplumDriver

<dependency>
    <groupId>com.pivotal</groupId>
	<artifactId>greenplum-jdbc</artifactId>
    <version>5.1.4</version>
</dependency>

greenplum锁表处理

查询因为锁表而等待的语句

select * from pg_stat_activity 
where 	waiting_reason = 'lock' 	
--and datname='apldb';

--锁表查询
select distinct b.pid from pg_class a, 	pg_locks b
 where a.oid = b.relation 	
--and a.relname='table_name';
--锁表处理
select pg_cancel_backend(32445);  --pid
--杀死会话
select pg_terminate_backend(14828);  --pid
select pg_terminate_backend(14828);  --pid
--杀掉tjbb39下所有不活跃的无效的会话
select pg_terminate_backend(pid) 
from pg_stat_activity 
WHERE datname='apldb' 
and usename = 'tjbb39' 
and state = 'idle';

2、kingbase 数据库连接

<!-- kingbase -->
<dependency>
   <groupId>cn.com.kingbase</groupId>
   <artifactId>kingbase8</artifactId>
   <version>8.6.0</version>
</dependency>

3、MySQL 配置 通用配置

jdbc:mysql://10.168.0.1:3306/data_base_name?user=root&password=123456

com.mysql.cj.jdbc.Driver

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.25</version>
</dependency>

4、sql server 配置

url="jdbc:sqlserver://${sqlserver.host};database=${sqlserver.instance};user=${sqlserver.user};password=${sqlserver.password}"

5、oracle 通用

jdbc:oracle:thin:@//172.0.0.1:1521/data_base_name