时间戳

首页 > 解决方案 > SQL [SELECT * FROM AH_PATIENT] 的未分类 SQLException；SQL状态[60000]；错误代码[604]；ORA-00604: 递归 SQL 级别 1 发生错误

spring-batch - SQL [SELECT * FROM AH_PATIENT] 的未分类 SQLException；SQL状态[60000]；错误代码[604]；ORA-00604: 递归 SQL 级别 1 发生错误

问题描述

我正在 PCF DEV 环境中部署Spring Boot - Spring Batch代码，其中批处理代码将连接到 Oracle Dev 并将所有数据加载到 mongo dev 中。但是，虽然>cf push，我得到了错误。

2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] ... 45 common frames omitted
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.batch.item.support.AbstractItemCountingItemStreamItemReader.open(AbstractItemCountingItemStreamItemReader.java:149) ~[spring-batch-infrastructure-4.1.1.RELEASE.jar!/:4.1.1.RELEASE]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.batch.item.database.AbstractCursorItemReader.doOpen(AbstractCursorItemReader.java:427) ~[spring-batch-infrastructure-4.1.1.RELEASE.jar!/:4.1.1.RELEASE]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.batch.item.database.AbstractCursorItemReader.initializeConnection(AbstractCursorItemReader.java:458) ~[spring-batch-infrastructure-4.1.1.RELEASE.jar!/:4.1.1.RELEASE]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.5.RELEASE.jar!/:5.1.5.RELEASE]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) ~[spring-jdbc-5.1.5.RELEASE.jar!/:5.1.5.RELEASE]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] ; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] Caused by: org.springframework.jdbc.UncategorizedSQLException: Executing query; uncategorized SQLException for SQL [SELECT * FROM AH_PATIENT]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [app/:na]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [app/:na]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [app/:na]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [app/:na]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_202]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_202]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_202]
2019-06-04T10:12:43.319+05:30 [APP/PROC/WEB/0] [OUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_202]

我点击了链接：ORA-01882: timezone region not found，但我不知道在哪里完全改变了。

标签： spring-batchspring-data-mongodbpcfpcfdev

解决方案

我能够使用链接解决此问题：ORA-01882: timezone region not found。

我只是-Doracle.jdbc.timezoneAsRegion=false在manifest.yml文件中设置。您还可以在 PCF 中手动添加用户定义的环境变量。

推荐阅读