MiinE企业网站系统产品保存时报错

今天用MiinE制作一个java企业网站，结果产品录入时，总是无法输入，查看MiinE日志，反复多次仅无法找到原因。

 

后来看到一段java代码：

 

    //private String inputUserName;  
    entry.setInputUserName((String)m.get("inputUserName"));
         
entry.setPrice((Float)m.get("price"));

 

 

意识到可能是数据库问题，进入miine产品表，修改price为Float,结果产品可成功保存了。

 

错误日志如下：

 

数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
htmlKeyWord  :  inputUserName  :  miininputUserId  :  1buseSelfTemplete  :  truebcmdIndex  :  truecatid  :  9contentEditor  :  <p>尚云时尚资讯网站上线</p>
viewCount  :  0htmlTitle  :  tagsName  :  htmlDescription  :  templetePath  :  price  :  10bpassed  :  truecatName  :  门户网站bcmsCat  :  truebcheck  :  trueauthorName  :  act  :  addtitle  :  尚云时尚资讯网站上线数据库连接已存在，直接返回！
DbUtil query getObjectBySQL() sql:select * from  shop_product  where   title='尚云时尚资讯网站上线' and catid=9map boolean:true
操作数据库错误，请检查表单字段是否空值，负值等错误,CmsArticle
insert source sql:insert into shop_product(@colNameList) values(@ValueList)
insert sql:insert into shop_product(title,contentfilePath,catid,catName,htmlTitle,htmlKeyWord,htmlDescription,templetePath,buseSelfTemplete,authorName,tagsName,viewCount,bcheck,bpassed,bcmdIndex,bcmsCat,addTime,updateTime,inputUserId,inputUserName,price) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
DbUtil query getObjectBySQL() sql:select * from  shop_product  where   title='尚云时尚资讯网站上线' and catid=9map boolean:true
操作数据库错误，请检查表单字段是否空值，负值等错误,CmsArticle
content Len:19
2014-4-17 12:23:06 miinshop.entryDomain.dao.ShopProductDao getObjectBySQL
严重: dao error failed
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at miinshop.entryDomain.dao.ShopProductDao.getObjectBySQL(ShopProductDao.java:169)
    at miinshop.entryDomain.service.ShopProductEntryService.getObjectBySQL(ShopProductEntryService.java:229)
    at miinshop.entryDomain.service.ShopProductEntryService.getByTitleCatId(ShopProductEntryService.java:308)
    at miinshop.admin.controler.product.ProductAdminControler.add(ProductAdminControler.java:173)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:97)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
2014-4-17 12:23:06 miinshop.entryDomain.dao.ShopProductDao getObjectBySQL
严重: dao error failed
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at miinshop.entryDomain.dao.ShopProductDao.getObjectBySQL(ShopProductDao.java:169)
    at miinshop.entryDomain.service.ShopProductEntryService.getObjectBySQL(ShopProductEntryService.java:229)
    at miinshop.entryDomain.service.ShopProductEntryService.getByTitleCatId(ShopProductEntryService.java:308)
    at miinshop.admin.controler.product.ProductAdminControler.add(ProductAdminControler.java:179)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:97)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
map boolean:true
操作数据库错误，请检查表单字段是否空值，负值等错误,CmsArticle
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at com.guuraa.miin.orm.dbutil.jdbc.BaseEntryJdbcCovert.coverRsToEntryList(BaseEntryJdbcCovert.java:80)
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverToEntryList(ShopProductJdbcConvert.java:113)
    at miinshop.entryDomain.dao.ShopProductDao.getList_qeury_Byvalidaty(ShopProductDao.java:493)
    at miinshop.entryDomain.service.ShopProductEntryService.getList_qeury_Byvalidaty(ShopProductEntryService.java:153)
    at miinshop.entryDomain.service.ShopProductEntryService.getListByCatId_cat_listPage_cache(ShopProductEntryService.java:298)
    at miinshop.admin.controler.product.ProductAdminControler.admin(ProductAdminControler.java:242)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:107)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
2014-4-17 12:24:10 miinshop.entryDomain.dao.ShopProductDao getList_qeury_Byvalidaty
严重: dao error failed
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at com.guuraa.miin.orm.dbutil.jdbc.BaseEntryJdbcCovert.coverRsToEntryList(BaseEntryJdbcCovert.java:80)
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverToEntryList(ShopProductJdbcConvert.java:113)
    at miinshop.entryDomain.dao.ShopProductDao.getList_qeury_Byvalidaty(ShopProductDao.java:493)
    at miinshop.entryDomain.service.ShopProductEntryService.getList_qeury_Byvalidaty(ShopProductEntryService.java:153)
    at miinshop.entryDomain.service.ShopProductEntryService.getListByCatId_cat_listPage_cache(ShopProductEntryService.java:298)
    at miinshop.admin.controler.product.ProductAdminControler.admin(ProductAdminControler.java:242)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:107)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
2014-4-17 12:24:11 miinshop.entryDomain.dao.ShopProductDao getList_qeury_Byvalidaty
严重: dao error failed
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at com.guuraa.miin.orm.dbutil.jdbc.BaseEntryJdbcCovert.coverRsToEntryList(BaseEntryJdbcCovert.java:80)
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverToEntryList(ShopProductJdbcConvert.java:113)
    at miinshop.entryDomain.dao.ShopProductDao.getList_qeury_Byvalidaty(ShopProductDao.java:493)
    at miinshop.entryDomain.service.ShopProductEntryService.getList_qeury_Byvalidaty(ShopProductEntryService.java:153)
    at miinshop.entryDomain.service.ShopProductEntryService.getListByCatId_cat_listPage_cache(ShopProductEntryService.java:298)
    at miinshop.admin.controler.product.ProductAdminControler.admin(ProductAdminControler.java:242)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:107)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
map boolean:true
操作数据库错误，请检查表单字段是否空值，负值等错误,CmsArticle
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Float
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverMapToEntry(ShopProductJdbcConvert.java:104)
    at com.guuraa.miin.orm.dbutil.jdbc.BaseEntryJdbcCovert.coverRsToEntryList(BaseEntryJdbcCovert.java:80)
    at miinshop.entryDomain.dao.ShopProductJdbcConvert.coverToEntryList(ShopProductJdbcConvert.java:113)
    at miinshop.entryDomain.dao.ShopProductDao.getList_qeury_Byvalidaty(ShopProductDao.java:493)
    at miinshop.entryDomain.service.ShopProductEntryService.getList_qeury_Byvalidaty(ShopProductEntryService.java:153)
    at miinshop.entryDomain.service.ShopProductEntryService.getListByCatId_cat_listPage_cache(ShopProductEntryService.java:298)
    at miinshop.admin.controler.product.ProductAdminControler.admin(ProductAdminControler.java:242)
    at miinshop.admin.controler.product.ProductAdminControler.excute(ProductAdminControler.java:107)
    at org.apache.jsp.MyApp.miinshop.admin.ArticleAdmin.controller_jsp._jspService(controller_jsp.java:70)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.guuraa.core.util.EncodeFilter.doFilter(EncodeFilter.java:38)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:679)
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！
数据库连接已存在，直接返回！

 

处理方法：

进入MiinE的mysql数据库，将产品表shop_product的price从varchar改为Float。

错误原因：数据库字段，导致MiinFramwork无法将数据记录转换为java实体类

 

MiinE是国内一款开源企业网站系统。