当前位置： 当前位置：首页 >时尚 >Java程序中解决数据库超时与死锁正文

复制for (int i = 0; i < MAX_RETRY_ATTEMPTS; i++) {

//以下代码模拟一次事务

try {

stmt = conn.createStatement();

System.out.println("Transaction started...");

stmt.executeUpdate("UPDATE 1..."); //SQL语句1

stmt.executeUpdate("UPDATE 2..."); // SQL语句2

stmt.executeUpdate("UPDATE 3..."); // SQL语句3

stmt.executeUpdate("UPDATE 3..."); // SQL语句4

//提交所有更改

conn.commit();

System.out.println("事务已完成。程序超");

//确保只运行了一次。中解

i = MAX_RETRY_ATTEMPTS;

} catch (SQLException e) {

/

**

*如果返回的决数据库SQL代码为-911，回滚会自动完成，死锁程序回滚至前一次的程序超提交状态。

*程序将进行重试。中解

*/

if (-911 == e.getErrorCode()) {

//等待RETRY_WAIT_TIME

try {

Thread.sleep(RETRY_WAIT_TIME);

} catch (InterruptedException e1) {

//即使休眠被打断，决数据库但仍要重试。亿华云计算死锁

System.out.println("休眠被打断。程序超");

}

}

/

**

*如果返回的中解SQL代码为-912，表示死锁及超时。决数据库

*如果是死锁-904，代表已达到资源限度。程序超

*在这种情况下，中解程序将回滚并进行重试。站群服务器决数据库

*/

else if (-912 == e.getErrorCode() || -904 == e.getErrorCode()) {

try {

//需要回滚

conn.rollback();

} catch (SQLException e1) {

System.out.println("无法回滚。"; color:black> + e);

}

try {

//等待RETRY_WAIT_TIME

Thread.sleep(RETRY_WAIT_TIME);

} catch (InterruptedException e1) {

//即使休眠被打断，但仍要重试。

System.out.println("休眠被打断。" + e1);

}

} else {

//如果是其他错误，就不进行重试。

i = MAX_RETRY_ATTEMPTS;

System.out.println("有错误发生，错误代码："

+ e.getErrorCode() + " SQL状态："

+ e.getSQLState() + "其他信息：" + e.getMessage());

}

1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.115.116.117.118.119.120.121.122.123.124.125.126.127.128.129.130.131.132.133.134.135.136.137.138.139.140.141.142.143.144.145.146.147.148.149.150.151.152.153.154.155.156.157.158.159.160.161.162.163.164.165.166.167.168.169.170.171.172.173.174.175.176.177.178.179.180.181.182.183.184.185.186.187.188.189.190.191.192.193.194.195.196.197.198.199.200.201.202.203.204.205.206.207.208.209.210.211.212.213.214.215.216.217.218.219.220.221.222.223.224.225.226.227.228.229.230.231.232.233.234.235.236.237.238.239.240.241.242.243.244.245.246.247.248.249.250.251.252.253.254.255.256.257.258.259.260.261.262.263.264.265.266.

云服务器