java - 程序在executeBatch上挂起-6ren

java - 程序在executeBatch上挂起

转载作者：行者123 更新时间：2023-11-29 21:11:23

我正在尝试解析文档并将结果插入数据库。该文档非常大(几百万条记录)，因此我尝试通过 c3p0 和批处理使用连接池进行多线程处理。对于每解析 1000 条记录，我会分出一个线程来创建一个PreparedStatement，插入所需的一系列值，然后添加到该PreparedStatement 的批处理中。但是，在执行executeBatch 函数时，程序只是挂起，并且没有任何内容插入到数据库中。我想知道是否我使用 c3p0 不当或者是其他原因？我尝试将其限制为一个线程，认为多线程性可能是问题所在，但即使只有一个线程，它仍然卡在执行批处理上。

这是脱离线程的代码:

service.submit(new ElementProcessor(source.getConnection(), fElements));

源是我的 ComboPooledDataSource，服务是 ExecutorService。另外，ElementProcessor 类的构造函数:

private Connection DB;
public ElementProcessor(Connection db, Element[] elements) {
    DB = db;
    try {
        DB.setAutoCommit(false);
    } catch (SQLException ex) {

    }
    this.elements = elements;
}

来自 JVM 线程转储的堆栈跟踪:

    2016-03-31 12:17:03
Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.40-b16 mixed mode):

"Attach Listener" #34 daemon prio=9 os_prio=31 tid=0x00007fdf6e000000 nid=0x3e0b waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"pool-1-thread-16" #33 prio=5 os_prio=31 tid=0x00007fdf6b970800 nid=0x8103 waiting on condition [0x0000700002b97000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-15" #32 prio=5 os_prio=31 tid=0x00007fdf6e276000 nid=0x7f03 waiting on condition [0x0000700002a94000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-14" #31 prio=5 os_prio=31 tid=0x00007fdf6b228800 nid=0x7d03 waiting on condition [0x0000700002991000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-13" #30 prio=5 os_prio=31 tid=0x00007fdf6c0b8000 nid=0x7b03 waiting on condition [0x000070000288e000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-12" #29 prio=5 os_prio=31 tid=0x00007fdf6b948000 nid=0x7903 waiting on condition [0x000070000278b000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-11" #28 prio=5 os_prio=31 tid=0x00007fdf6abf4000 nid=0x7703 waiting on condition [0x0000700002688000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-10" #27 prio=5 os_prio=31 tid=0x00007fdf6b1b0800 nid=0x7503 waiting on condition [0x0000700002585000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-9" #26 prio=5 os_prio=31 tid=0x00007fdf6d11c800 nid=0x7303 waiting on condition [0x0000700002482000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-8" #25 prio=5 os_prio=31 tid=0x00007fdf6c0fd800 nid=0x7103 waiting on condition [0x000070000237f000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-7" #24 prio=5 os_prio=31 tid=0x00007fdf6d9b1800 nid=0x6f03 waiting on condition [0x000070000227c000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-6" #23 prio=5 os_prio=31 tid=0x00007fdf6c1e8800 nid=0x6d03 waiting on condition [0x0000700002179000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-5" #22 prio=5 os_prio=31 tid=0x00007fdf6e835000 nid=0x6b03 waiting on condition [0x0000700002076000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-4" #21 prio=5 os_prio=31 tid=0x00007fdf6d958800 nid=0x6903 waiting on condition [0x0000700001f73000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-3" #20 prio=5 os_prio=31 tid=0x00007fdf6d138000 nid=0x6703 waiting on condition [0x0000700001e70000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-2" #19 prio=5 os_prio=31 tid=0x00007fdf6e189800 nid=0x6503 waiting on condition [0x0000700001d6d000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"pool-1-thread-1" #18 prio=5 os_prio=31 tid=0x00007fdf6c1c2800 nid=0x6303 waiting on condition [0x0000700001c6a000]
   java.lang.Thread.State: TIMED_WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for  <0x0000000772bcaca0> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
    at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:941)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1066)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

"MySQL Statement Cancellation Timer" #17 daemon prio=5 os_prio=31 tid=0x00007fdf6d0c3000 nid=0x6103 in Object.wait() [0x0000700001b67000]
   java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bce798> (a java.util.TaskQueue)
    at java.lang.Object.wait(Object.java:502)
    at java.util.TimerThread.mainLoop(Timer.java:526)
    - locked <0x0000000772bce798> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:505)

"C3P0PooledConnectionPoolManager[identityToken->2rvxu59f1l0as16hejmoc|6477463f, dataSourceName->com.mysql.jdbc.Driver]-DeferredStatementDestroyerThread-#0" #16 daemon prio=5 os_prio=31 tid=0x00007fdf6d058000 nid=0x5f03 in Object.wait() [0x0000700001a64000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bcecf0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
    - locked <0x0000000772bcecf0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)

"C3P0PooledConnectionPoolManager[identityToken->2rvxu59f1l0as16hejmoc|6477463f, dataSourceName->com.mysql.jdbc.Driver]-HelperThread-#2" #15 daemon prio=5 os_prio=31 tid=0x00007fdf6c07c800 nid=0x5d03 in Object.wait() [0x0000700001961000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
    - locked <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)

"C3P0PooledConnectionPoolManager[identityToken->2rvxu59f1l0as16hejmoc|6477463f, dataSourceName->com.mysql.jdbc.Driver]-HelperThread-#1" #14 daemon prio=5 os_prio=31 tid=0x00007fdf6c07c000 nid=0x5b03 in Object.wait() [0x000070000185e000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
    - locked <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)

"C3P0PooledConnectionPoolManager[identityToken->2rvxu59f1l0as16hejmoc|6477463f, dataSourceName->com.mysql.jdbc.Driver]-HelperThread-#0" #13 daemon prio=5 os_prio=31 tid=0x00007fdf6c0af000 nid=0x5903 in Object.wait() [0x000070000175b000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
    - locked <0x0000000772bcf1b0> (a com.mchange.v2.async.ThreadPoolAsynchronousRunner)

"C3P0PooledConnectionPoolManager[identityToken->2rvxu59f1l0as16hejmoc|6477463f, dataSourceName->com.mysql.jdbc.Driver]-AdminTaskTimer" #12 daemon prio=5 os_prio=31 tid=0x00007fdf6e008000 nid=0x5707 in Object.wait() [0x0000700001658000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772bcef08> (a java.util.TaskQueue)
    at java.util.TimerThread.mainLoop(Timer.java:552)
    - locked <0x0000000772bcef08> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:505)

"Service Thread" #9 daemon prio=9 os_prio=31 tid=0x00007fdf6b84b000 nid=0x5303 runnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C1 CompilerThread3" #8 daemon prio=9 os_prio=31 tid=0x00007fdf6b801000 nid=0x5103 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C2 CompilerThread2" #7 daemon prio=9 os_prio=31 tid=0x00007fdf6a829800 nid=0x4f03 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C2 CompilerThread1" #6 daemon prio=9 os_prio=31 tid=0x00007fdf6b028800 nid=0x4d03 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"C2 CompilerThread0" #5 daemon prio=9 os_prio=31 tid=0x00007fdf6b026800 nid=0x4b03 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"Signal Dispatcher" #4 daemon prio=9 os_prio=31 tid=0x00007fdf6b01f800 nid=0x3a0f runnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE

"Finalizer" #3 daemon prio=8 os_prio=31 tid=0x00007fdf6b01d800 nid=0x3803 in Object.wait() [0x0000700000d3a000]
   java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772b9a640> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:142)
    - locked <0x0000000772b9a640> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:158)
    at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:209)

"Reference Handler" #2 daemon prio=10 os_prio=31 tid=0x00007fdf6b01c800 nid=0x3603 in Object.wait() [0x0000700000c37000]
   java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x00000006c1645268> (a java.lang.ref.Reference$Lock)
    at java.lang.Object.wait(Object.java:502)
    at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:157)
    - locked <0x00000006c1645268> (a java.lang.ref.Reference$Lock)

"main" #1 prio=5 os_prio=31 tid=0x00007fdf6b000800 nid=0x1703 in Object.wait() [0x0000700000219000]
   java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x0000000772c33978> (a com.mchange.v2.resourcepool.BasicResourcePool)
    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1465)
    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
    - locked <0x0000000772c33978> (a com.mchange.v2.resourcepool.BasicResourcePool)
    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
    at xmltodb.XMLToDB.endElement(XMLToDB.java:103)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLNSDTDValidator.endNamespaceScope(XMLNSDTDValidator.java:266)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleEndElement(XMLDTDValidator.java:2005)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.endElement(XMLDTDValidator.java:879)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1782)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2973)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at xmltodb.XMLToDB.main(XMLToDB.java:177)

"VM Thread" os_prio=31 tid=0x00007fdf6b01a000 nid=0x3403 runnable 

"GC task thread#0 (ParallelGC)" os_prio=31 tid=0x00007fdf6b805800 nid=0x2403 runnable 

"GC task thread#1 (ParallelGC)" os_prio=31 tid=0x00007fdf6b806000 nid=0x2603 runnable 

"GC task thread#2 (ParallelGC)" os_prio=31 tid=0x00007fdf6b806800 nid=0x2803 runnable 

"GC task thread#3 (ParallelGC)" os_prio=31 tid=0x00007fdf6b807000 nid=0x2a03 runnable 

"GC task thread#4 (ParallelGC)" os_prio=31 tid=0x00007fdf6b808000 nid=0x2c03 runnable 

"GC task thread#5 (ParallelGC)" os_prio=31 tid=0x00007fdf6b808800 nid=0x2e03 runnable 

"GC task thread#6 (ParallelGC)" os_prio=31 tid=0x00007fdf6b809000 nid=0x3003 runnable 

"GC task thread#7 (ParallelGC)" os_prio=31 tid=0x00007fdf6b809800 nid=0x3203 runnable 

"VM Periodic Task Thread" os_prio=31 tid=0x00007fdf6c014800 nid=0x5503 waiting on condition 

JNI global references: 241

最佳答案

明白了!我让PreparedStatement执行closeOnCompletion()而不是普通的旧close()，这导致它挂起。

关于java - 程序在executeBatch上挂起，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/36337875/

文章推荐： php - 将信息从数据库传递到 Bootstrap Modal

文章推荐： javascript - Angular 2 以编程方式绑定(bind) ngIf

java - executeBatch() 是否也会清除命令列表？
Statement.executeBatch() 的文档对此尚不清楚，但我假设调用它会清空 Statement 对象的当前 SQL 命令列表，方式与 clearBatch() 相同。做。我还假设 Pr
java - ExecuteBatch() 未更新
所以我尝试在一次更新中插入多行。经过一番谷歌搜索后，大多数人建议使用 rewriteBatch。基本上，当我尝试执行批处理时，它不会更新我的数据库。数据库是本地主机，我可以使用相同的 URL 从数据
java - Executebatch 无法仅在数据库中插入最后一行
我正在这样做，但在数据库最后一行仅更新。我检查了那里是否有20行，所有行都是在addbatch时添加的，但在executeBatch时，数据库中仅更新了最后一行。 ArrayList li = (A
java - H2:executeBatch 不起作用
我有以下代码 String query = "INSERT INTO student (age,name) VALUES (?,?)"; conn.setAutoCommit(true); ps =
java - 使用 executeBatch() 插入列表时返回数据
插入数据列表时，我必须访问自动生成的数据(id、created、last_modified ...)。因为列表可能很大，所以我使用 statement.executeBatch() 将所有内容添加到一
Java - 将记录插入数据库时，executebatch 不起作用
在从文件中提取单词并将它们存储在哈希集中后，我试图将记录插入到我在 MYSQL 中的表中。我尝试在获得 500 条记录后使用 executeBatch() 插入我的数据库，但是当执行完成时，我检查了
java - 部分失败时的 executeBatch 行为
我有一个 Java 1.6 应用程序，它使用批插入在使用 jdbc 驱动程序的 Oracle 数据库中插入记录。如您所知，在 Statement 对象上有一个名为 executeBatch() 的方法
java - 让 ExecuteBatch 执行得更快
我试图从 sybase 服务器读取一个表，处理行，并将结果输出到另一个表。 (下面是我的代码) 该代码检索表的速度非常快，处理速度也同样快(到达它在 30 秒内发送的部分)。但是当我运行 execut
java - 如何使用 executeBatch 提高性能？
我正在编写用于将 45000 条记录插入表中的 Java 代码我正在使用以下代码: //create Db Connection List sqlInsertQueries = getListOfIn
jdbc - 在具有不同故障处理的 jdbc 中替代 executeBatch？
如果其中一个执行失败，则 executeBatch update 不会继续执行其余命令。无论如何或任何替代 executeBatch，其中即使命令执行失败，其余命令仍然成功执行。不使用 execute
java - JDBC preparedStatement.executeBatch() 的终止条件
我正在使用java.sql库来批量执行更新。当执行preparedStatement.executeBatch()时，理想情况下它应该返回一个更新计数数组。但在某些情况下，它返回 -2，而不是更新计
java - 超时时可运行任务内的 JDBC executeBatch 行为
我有一个 Runnable 任务，它使用 JDBC 执行批量更新。在主线程中，我创建了一个可运行任务的实例并将其提交给 ExecutorService，它为我提供了一个 Future 对象。然后，我通
java - JDBC PreparedStatement.executeBatch 不更新数据库中的值并且没有错误
您好，我正在尝试使用 JDBC addBatch executeBatch 更新 sybase 数据库。我在运行时创建表并在 jdbc 批处理中插入值。我正在以下列格式从逗号分隔的文件中读取值 1,A
java - ExecuteBatch 不是只执行一次，而是在每条记录之后执行。为什么？
这是我的代码: prodsQuery = dbc .connect() .prepareStatement(
java - 在Oracle中运行批处理语句: sendBatch() vs executeBatch()
我正在编写 Java 代码来在 Oracle 数据库中执行一批插入语句。我在一些文档 ( http://docs.oracle.com/cd/B28359_01/java.111/b31224/ora
java - executeBatch 不返回多个 ResultSet 是否有原因
我正在查看其他人编写的一些旧代码，并注意到如果他们使用批量更新而不是一次执行一个更新，性能可能会提高(我们目前在使用 > 发出保存时遇到一些滞后问题)我们正在编写的游戏有 150 名玩家)。但是，问
java - preparedstatement 的 executebatch() 不返回添加的批处理数
我正在尝试从准备好的语句中添加批处理，精确到 3000 次，但是当调用 executebatch() 时，返回的受影响行数为 2048，这发生在值添加批处理中大于 2048 的调用语句。从哪里返回计数
java - 如何处理 Statement.ExecuteBatch() 中的错误或重复记录
我有一个java程序，它处理一个包含100万条记录的文件，并使用批量插入将其插入表中，即Statement.addbatch()，然后Statement.executeBatch() 每 1000 条
java - 如果一条记录插入失败，如何让Preparedstatement.executeBatch() 为好记录工作
在我的java代码中，我有一个Prepared语句ps_temp。 PreparedStatement ps_temp; // loop ps_temp.setString(1,'abc'); ...
java - 如何从 executeBatch 获取 ResultSet？
我需要从已执行的批处理中获取结果集: String [] queries = {"create volatile table testTable as (select * from order

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

java - 程序在executeBatch上挂起