Transaction not successfully started 处理办法

本文讨论了在使用Hibernate进行对象持久化时遇到的一个常见问题:事务未成功开始导致的异常。提供了详细的错误诊断步骤和解决方案,并通过优化代码结构来避免此类问题的发生,以提高应用程序的整体性能。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

package com.demo.hibernate.dao;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.demo.hibernate.beans.User;
import com.demo.hibernate.util.HibernateSessionFactory;

public class UserDAO {
	public User getUser(String username) throws HibernateException{
		Session session = null;
		Transaction tx = null;
		User user = null;
		try{
			session = HibernateSessionFactory.currentSession();
			tx = session.beginTransaction();
			Query query = session.createQuery("from User where username=?");
			query.setString(0, username.trim());
			user = (User)query.uniqueResult();
			query = null;
			tx.commit();
		}catch(HibernateException e){
			if(tx!=null){
				tx.rollback();
			}
			throw e;
		}finally{
			HibernateSessionFactory.closeSession();
		}
		return user;
	}

}

控制台出现报错

Exception in thread "main" org.hibernate.TransactionException: Transaction not successfully started
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)


解决方法:

catch (HibernateException e) {
   if (tx != null) {
    tx.rollback();
   }
   throw e;
  } finally {
   
   HibernateSessionFactory.closeSession();
  }

文章来源:http://blog.sina.com.cn/s/blog_67c92e8d0100izhc.html

参考:http://blog.youkuaiyun.com/mfhappy/article/details/7428924

def execute_add_robot(self, sn, ip, fp, device_type, pi_ip=None): try: with self.db_engine.connect() as conn: # Start a transaction with conn.begin(): columns = ["serialnumber", "dut_ip", "floorplan", "device_type", "team", "available", "base_type", "pi_ip"] values = { "serialnumber": sn, "dut_ip": ip, "floorplan": fp, "device_type": device_type, "team": "local", "available": "1", "base_type": "ChargeBase", "pi_ip": pi_ip if pi_ip else "" } insert_stmt = text(f""" INSERT INTO devices ({', '.join(columns)}) VALUES ({', '.join([f':{col}' for col in columns])}) """) conn.execute(insert_stmt, values) if not ip.replace('.', '').isdigit(): raise ValueError("Illegal IP format") status_ip = f"status_{ip.replace('.', '_')}" create_table_sql = f""" CREATE TABLE IF NOT EXISTS `{status_ip}` ( `robot_ip` varchar(17) NOT NULL DEFAULT '{ip}', `status_busy` BOOLEAN NOT NULL DEFAULT 0, `status_base` BOOLEAN NOT NULL DEFAULT 0, `status_error` BOOLEAN NOT NULL DEFAULT 0, `status_warning` BOOLEAN NOT NULL DEFAULT 0, `external_voltage` INTEGER NOT NULL DEFAULT 0, `battery_capacity` INTEGER NOT NULL DEFAULT 100, `can_be_started` BOOLEAN NOT NULL DEFAULT 1, `last_entry_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `last_event` VARCHAR(255) NOT NULL DEFAULT 'not-initialized', `remote_rf_port` INTEGER DEFAULT 8970, `installed_firmware` VARCHAR(50) NOT NULL DEFAULT 'not-initialized', `queue_status` VARCHAR(255) NOT NULL DEFAULT 'not-initialized', `queue_length` VARCHAR(255) NOT NULL DEFAULT 'not-initialized', `queue_task` VARCHAR(255) NOT NULL DEFAULT 'not-initialized', UNIQUE KEY `robot_ip` (`robot_ip`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 """ self.execute_on_db(create_table_sql) replace_sql = text(f"REPLACE INTO `{status_ip}` (robot_ip) VALUES (:ip)") conn.execute(replace_sql, {"ip": ip}) return "Device information submitted successfully!", True except SQLAlchemyError as e: return f"Database error: {str(e)}", False except ValueError as ve: return f"IP format error: {str(ve)}", False except Exception as ex: return f"Unexpected error: {str(ex)}", False 增加注释
最新发布
03-27
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值