Hibernate工程，从oracle切换到mysql的注意事项

最新推荐文章于 2022-07-07 16:17:32 发布
置顶 最新推荐文章于 2022-07-07 16:17:32 发布
阅读量1.3k 收藏 4
点赞数 2
分类专栏： Java 文章标签： hibernate mysql oracle java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/happy_happy_days/article/details/84189920
版权

1.添加mysql驱动

mysql-connector-java-5.1.38.jar（该驱动包得根据使用得mysql版本而定，这只是“举个栗子~栗子~子”）

2.修改jdbc.properties文件

需要修改驱动、url、用户名、密码、方言等...

#Oracle
#jdbc.driver=oracle.jdbc.driver.OracleDriver
#jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521/orcl
#jdbc.username=test
#jdbc.password=123456
#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
#hibernate.show_sql=false
#hibernate.format_sql=true

 

#mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/testdb
jdbc.username=test
jdbc.password=123456
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.format_sql=true

3.修改application.xml

不同的数据库validationQuery使用的语句不一样。

<!-- <property name="validationQuery" value="select 1 from dual"/> -->
<property name="validationQuery" value="select 1" />
<!--<property name="validationQuery" value="select 1 from sysibm.sysdummy1"/> -->

4.若hibernate使用了JPA，还需要修改persistence.xml文件。

JPA:Java Persistence API（Java 持久层 API）.

<persistence-unit name="org.jbpm.persistence.jpa"
    transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <mapping-file>META-INF/JBPMorm.xml</mapping-file>
    <mapping-file>META-INF/Taskorm.xml</mapping-file>
    <properties>
        <property name="hibernate.max_fetch_depth" value="3" />
        <property name="hibernate.hbm2ddl.auto" value="update" />
        <property name="hibernate.show_sql" value="true" />
         <!--<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />-->
       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
        <!--<property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />-->
    </properties>
</persistence-unit>

PS：菜鸟犯的小错，花了一天才找到问题，看来还是得深入学习才行......

在Hibernate工程，从oracle切换到mysql时，由于没有修改JPA Content中的persistence.xml文件，导致启动时报下面的错误。

解决办法：详细请看上面第4步。

错误信息如下：

2018-11-17 12:53:58,850   (org.springframework.beans.factory.support.DefaultListableBeanFactory:1498) DEBUG --> Invoking afterPropertiesSet() on bean with name 'ksession'
2018-11-17 12:53:58,860   (org.drools.persistence.SingleSessionCommandService:273) DEBUG --> Instantiating  DroolsSpringTransactionManager
2018-11-17 12:53:58,942   (org.drools.container.spring.beans.persistence.DroolsSpringTransactionManager:98) DEBUG --> Current TX name (According to TransactionSynchronizationManager) : null
2018-11-17 12:53:58,943   (org.springframework.orm.jpa.JpaTransactionManager:331) DEBUG --> Found thread-bound EntityManager [org.hibernate.ejb.EntityManagerImpl@592bf412] for JPA transaction
2018-11-17 12:53:58,943   (org.springframework.orm.jpa.JpaTransactionManager:365) DEBUG --> Creating new transaction with name [null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2018-11-17 12:53:58,976   (org.hibernate.impl.SessionImpl:265) DEBUG --> opened session at timestamp: 15424304389
2018-11-17 12:53:58,978   (org.hibernate.transaction.JDBCTransaction:78) DEBUG --> begin
2018-11-17 12:53:58,978   (org.hibernate.jdbc.ConnectionManager:444) DEBUG --> opening JDBC connection
2018-11-17 12:53:58,991   (org.hibernate.transaction.JDBCTransaction:83) DEBUG --> current autocommit status: false
2018-11-17 12:53:58,991   (org.springframework.orm.jpa.JpaTransactionManager:407) DEBUG --> Not exposing JPA transaction [org.hibernate.ejb.EntityManagerImpl@592bf412] as JDBC transaction because JpaDialect [org.springframework.orm.jpa.DefaultJpaDialect@3cbb114c] does not support JDBC Connection retrieval
2018-11-17 12:53:58,992   (org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler:400) DEBUG --> Joined local transaction
2018-11-17 12:53:59,011   (org.hibernate.jdbc.AbstractBatcher:410) DEBUG --> about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2018-11-17 12:53:59,012   (org.hibernate.SQL:111) DEBUG --> select SESSIONINFO_ID_SEQ.nextval from dual
Hibernate: select SESSIONINFO_ID_SEQ.nextval from dual
2018-11-17 12:53:59,033   (org.hibernate.jdbc.AbstractBatcher:418) DEBUG --> about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2018-11-17 12:53:59,034   (org.hibernate.util.JDBCExceptionReporter:225) DEBUG --> could not get next sequence value [select SESSIONINFO_ID_SEQ.nextval from dual]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'SESSIONINFO_ID_SEQ' in field list
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.Util.getInstance(Util.java:386)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:112)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:105)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)
    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:201)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:147)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:71)
    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:808)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:782)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:786)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
    at com.sun.proxy.$Proxy53.persist(Unknown Source)
    at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:17)
    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:152)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommandService(KnowledgeStoreServiceImpl.java:129)
    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:67)
    at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:122)
    at org.drools.container.spring.beans.StatefulKnowledgeSessionBeanFactory.internalAfterPropertiesSet(StatefulKnowledgeSessionBeanFactory.java:85)
    at org.drools.container.spring.beans.AbstractKnowledgeSessionBeanFactory.afterPropertiesSet(AbstractKnowledgeSessionBeanFactory.java:123)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1572)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1562)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
2018-11-17 12:53:59,035   (org.hibernate.util.JDBCExceptionReporter:233) WARN  --> SQL Error: 1109, SQLState: 42S02
2018-11-17 12:53:59,035   (org.hibernate.util.JDBCExceptionReporter:234) ERROR --> Unknown table 'SESSIONINFO_ID_SEQ' in field list
2018-11-17 12:53:59,036   (org.hibernate.ejb.AbstractEntityManagerImpl:406) DEBUG --> mark transaction for rollback
2018-11-17 12:53:59,036   (org.drools.persistence.SingleSessionCommandService:368) ERROR --> Could not commit session
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not get next sequence value
    at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:226)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
    at com.sun.proxy.$Proxy53.persist(Unknown Source)
    at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:17)
    at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:152)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommandService(KnowledgeStoreServiceImpl.java:129)
    at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:67)
    at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:122)
    at org.drools.container.spring.beans.StatefulKnowledgeSessionBeanFactory.internalAfterPropertiesSet(StatefulKnowledgeSessionBeanFactory.java:85)
    at org.drools.container.spring.beans.AbstractKnowledgeSessionBeanFactory.afterPropertiesSet(AbstractKnowledgeSessionBeanFactory.java:123)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549)
    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1572)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1562)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:132)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:105)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
    at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)
    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:201)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:147)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:71)
    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:808)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:782)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:786)
    at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)
    ... 53 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'SESSIONINFO_ID_SEQ' in field list
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.Util.getInstance(Util.java:386)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:112)
    ... 63 more

 

穆小枫
关注
  • 2
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
tomcat 启动报错 registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister
闲时不练功，忙时一场空
11-11 7978
在帮朋友改bug时出现下面错误： org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister i...
register the mysql,解决 registered the JDBC driver [com.mysql.cj.jdbc.Driver] but failed to unregister...
weixin_32661017的博客
03-27 1501
Springboot在tomcat Undeploying，或者容器中关闭时老是提示如下警告，虽然不会影响程序的运行，但是还是想去掉这些不必要的异常：xxx 警告 [http-nio-8080-exec-56] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [gasb...
hibernate 框架 oracle 迁移 到mysql
jcroad的博客
09-26 1192
一、数据库迁移：（下面的内容还可以深入探究，目前是能用就行。）   1、数据库迁移用Navicat数据传输，在传输的过程中可能报错。       问题 1、oracle数据库字段类型CLOB 在传输过程中会出错。                解决：数据类型改为varchar2。       问题 2、修改过程中：报错，不允许直接修改，                报错内容：inval...
springBoot 和 jpa整合mysql数据源和oracle数据源完成数据转移
qq_45554282的博客
05-12 1221
首先我们要选择相应的springBoot版本和相应的jar包 <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <versio...
SpringBoot + JPA + MySQL多数据源配置，附带常见问题处理
MurcielagoAN的专栏
07-07 1103
SpringBoot JPA多数据源配置以及常见问题
Hibernate-Oracle-MySQL-image.rar_oracle
最新发布
09-23
这篇文档“Hibernate-Oracle-MySQL-image.rar_oracle”聚焦于使用Hibernate处理Oracle和MySQL数据库中的二进制大对象（Blob），特别关注如何存储和检索图片文件。Blob类型常用于存储大型数据，如图像、音频或视频...
hibernate连接Oracle和mySql数据库驱动下载
03-28
hibernate连接Oracle和mySql数据库驱动下载，mysql-connector-java-5.1.7-bin.jar，ojdbc6.jar，ojdbc7.jar，xdb6.jar，ucp.jar，simplefan.jar，orai18n.jar，ons.jar，antlr-2.7.7.jar，c3p0-0.9.2.1.jar等等全部...
详解Spring Hibernate连接oracle数据库的配置
10-19
主要介绍了详解Spring Hibernate连接oracle数据库的配置的相关资料,需要的朋友可以参考下
Hibernate逆向工程-oracle示例借鉴.pdf
12-25
《Hibernate逆向工程在Oracle环境下的实践指南》 在Java开发中，Hibernate作为一种流行的ORM（对象关系映射）框架，极大地简化了数据库操作。而Hibernate的逆向工程功能更是能够帮助开发者快速生成与数据库表对应的...
hibernate 以Annotation方式配置在oracle和mysql
10-04
hibernate 以Annotation方式配置在oracle和mysql hibernate，这里面提供了两个小例子，一个是配置跟oracle数据库相关联时的配置方法，一个是配置跟mysql数据库相关联时的配置方法。
基于springboot的mysql,sqlserver,oracle数据源切换
06-27
1：包结构 2：多数据源装载配置类； 3：mysql，oracle，sqlserver的声明装载类； 4：实体类，持久层； 5：控制层。
eclipse Java web项目数据库由oracle更改为mysql中遇到的问题（使用JPA注解）附上修改过程
织网捕鱼的博客
04-19 609
eclipse Java web项目数据库由oracle更改为mysql中遇到的问题（使用JPA注解）附上修改过程 com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table ‘pcom.user_sequences’ doesn’t exist com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcep...
Hibernate下oracle转mysql相关操作
zp15251778876的博客
01-29 1896
1.添加mysql驱动 例：mysql-connector-java-5.1.38.jar 2.修改jdbc.properties 例：需要修改驱动、url、用户名、密码、方言等... #Oracle #jdbc.driver=oracle.jdbc.driver.OracleDriver #jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521/orcl #jdbc.username=test #jdbc.password=123456
SpringMVC+Hibernate将连接oracle的数据库换成MySQL，报错如何解决
caoyaqi的博客
06-23 2666
将连接oracle的数据库换成MySQL，一般情况下需要更换的配置有：hibernate.dialect=org.hibernate.dialect.MySQLDialect  、connection.driver_class=com.mysql.jdbc.Driver 、connection.url=jdbc:mysql://10.61.8.23:3306/DB ；更换完这些配置后启动tomca
hibernate 从oracle 移植到mysql 需要改的地方
weixin_36354499的博客
09-01 653
hibernate 从oracle 移植到mysql 需要改的地方 1.数据库驱动。从oracle 更改为mysql的驱动。并把对应的包加载到项目中。 2.表中 hibernate的配置文件里把oracle的sequences 更改为 mysql的自增方式  。 3.mysql新增表时候记得加上表和字段的编码方式，可能插入时候报1366错误 show variables like ‘ch
Oracle数据库迁MySQL经验分享
kerolalala的博客
02-04 4299
由于某项目需要从Oracle改为Mysql服务器，涉及到数据库迁移问题，这里分享下操作流程。 1、用navicat将Oracle表结构和数据迁移到MySQL 选工具-数据传输 如图选择传输对象，再点击选项，建议把“遇到错误继续勾选”，否则有时候1、2张表报错，会导致整个传输中断。 选择需要传输的表，这里直接选“运行期间的全部”即可，点击“下一步”开始传输传输结束后记得看看日志，是哪几张表报错，可以根据表结构手动去创建。 2、项目改成用MySQL...
Django获取mysql表数据报错 Unknown column table.id in field list
Powehi777的博客
06-13 986
此报错解决方法 1.为要查询的表添加一个列名为’id’的自增列 此列不一定要为自增列，里面可以为任意值 对于原本拥有id列的表 这种情况在django导入数据库models.py文件时为默认不到入’id’列 解决方法： 在此表中将’id’列换为非’id’的列名即可检索到数据 ...
Unknown column 'user_uid' in 'field list' sql错误解决过程
热门推荐
蝈蝈的博客
12-13 12万+
昨天在eclipse中使用jdbc向mysql数据库插入数据时，报以下错误信息： com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘user_uid’ in ‘field list’ 直觉反应是数据库字段和sql语句字段不一致。所以就核对表字段。打开Navicat连接mysql，查看表设计，如下图

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值