常用数据库通用连接方式

左手的ㄟ右手 2024-04-01 14:06 55阅读 0赞

### **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 数据库连接** ###

<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