Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Paramet
2013-1-17 22:16:07 org.apache.catalina.core.AprLifecycleListener init
信息: Loaded APR based Apache Tomcat Native library 1.1.22.
2013-1-17 22:16:07 org.apache.catalina.core.AprLifecycleListener init
信息: APR capabilities: IPv6 [false], sendfile [true], accept filters [false], random [true].
2013-1-17 22:16:16 org.apache.coyote.http11.Http11AprProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2013-1-17 22:16:16 org.apache.coyote.ajp.AjpAprProtocol init
信息: Initializing Coyote AJP/1.3 on ajp-8009
2013-1-17 22:16:16 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 10090 ms
2013-1-17 22:16:17 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2013-1-17 22:16:17 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.35
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor day22.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor host-manager.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor manager.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployWAR
信息: Deploying web application archive livestore.war
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory bookstore
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day20
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day21
ServletContextAttribute域中添加了新对象
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day22_log4j
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory docs
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory examples
2013-1-17 22:16:18 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2013-1-17 22:16:18 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ItheimaTfyBookstore
2013-1-17 22:16:19 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
2013-1-17 22:16:19 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2013-1-17 22:16:19 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2013-1-17 22:16:19 org.apache.catalina.startup.Catalina start
信息: Server startup in 2376 ms
log4j:WARN No appenders could be found for logger (org.apache.commons.beanutils.converters.BooleanConverter).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
com.itheima.tfy.exception.DaoException: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [5cfa378d-4336-4373-975b-8423c05a75c2, null, ??????java????¨?????????? java????¨???????]
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:25)
at com.itheima.tfy.serice.impl.BusinessServiceImpl.addCategory(BusinessServiceImpl.java:19)
at com.itheima.tfy.web.servlet.ManagerServlet.addCategory(ManagerServlet.java:35)
at com.itheima.tfy.web.servlet.ManagerServlet.doGet(ManagerServlet.java:24)
at com.itheima.tfy.web.servlet.ManagerServlet.doPost(ManagerServlet.java:47)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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.itheima.tfy.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
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:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [5cfa378d-4336-4373-975b-8423c05a75c2, null, ??????java????¨?????????? java????¨???????]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:455)
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:20)
... 21 more
com.itheima.tfy.exception.DaoException: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [4bf4a026-4155-4dd8-8a8e-d9a7ca6ed2c0, null, ??????java????¨?????????? java????¨???????]
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:25)
at com.itheima.tfy.serice.impl.BusinessServiceImpl.addCategory(BusinessServiceImpl.java:19)
at com.itheima.tfy.web.servlet.ManagerServlet.addCategory(ManagerServlet.java:35)
at com.itheima.tfy.web.servlet.ManagerServlet.doGet(ManagerServlet.java:24)
at com.itheima.tfy.web.servlet.ManagerServlet.doPost(ManagerServlet.java:47)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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.itheima.tfy.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
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:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [4bf4a026-4155-4dd8-8a8e-d9a7ca6ed2c0, null, ??????java????¨?????????? java????¨???????]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:455)
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:20)
... 21 more
