有点意思有点意思 小坤sky
关注数: 7 粉丝数: 27 发帖数: 430 关注贴吧数: 17
爬虫程序,原来能跑的,svn update后变成这样了,不知道怎么回事 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into news_column_top(column_id,img_url,news_id,create_time,modify_time,sort_num,collect_from_id,start_time,end_time) values(?,?,?,now(),now(),0,1,now(),?)]; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "end_time" 的类型为 timestamp without time zone, 但表达式的类型为 character varying 建议:你需要重写或转换表达式 位置:163 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882) at com.hzlq.hzlqswNewSpider.dao.impl.HzlqswNewsDaoImpl.addHotNews(HzlqswNewsDaoImpl.java:295) at com.hzlq.hzlqswNewSpider.service.impl.HzlqswNewsServiceImpl.addCollectNews(HzlqswNewsServiceImpl.java:154) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy10.addCollectNews(Unknown Source) at com.hzlq.hzlqswNewSpider.processor.HzlqswNewsPipeline.process(HzlqswNewsPipeline.java:231) at us.codecraft.webmagic.Spider.processRequest(Spider.java:419) at us.codecraft.webmagic.Spider$1.run(Spider.java:321) at us.codecraft.webmagic.selector.thread.CountableThreadPool$1.run(CountableThreadPool.java:74) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
1 下一页