无法提取ResultSet。Oracle数据库的问题

Question

我有一个与Oracle数据库应用程序连接的Spring Boot。同一版本的应用程序在MySQL上运行良好，但当我尝试对Oracle数据库执行一些请求时，它会抛出错误：

Servlet.service（）的servlet[调度Servlet]在上下文与路径[]抛出异常[请求处理失败；嵌套异常org.springframework.dao.InvalidDataAccessResourceUsageExctive：无法提取ResultSet；SQL[n/a]；嵌套异常org.hibernate.exception.SQLGrammarExctive：无法提取ResultSet]根原因

“状态”：500，“错误”：“内部服务器错误”，“跟踪”：“org.springframework.dao.InvalidDataAccessResourceUsageException:无法提取结果集；SQL[n/a]；嵌套异常为org.hibernate.exception.sqlgrammareException:无法提取结果集\r\n\tat org.springframework.orm.jpa.vendor.hibernatePadialect.convertHibernateAccessException（hibernatePadialect.java:281）\r\n\t组织。springframework。奥姆。jpa。小贩HibernatePadialect。TranslateException如果可能（HibernateJpaDialect.java:255）\r\n\t org。springframework。奥姆。jpa。AbstractEntityManagerFactoryBean。TranslateException如果可能（AbstractEntityManagerFactoryBean.java:528）\r\n\t org。springframework。刀。支持ChainedPersistenceExceptionTranslator。TranslateException如果可能（ChainedPersistenceExceptionTranslator.java:61）\r\n\t组织。springframework。刀。支持数据附件。translateIfNecessary（DataAccessUtils.java:242）\r\n\t组织。springframework。刀。支持PersistenceExceptionTranslationInterceptor。在com上调用（PersistenceExceptionTranslationInterceptor.java:154）。实例帕维尔。费用控制器。费用控制员。createExpense（ExpenseController.java:67）~[classes/:na]等。。。

下面是我的控制器方法：

    @PostMapping("/expense")
    ResponseEntity<Expense> createExpense(@Valid @RequestBody Expense expense) throws URISyntaxException {

        Expense result = expenseRepository.save(expense);
        return ResponseEntity.created(new URI("/api/expense/" + result.getId())).body(result);
    }

还有我的消费模式

@NoArgsConstructor
@Data
@Table(name="expense")
@Entity
public class Expense {

    @Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    private Long id;

    private Instant date; 

    private double amount;
    
    private String description;

    @ManyToOne
    private Category category;

    @ManyToOne
    private User user;

// Getters and setters

这是我的申请表。属性

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
spring.jpa.properties.hibernate.ddl-auto=create-drop
spring.jpa.properties.hibernate.show-sql=true

spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.username=system
spring.datasource.password=root
spring.datasource.initialization-mode=always
spring.datasource.validationQuery=SELECT 1

logging.level.org.hibernate.SQL=DEBUG
spring.server.compression.enabled=true

spring.jpa.database-platform=org.hibernate.dialect.Oracle12cDialect

spring.jpa.properties.hibernate.format_sql=true

Answer 1

您应该向应用程序中添加Hibernate方言。像这样的财产

html prettyprint-override">spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect