学习hibernate中的一些问题及知识(1)

最新推荐文章于 2023-04-23 15:35:47 发布
最新推荐文章于 2023-04-23 15:35:47 发布
阅读量4k 收藏
点赞数
分类专栏： hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_39659895/article/details/78186049
版权

创建持久化类需要遵循的四大条件（JavaBean）：


出错语句：

<?xml version="1.0"?>


<!--
  ~ Hibernate, Relational Persistence for Idiomatic Java
  ~
  ~ License: GNU Lesser General Public License (LGPL), version 2.1 or later.
  ~ See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
  -->
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- 包名:实体类所在的包 -->
<hibernate-mapping package="com.xl.entity">
<!-- 
class:实体对象和数据库表做对应
name:实体类的类名
table：对应数据库的表名
-->
    <class name="Text" table="TEXT">
        <!-- id 表的主键
        name:实体类中的一个属性
        column：数据库中表的主键
         -->
        <id name="t_id" column="T_ID">
        <!-- 主键的生成方式 -->
            <generator class="sequence">
<param name="sequence_name">text</param>
</generator>
        </id>
        <!-- 以下是普通属性的配置 -->
        <!-- property 实体类中的普通属性
        name:实体类中的属性
        column:数据库中表的字段名
        type：字段的类型
         -->
        <property name="name" column="NAME"/>
        <property name="age" column="AGE"/>
        <property name="sex" column="SEX"/>
        <property name="score" column="SCORE"/>
        
    </class>


</hibernate-mapping>




Hibernate: drop table TEXT cascade constraints
十月 09, 2017 7:28:31 下午 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@142eef62] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.
十月 09, 2017 7:28:32 下午 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:375)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:241)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:144)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:445)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)
at com.xl.dao.impl.TextDaoImpl.Student(TextDaoImpl.java:18)
at com.xl.dao.impl.TextDaoImpl.main(TextDaoImpl.java:35)
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
... 14 more


Hibernate: drop sequence text
Hibernate: create sequence text start with 1 increment by 1
十月 09, 2017 7:28:33 下午 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@21694e53] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.
Hibernate: create table TEXT (ID number(10,0) not null, NAME varchar2(255 char), AGE number(10,0), SEX varchar2(255 char), SCORE double precision, primary key (ID))
十月 09, 2017 7:28:33 下午 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:440)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:424)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:315)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:166)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:135)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:121)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:155)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:445)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)
at com.xl.dao.impl.TextDaoImpl.Student(TextDaoImpl.java:18)
at com.xl.dao.impl.TextDaoImpl.main(TextDaoImpl.java:35)
Caused by: java.sql.SQLException: ORA-00955: 名称已由现有对象使用


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
... 14 more


十月 09, 2017 7:28:33 下午 org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@62417a16'
Hibernate: select text.nextval from dual
Hibernate: insert into TEXT (NAME, AGE, SEX, SCORE, ID) values (?, ?, ?, ?, ?)
十月 09, 2017 7:28:33 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 2201, SQLState: 42000
十月 09, 2017 7:28:33 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ORA-02201: 此处不允许序列


十月 09, 2017 7:28:33 下午 org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
INFO: HHH000010: On release of batch it still contained JDBC statements
十月 09, 2017 7:28:33 下午 org.hibernate.internal.ExceptionMapperStandardImpl mapManagedFlushFailure
ERROR: HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: could not execute statement]
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1434)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:484)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3190)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2404)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:467)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:146)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:220)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
at com.xl.dao.impl.TextDaoImpl.Student(TextDaoImpl.java:27)
at com.xl.dao.impl.TextDaoImpl.main(TextDaoImpl.java:35)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3003)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3503)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:586)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:460)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1428)
... 10 more
Caused by: java.sql.SQLException: ORA-02201: 此处不允许序列


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:205)
... 19 more


解决方法：

 <class name="Text" table="TEXT">只要这句改动即可

改为：

 <class name="Text" table="T_TEXT"> 只要table名字不相同即可，真实原因是序列化名字不能跟表名一样



程序猿2018！
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
hibernate删除有外键的数据时出错
小枫的博客
04-01 1526
控制台出现报错： 01:59:12,862 WARN SqlExceptionHelper:127 - SQL Error: 1048, SQLState: 23000 01:59:12,862 ERROR SqlExceptionHelper:129 - Column 'lkm_cust_id' cannot be null 01:59:12,870 INFO AbstractBatchI...
错误:org.hibernate.exception.SQLGrammarException: could not execute
天龙的博客
12-02 2494
于Hibernate的应用程序的开发过程中，通过Hibernate操作数据库时，在程序执行过程中出现了SQL Grammer Exception,Could not execute JDBC batch update的提示信息。遇到此类问题确实让人感觉摸不着头脑（尤其是第一次遇到），不过解决此类问题并不需要大动干戈地大规模修改代码，也不需要做更改数据库连接方式这样动用牛刀的事。问题的来源还在于细节...
Mysql报错:could not execute statement；MySQLSyntaxErrorException: You have an error in your SQL.
weixin_42585386的博客
04-25 1469
报错过程如下:1.对数据库执行了一个update操作,就报错了 Hibernate: update user set age=?, dept_id=?, dept_name=?, desc=?, email=?, gender=?, is_secre...
配置Hibernate出现的各种坑
weixin_42542536的博客
06-11 593
1.java.lang.ClassNotFoundException: javax.xml.bind.JAXBException 故障原因： JAXB API是java EE 的API，因此在java SE 9.0 中不再包含这个 Jar 包。 java 9 中引入了模块的概念，默认情况下，Java SE中将不再包含java EE 的Jar包 而在 java 6/7 / 8 时关于这个API 都是...
关于On release of batch it still contained JDBC statements异常的疑问
笑看人生的专栏
04-12 1万+
在项目中.发现 Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 .................................... [org.hibernat
Hibernate 中文api 等学习资料
12-07
**学习Hibernate的关键知识点** 1. **实体管理**：理解Hibernate如何将Java对象映射到数据库表，以及Entity、Id、GeneratedValue等注解的用法。 2. **会话和事务**：掌握SessionFactory、Session和Transaction的...
Hibernate3.3_学习笔记.doc.zip
06-02
学习Hibernate3.3首先需要理解其基本的环境配置，包括JDK、JDBC驱动、Ant或Maven构建工具的安装，以及hibernate.properties或hibernate.cfg.xml配置文件的设置，如数据库连接信息、方言选择等。 三、实体类与映射...
hibernate框架学习实例
03-16
**hibernate框架学习实例** Hibernate 是一个强大的Java持久化框架，它简化了数据库与对象之间的交互，使得开发者可以更加专注于业务逻辑而不必过多地处理SQL语句。...祝你在学习Hibernate的过程中取得进步！
基于Hibernate中配置文件的学习(分享)
08-30
总结来说，学习Hibernate的配置文件主要涉及以下几个方面： 1. 理解配置文件的结构和各部分的作用。 2. 掌握数据库连接配置，包括驱动、URL、用户名和密码。 3. 明确数据库方言的设置，以便正确生成SQL语句。 4. ...
hibernate学习资料
10-23
《Hibernate学习之旅：SSH框架中的持久化神器》 在IT领域，SSH（Spring、Struts、Hibernate）被誉为经典的Java Web开发三大框架。其中，Hibernate作为数据持久化工具，以其强大的对象关系映射（ORM）能力，极大地...
On release of batch it still contained JDBC statements
y41992910的博客
11-12 1万+
最近用hiernate执行saveOrUpdate的时候，报错了。错误信息如下 2018-11-12 13:55:32,265 [WARN ] [http-bio-8080-exec-9] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1062, SQLState: 23000 2018-11-12 13:55:32,2...
hibernate java.util.date 精度_新手被hibernate虐哭了 求助java.util.Date为什么报错？
weixin_36319237的博客
03-02 76
该楼层疑似违规已被系统折叠隐藏此楼查看此楼type="java.util.Date"的时候报错 如下WARN: SQL Error: 0, SQLState: 22001destoryorg.hibernate.exception.DataException: could not execute statement九月 10, 2015 11:24:51 上午 org.hibernate.eng...
hibernate save数据到 oracle 问题之一：On release of batch it still contained JDBC statements
alinekang的博客
10-23 2165
要读取某个文件的数据存储到oracle 数据库，真的是，各种问题频繁而出啊。 在save操作的时候，报错 “On release of batch it still contained JDBC statements” 网上搜了一下，说是 Hibernate的删除和更新操作，只对persistence对象有效，即这些对象已存在于数据库中（可以是你通过查找操作从数据库中刚取出的对象）。而不能用n...
MySQL 异常：Lock wait timeout exceeded
最新发布
lizhengyu891231的博客
04-23 404
MySQL 异常：Lock wait timeout exceeded
java执行更新语句不起作用_java – 更新时出现Hibernate错误：无法执行语句,在’index = 1’附近使用正确的语法...
weixin_42521450的博客
02-27 486
我正在使用带有Hibernate和MySQL的netbeans开发桌面应用程序.当我向数据库添加一条新记录时,它完全正常工作但是当我尝试更新一个对象字段时,我有这个错误：could not execute statementINFO: HHH000010: On release of batch it still contained JDBC statementsJan 17, 2015 2:47...
使用hibernate保存数据报错
yuan_qh的博客
11-07 618
控制台报错：  ERROR org.hibernate.internal.SessionImpl - HHH000346: Error during managed flush [Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1]   由于存在隐藏表单进行...
Hibernate报错：On release of batch it still contained JDBC statements
热门推荐
小康子的博客
02-21 2万+
On release of batch it still contained JDBC statements 错误。
7.Hibernate一对多关系建立与错误解决
weixin_34253126的博客
12-29 441
一对多表关系在hibernate中的配置 1.数据库建表 创建用户表以及联系人表，其中一个用户对应多个联系人，联系人外键参照于用户表的主键 创建cst_customer表 CREATE TABLE IF NOT EXISTS cst_customer( cst_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '用户ID', cs...
mysql 告警 异常 处理_mysql异常解决方案 - Lock wait timeout exceeded异常
weixin_30601893的博客
01-19 615
问题最近线上业务在运行过程中，遇到如下异常：2021-01-13 10:25:20.838 WARN [http-nio-7010-exec-104][SqlExceptionHelper.java:127] - SQL Error: 1205, SQLState: 410002021-01-13 10:25:20.839 INFO [http-nio-7010-exec-104][Abstrac...
Hibernate核心知识点与学习指南
"这篇资料主要涵盖了Hibernate框架的重要知识点，包括其基本概念、配置、核心接口、映射方式、操作及缓存策略等，并强调了学习方法和相关软件、书籍及资源。" 在Hibernate的学习中，有几个关键点尤其值得关注： 1....

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值