湖州网站制作公司,企业网站建设 优化,齐河建设局网站,实用设计网站推荐目录 报错现象报错内容处理方法Oracle驱动源码总结 报错现象
oracle表中存在TIMESTAMP类型的列时#xff0c;jdbc查出来做序列化时报错
报错内容
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframewo… 目录 报错现象报错内容处理方法Oracle驱动源码总结 报错现象
oracle表中存在TIMESTAMP类型的列时jdbc查出来做序列化时报错
报错内容
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.http.converter.HttpMessageConversionException: Type definition error: [simple type, class java.io.ByteArrayInputStream]; nested exception is com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class java.io.ByteArrayInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.oxye.ResMsg[data]-com.oxye.base.dto.BaseResponse[columns]-java.util.ArrayList[0]-java.util.ArrayList[10]-oracle.sql.TIMESTAMP[stream])
---
Caused by: org.springframework.http.converter.HttpMessageConversionException: Type definition error: [simple type, class java.io.ByteArrayInputStream]; nested exception is com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class java.io.ByteArrayInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.oxye.ResMsg[data]-com.oxye.base.dto.BaseResponse[columns]-java.util.ArrayList[0]-java.util.ArrayList[10]-oracle.sql.TIMESTAMP[stream])
---
Caused by: com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class java.io.ByteArrayInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.oxye.ResMsg[data]-com.oxye.base.dto.BaseResponse[columns]-java.util.ArrayList[0]-java.util.ArrayList[10]-oracle.sql.TIMESTAMP[stream])处理方法
任选其一目的就是设置一个变量 1.项目启动时设置一行代码 System.setProperty(“oracle.jdbc.J2EE13Compliant”, “true”);
2.jar启动命令增加 -Doracle.jdbc.J2EE13Complianttrue
3.oracle连接串中增加属性oracle.jdbc.J2EE13Complianttrue
Oracle驱动源码
版本 dependencygroupIdcom.oracle.database.jdbc/groupIdartifactIdojdbc8/artifactIdversion21.9.0.0/version/dependencyoracle.jdbc.driver.GeneratedPhysicalConnection类有属性j2ee13Compliant可以看到 readConnectionProperties中会从多处寻找属性oracle.jdbc.J2EE13Compliant找不到默认是false
/***/
abstract class GeneratedPhysicalConnection extends OracleConnection {boolean j2ee13Compliant;/***/protected void readConnectionProperties(String var1, Blind(PropertiesBlinder.class) Properties var2, Blind(PropertiesBlinder.class) Properties var3) throws SQLException {/***/var4 null;if (var2 ! null) {var4 var2.getProperty(oracle.jdbc.J2EE13Compliant);}if (var4 null) {var4 getSystemProperty(oracle.jdbc.J2EE13Compliant, (String)null);}if (var4 null var3 ! null) {var4 var3.getProperty(oracle.jdbc.J2EE13Compliant);}if (var4 null) {var4 false;}this.j2ee13Compliant var4 ! null var4.equalsIgnoreCase(true);/***/oracle.jdbc.driver.TimestampAccessor的getObject方法中会根据属性j2ee13Compliant选择获取时间的方式
/***/
class TimestampAccessor extends DateTimeCommonAccessor {/***/Object getObject(int var1) throws SQLException {if (!this.isUseLess !this.isNull(var1)) {if (this.externalType 0) {return this.statement.connection.j2ee13Compliant ? this.getTimestamp(var1) : this.getTIMESTAMP(var1);} else {switch (this.externalType) {case 93:return this.getTimestamp(var1);default:throw (SQLException)((SQLException)DatabaseError.createSqlException(this.getConnectionDuringExceptionHandling(), 4).fillInStackTrace());}}} else {return null;}}/***/oracle.jdbc.driver.DateTimeCommonAccessor有两个方法getTimestamp和getTIMESTAMPj2ee13Compliant为true时用getTimestamp获得java.sql.Timestampfalse获取oracle.sql.TIMESTAMP
/***/
import java.sql.Timestamp;
/***/
import oracle.sql.TIMESTAMP;
/***/
abstract class DateTimeCommonAccessor extends Accessor {/***/Timestamp getTimestamp(int var1) throws SQLException {return this.getTimestamp(var1, (Calendar)null);}/***/TIMESTAMP getTIMESTAMP(int var1) throws SQLException {return this.isNull(var1) ? null : new TIMESTAMP(this.getBytesInternal(var1));}/***/总结
通过设置属性oracle.jdbc.J2EE13Complianttrue可以时oracle的timestamp以oracle.sql.TIMESTAMP类型返回不设置时默认false返回oracle.sql.TIMESTAMP可能会导致序列化时类型转换失败等问题
