hibernate ORA-01453: SET TRANSACTION 必须是事务处理的第一个语句

最新推荐文章于 2023-02-15 09:17:40 发布

原创最新推荐文章于 2023-02-15 09:17:40 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库

Hibernate 专栏收录该内容

2 篇文章

订阅专栏

本文记录了一次在使用Hibernate框架操作Oracle数据库时遇到的“ORA-01453: SET TRANSACTION必须是事务处理的第一个语句”错误，并分享了解决方案。

部署运行你感兴趣的模型镜像

public static void main(String[] args) {
Session session = HibernateUtil.getSessionFactory).getCurrentSession();
session.beginTransaction();
Users user = new Users();
user.setName("weiwei");
user.setPassword("123");
session.save(user);
session.getTransaction().commit();}

session.beginTransaction();报错
xception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
at $Proxy0.beginTransaction(Unknown Source)
at com.wangchao.com.Test.main(Test.java:13)
Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION 必须是事务处理的第一个语句

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:945)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1678)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1644)
at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:1590)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:126)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 11 more
有第一条语句，数据库应该连上了，大家看看什么错，好像是ORACLE报出来的。
问题解决了

虽然不知道什么原因，但是解决了。

您可能感兴趣的与本文相关的镜像