springboot 前缀_springboot项目中连接oracle时需要带上模式前缀

最新推荐文章于 2024-01-28 14:30:24 发布

weixin_39924779

最新推荐文章于 2024-01-28 14:30:24 发布

阅读量745

点赞数

文章标签： springboot 前缀

本文链接：https://blog.csdn.net/weixin_39924779/article/details/111815935

版权

本文介绍了在SpringBoot项目中使用JPA连接Oracle数据库时遇到的'表或视图不存在'的问题。错误源于未在SQL查询中包含Oracle的模式前缀。通过在查询语句中加入模式前缀，如`select * from "GAME_USER"."t_user"`，问题得到解决。

摘要由CSDN通过智能技术生成

除了刚开始工作的时候用过一次oracle，已经有好些年没用过oracle了，最近在做项目对接的时候，对方提供的是oracle数据库，直接用jpa去连接数据库查询的时候，提示“表或视图不存在”，但是表确实是存在的，详细错误信息如下：

Hibernate: select user0_."id" as id1_1_, user0_."cloth" as cloth2_1_, user0_."expire" as expire3_1_, user0_."flag" as flag4_1_, user0_."gametime" as gametime5_1_, user0_."gender" as gender6_1_, user0_."name" as name7_1_, user0_."pwd" as pwd8_1_, user0_."pwd2" as pwd9_1_, user0_."status" as status10_1_, user0_."uid" as uid11_1_, user0_."valitime" as valitime12_1_, user0_."vip" as vip13_1_ from "t_user" user0_

2019-11-25 13:13:33,014 default [main] WARN o.h.e.j.s.SqlExceptionHelper 8143 - SQL Error: 942, SQLState: 42000

2019-11-25 13:13:33,014 default [main] ERROR o.h.e.j.s.SqlExceptionHelper 8143 - ORA-00942: 表或视图不存在

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281)

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255)

at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:528)

at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)

at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:178)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.intercepto