Nutz
  1. 主页/
  2. 问答
NutzCN Logo
问答 查询出来的实体对象，marker.setDelFlag(true); this.dao().update(marker); 报错
发布于 2572天前 作者 qq_e79520c3 1855 次浏览 复制 上一个帖子 下一个帖子
标签: 无 
  For example:> "INSERT INTO RTS_RESULT_MARKER(id,title,description,type,iconurl,longititude,latitude,height,datetime,owner,ownername,opBy,opAt,delFlag) VALUES(69,'mm','mm','NULL','NULL','539980.6084102','2516392.981298','NULL',0,'NULL','NULL','bae9ac75d26741f2a914eeb152a2c94f',1509360144,false) "
[DEBUG] 2017-10-30 18:42:24,497 cn.wizzer.app.web.commons.processor.LogTimeProcessor.process(LogTimeProcessor.java:26) - [POST]URI=/RealTiSystem/platform/RTS/resultMarker/saveDocMarker 74ms
[DEBUG] 2017-10-30 18:42:28,981 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) - Found mapping for [POST] path=/platform/RTS/resultMarker/getDocMarkerByLonLat : RtsResultMarkerController.getDocMarkerByLonLat(RtsResultMarkerController.java:58)
[DEBUG] 2017-10-30 18:42:28,986 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'shiroUtil'<class cn.wizzer.framework.util.ShiroUtil>
[DEBUG] 2017-10-30 18:42:28,986 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'dateUtil'<class cn.wizzer.framework.util.DateUtil>
[DEBUG] 2017-10-30 18:42:28,986 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'stringUtil'<class cn.wizzer.framework.util.StringUtil>
[DEBUG] 2017-10-30 18:42:28,986 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'rtsResultMarkerController'<class cn.wizzer.app.web.modules.controllers.platform.RTS.RtsResultMarkerController>
[DEBUG] 2017-10-30 18:42:32,348 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - select * from RTS_RESULT_MARKER  where  RTS_RESULT_MARKER.LONGITITUDE = ?  and  RTS_RESULT_MARKER.LATITUDE = ? and RTS_RESULT_MARKER.DELFLAG =? order by RTS_RESULT_MARKER.OPAT desc
    |              1 |              2 |     3 |
    |----------------|----------------|-------|
    | 539980.6084102 | 2516392.981298 | false |
  For example:> "select * from RTS_RESULT_MARKER  where  RTS_RESULT_MARKER.LONGITITUDE = '539980.6084102'  and  RTS_RESULT_MARKER.LATITUDE = '2516392.981298' and RTS_RESULT_MARKER.DELFLAG =false order by RTS_RESULT_MARKER.OPAT desc"
[DEBUG] 2017-10-30 18:42:32,363 cn.wizzer.app.web.commons.processor.LogTimeProcessor.process(LogTimeProcessor.java:26) - [POST]URI=/RealTiSystem/platform/RTS/resultMarker/getDocMarkerByLonLat 3377ms
[DEBUG] 2017-10-30 18:42:39,163 org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3949) - MisfireHandler: scanning for misfires...
[DEBUG] 2017-10-30 18:42:39,179 org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3198) - Found 0 triggers that missed their scheduled fire-time.
[DEBUG] 2017-10-30 18:42:39,547 org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3877) - ClusterManager: Check-in complete.
[DEBUG] 2017-10-30 18:42:47,357 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) - Found mapping for [POST] path=/platform/RTS/resultMarker/delDocMarkerByLonLat : RtsResultMarkerController.delDocMarkerByLonLat(RtsResultMarkerController.java:87)
[DEBUG] 2017-10-30 18:42:47,358 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'shiroUtil'<class cn.wizzer.framework.util.ShiroUtil>
[DEBUG] 2017-10-30 18:42:47,358 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'dateUtil'<class cn.wizzer.framework.util.DateUtil>
[DEBUG] 2017-10-30 18:42:47,358 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'stringUtil'<class cn.wizzer.framework.util.StringUtil>
[DEBUG] 2017-10-30 18:42:47,359 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'rtsResultMarkerController'<class cn.wizzer.app.web.modules.controllers.platform.RTS.RtsResultMarkerController>
[DEBUG] 2017-10-30 18:42:47,362 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - select * from RTS_RESULT_MARKER  where  RTS_RESULT_MARKER.LONGITITUDE = ?  and  RTS_RESULT_MARKER.LATITUDE = ? and RTS_RESULT_MARKER.DELFLAG =? order by RTS_RESULT_MARKER.OPAT desc
    |              1 |              2 |     3 |
    |----------------|----------------|-------|
    | 539980.6084102 | 2516392.981298 | false |
  For example:> "select * from RTS_RESULT_MARKER  where  RTS_RESULT_MARKER.LONGITITUDE = '539980.6084102'  and  RTS_RESULT_MARKER.LATITUDE = '2516392.981298' and RTS_RESULT_MARKER.DELFLAG =false order by RTS_RESULT_MARKER.OPAT desc"
[DEBUG] 2017-10-30 18:42:59,577 org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3877) - ClusterManager: Check-in complete.
[DEBUG] 2017-10-30 18:43:02,456 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - UPDATE RTS_RESULT_MARKER SET title=?,description=?,type=?,iconurl=?,longititude=?,latitude=?,height=?,datetime=?,owner=?,ownername=?,opBy=?,opAt=?,delFlag=?  WHERE id=?
    |  1 |  2 |    3 |    4 |              5 |              6 |    7 | 8 |    9 |   10 |                               11 |         12 |   13 | 14 |
    |----|----|------|------|----------------|----------------|------|---|------|------|----------------------------------|------------|------|----|
    | mm | mm | NULL | NULL | 539980.6084102 | 2516392.981298 | NULL | 0 | NULL | NULL | bae9ac75d26741f2a914eeb152a2c94f | 1509360144 | true | 69 |
  For example:> "UPDATE RTS_RESULT_MARKER SET title='mm',description='mm',type='NULL',iconurl='NULL',longititude='539980.6084102',latitude='2516392.981298',height='NULL',datetime=0,owner='NULL',ownername='NULL',opBy='bae9ac75d26741f2a914eeb152a2c94f',opAt=1509360144,delFlag=true  WHERE id=69"
[DEBUG] 2017-10-30 18:43:02,723 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) - SQLException
java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字

	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor._exec(CachedNutDaoExecutor.java:317)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
3 回复

maker类贴来看看

已经解决了，非常感谢，么么哒

@qq_e79520c3 原因？

添加回复
请先登陆
回到顶部