java列在此处不允许_SQL的两个错误(无效的列类型: getTimestamp not implemented及ORA-00984: 列在此处不允许)...

uncategorized SQLException; SQL state [99999]; error code [17004]; 无效的列类型

错误现象

无效的列类型: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor

; uncategorized SQLException; SQL state [99999]; error code [17004]; 无效的列类型: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor; nested exception is java.sql.SQLException: 无效的列类型: getTimestamp not implemented for class oracle.jdbc.driver.T4CNumberAccessor

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy140.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:168)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:82)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)

at com.sun.proxy.$Proxy223.getPayLogToday(Unknown Source)

at com.bjbde.admin.system.service.impl.OsmPayLogServiceImpl.getPayLogToday(OsmPayLogServiceImpl.java:28)

at com.bjbde.admin.system.service.impl.OsmPayLogServiceImpl$$FastClassBySpringCGLIB$$4df311c5.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)

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

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)

结论：

错误原因：经过排查发现实体类创建的日期类型在数据库中是Number类型，就是这个原因导致的。

java.sql.SQLSyntaxErrorException: ORA-00984: 列在此处不允许

错误现象

### SQL: insert into OSM_REFUND_CHECK(SID, ACCOUNT_DATE, TRADE_MONEY, TRADE_FEE, CHECK_TIME, REMARK, IS_DEL) values ( ?, sysdate-1, ?, ?, syadate, ?, ? )

### Cause: java.sql.SQLSyntaxErrorException: ORA-00984: 列在此处不允许

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00984: 列在此处不允许

at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.

结论：

出现的原因是由于，在插入字符或字符串型字段时。如果插入的数据是纯数字，则不会有错误；如果出现字符，则会报ORA-00984列在此处不允许异常。

本例错误 Sysdate 误写为 Syadate。