mysql报错语言_mysql,_mysql语句没问题，但是报错了，请指教，mysql - phpStudy

mysql语句没问题，但是报错了，请指教

com.zhuzher.cri.database.util.DaoRuntimeException: 数据库操作错误!; nested exception is org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select id,city,IFNULL(X(centerpoint),'') as longitude,IFNULL(Y(centerpoint),'') as latitude from city WHERE chainhotelid=?;]; Data truncation: Invalid GIS data provided to function st_x.; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

at com.zhuzher.cri.database.util.CloudyUtil.getArrayList(CloudyUtil.java:155)

at com.zhuzher.cri.dao.impl.CityDaoImpl.getCityList(CityDaoImpl.java:16)

at com.zhuzher.cri.cache.CertInfoUtil.cache(CertInfoUtil.java:188)

at com.zhuzher.cri.cache.CertInfoUtil.cacheBrandInfo(CertInfoUtil.java:117)

at com.zhuzher.cri.cache.CertInfoUtil.removeTimeOut(CertInfoUtil.java:280)

at com.zhuzher.cri.task.ClearTask.execute(ClearTask.java:15)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)

at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)

at org.quartz.core.JobRunShell.run(JobRunShell.java:223)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select id,city,IFNULL(X(centerpoint),'') as longitude,IFNULL(Y(centerpoint),'') as latitude from city WHERE chainhotelid=?;]; Data truncation: Invalid GIS data provided to function st_x.; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)

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

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

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

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:718)

at com.zhuzher.cri.database.util.CloudyUtil.getArrayList(CloudyUtil.java:143)

... 14 more

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3601)

at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1569)

at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1425)

at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2912)

at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:479)

at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2618)

at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1787)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2208)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)

... 19 more

相关阅读:

width: calc(100% - 20px);这句话是什么意思呢？

java注解@Interface与Annotation

echarts中x轴类型为time时如何显示多条曲线？

vue 怎么筛选 过滤数据？用的vue element后台

ui-router多视图嵌套，如果保障各个ui-view下的css相互独立

No gulpfile found

bootstrap的button自定义颜色不生效，原因是什么？

bootstrap本地引入效果不完全是怎么回事？(有一些有效果有一些没有)

swift第三方框架可以直接拖入项目？

我想获得h4里的data-status等数据，在js代码里应该怎么写

关于微信支付，在调起支付面板之后，输密码之前不想支付了，怎么监听关闭面板这个事件？

_$_15d1[19]匹配，并输出其中的数字？

【nodejs】node-inspector报错

js怎么快速创建这样一个数组？

下面这些linux账户都有什么区别？

问个简单的数学问题 - swift

angular如何动态解析html和js混写的json数据

Javaweb程序发布到服务器tomcat为什么建议打成war包？

谁有FileZilla软件32位的?发一下呗,谢谢

如何删除数组的第i个元素，且使得操作时间不依赖于数组的长度n？如果不能打乱顺序又该怎样操作呢？