peng.zhou

1.批量插入sql语法insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE) select 8000,0,'Multi 8000',1 from dualunion all select 8001,0,'Multi 8001',1 from dual或者INSERT ALL INTO t

线上Oracle数据库网络非常不稳定，不时发生连接闪断，发现一个线程一直堵塞，日志没有错误。dump出线程信息后如下：pool-4-thread-50" prio=10 tid=0x00007f92f5251000 nid=0x26e1 runnable [0x00007f929a1df000]   java.lang.Thread.State: RUNNABLEat java.n