开发 - Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
来源:互联网 发布:mysql 5.7.17.msi安装 编辑:程序博客网 时间:2024/05/01 19:48
### Error querying database. Cause: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
; SQL []; Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
Exception in thread "main" java.lang.NullPointerException
at com.flush.service.impl.FrogServiceImpl.mySqlToEs(FrogServiceImpl.java:89)
at com.flush.service.impl.FrogServiceImpl.selectMySqlInfoToEs(FrogServiceImpl.java:77)
at com.flush.service.impl.FrogServiceImpl.selectMysqlToES(FrogServiceImpl.java:56)
at com.flush.controller.MySqlToESServer.main(MySqlToESServer.java:26)
2016-03-14 18:05:00,800 [ESClientShutdownHook] [INFO] [ESClient.java][run(117)] >>> Run ESClient shutdown hook now. 开始关闭创建的ESClient, 禁止使用kill -9 关闭 !!!
2016-03-14 18:05:00,833 [ESClientShutdownHook] [INFO] [ESClient.java][run(127)] >>> 关闭创建的[1]个ESClient结束!
以上的是两个问题,第一次是null 无法转换成 timestamp 然后使用 在创建数据源的时候,加入这个参数转换<value>jdbc:mysql://192.168.10.100:3306/trade?zeroDateTimeBehavior=convertToNull</value>
然后cannot convert的原因是因为在数据库中查出来的 0000-00-00 00:00:00 没有转换成timestamp的形式,具体可以参考
/**的写法,重写映射类,进行操作
* 这个是转换类,通过这个转换类可以吧数据库的数据转换成自己想要的内容
*/
public class TimestampToStringHandler extends BaseTypeHandler{
@Override
public void setNonNullParameter(PreparedStatement ps, int i,
Object parameter, JdbcType jdbcType) throws SQLException {
// TODO Auto-generated method stub
}
@Override
public Object getNullableResult(ResultSet rs, String columnName)
throws SQLException {
DateTime dateTime = null;
Timestamp timestamp = rs.getTimestamp(columnName);
if(timestamp != null){
dateTime = new DateTime(timestamp.getTime());
return dateTime.toString("yyyy-MM-dd HH:mm:ss");
}
return "";
}
@Override
public Object getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
return null;
}
@Override
public Object getNullableResult(CallableStatement cs, int columnIndex)
throws SQLException {
DateTime dateTime = null;
Timestamp timestamp = cs.getTimestamp(columnIndex);
if(timestamp != null){
dateTime = new DateTime(timestamp.getTime());
return dateTime.toString("yyyy-MM-dd HH:mm:ss");
}
return "";
}
}
0 0
- 开发 - Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
- mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP .
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 22 to TIMESTAMP
- spring mvc 查询报错Cannot convert value '0000-00-00' from column 20 to TIMESTAMP
- java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP
- java.Sql.Exception:Cannot convert value '0000-00-00 00:00:00' from column 13 to TIMESTAMP的解决办法
- MYSQL:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP的解决办法
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP分析及解决办法
- mysql错误: Cannot convert value ’0000-00-00 00:00:00′ from column 10 to TIMESTAMP
- Android基本的四大组件介绍
- 单例设计模式
- Install pip on MAC
- 面试题: 栈和队列的OC实现.
- 浅谈树状数组
- 开发 - Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
- Swift数组
- The inferior stopped because it triggered an exception.
- angularjs中$resource对应的五种基本操作及扩展
- mvc 判断 ViewBag.OnePageOfList是否为空
- res-auto 自定义 attr
- continue break
- RxJava occurred when trying to propagate error to Observer.onError
- 浅析php中常量,变量的作用域和生存周期