### Error querying database. Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"
Syntax error in SQL statement "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"; SQL statement:
SELECT
ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,
TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE,
TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME
FROM
DUAL [42000-232]
### The error may exist in file [C:\workspace\evanes-exchange-batch\build\resources\main\sql\CustomZeroFxchangeEventInfoDao.xml]
### The error may involve com.sbibits.evanes.exchange.batch.dao.CustomZeroEventInfoDao.getEventInfo
### The error occurred while executing a query
### SQL: SELECT ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL, TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE, TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME FROM DUAL
### Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"
Syntax error in SQL statement "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"; SQL statement:
SELECT
ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,
TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE,
TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME
FROM
DUAL [42000-232]
; bad SQL grammar []
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"
Syntax error in SQL statement "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"; SQL statement:
SELECT
ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,
TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE,
TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME
FROM
DUAL [42000-232]
### The error may exist in file [C:\workspace\evanes-exchange-batch\build\resources\main\sql\CustomZeroFxchangeEventInfoDao.xml]
### The error may involve com.sbibits.evanes.exchange.batch.dao.CustomZeroEventInfoDao.getEventInfo
### The error occurred while executing a query
### SQL: SELECT ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL, TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE, TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME FROM DUAL
### Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"
Syntax error in SQL statement "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"; SQL statement:
SELECT
ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,
TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE,
TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME
FROM
DUAL [42000-232]
; bad SQL grammar []
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:95)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:347)
at jdk.proxy3/jdk.proxy3.$Proxy69.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at jdk.proxy3/jdk.proxy3.$Proxy71.getEventInfo(Unknown Source)
at com.sbibits.evanes.exchange.batch.repository.impl.ExchangeOrderRepositoryImpl.getEventInfo(ExchangeOrderRepositoryImpl.java:258)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:359)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728)
at com.sbibits.evanes.exchange.batch.repository.impl.ExchangeOrderRepositoryImpl$$SpringCGLIB$$0.getEventInfo(<generated>)
at com.sbibits.evanes.exchange.batch.repository.ExchangeOrderRepositoryTest.testExecuteGetZeroFxchangeFixedRate(ExchangeOrderRepositoryTest.java:62)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.Streams$StreamBuilderImpl.forEachRemaining(Streams.java:411)
at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762)
at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:1024)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: SQLステートメントに文法エラーがあります "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"
Syntax error in SQL statement "SELECT\000a ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,\000a TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE[*],\000a TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME\000a FROM\000a DUAL"; SQL statement:
SELECT
ETJP_FXCHANGE_EVENTID_SEQ.NEXTVAL AS NEXTVAL,
TO_CHAR(SYSDATE, 'YYYYMMDD') AS EVENTDATE,
TO_CHAR(SYSDATE, 'HH24MISS') AS EVENTTIME
FROM
DUAL [42000-232]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.message.DbException.getSyntaxError(DbException.java:247)
at org.h2.command.Tokenizer.tokenize(Tokenizer.java:541)
at org.h2.command.ParserBase.initialize(ParserBase.java:292)
at org.h2.command.Parser.parse(Parser.java:552)
at org.h2.command.Parser.prepareCommand(Parser.java:484)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:328)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:88)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:90)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:60)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:90)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:333)
... 58 more
用H2测试的时候发生上面的问题
在yml里配置了支持oracle
debug: false
spring:
batch:
job:
enabled: false
datasource:
hikari:
maximum-pool-size: 32
url: jdbc:h2:mem:ZERO;MODE=Oracle;
username:
password:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: org.h2.Driver
sql:
init:
schema-locations:
- classpath:db/*.sql
我要怎么修改,解决这个问题
最新发布