刚写的nutz，在连接mysql创建表的时候出现如下问题。看了一下午也没找到问题的所在
这是我写的js
var ioc = {
dataSource : {
type : "com.alibaba.druid.pool.DruidDataSource",
events : {
create : "init",
depose : 'close'
},
fields : {
driverClassName : "com.mysql.jdbc.Driver",
url : "jdbc:mysql://localhost:3306/nutzbook",
username : "root",
password : "root",
testWhileIdle : true,
maxWait: 15000,
validationQuery : "select 1" ,
maxActive : 100
}
},
dao : {
type : "org.nutz.dao.impl.NutDao",
args : [{refer:"dataSource"}]
}
};
这是问题：
七月 21, 2016 4:49:42 下午 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.7.0_79\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jdk1.7.0_79/bin/../jre/bin/server;C:/Program Files/Java/jdk1.7.0_79/bin/../jre/bin;C:/Program Files/Java/jdk1.7.0_79/bin/../jre/lib/amd64;G:\app\sony\product\11.1.0\db_1\bin;F:\软件\oracle1\bin;C:\Program Files\Java\jdk1.7.0_79\bin;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;c:\Program Files (x86)\AMD APP\bin\x86_64;c:\Program Files (x86)\AMD APP\bin\x86;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Sony\VAIO Improvement\;C:\Program Files (x86)\Sony\VAIO Startup Setting Tool;C:\Program Files (x86)\Windows Live\Shared;F:\软件\sv\bin;C:\Program Files\Java\jdk1.7.0_79\bin;F:\软件\Tomcat\apache-tomcat-6.0.44\bin;C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin;F:\软件\Rational Rose 2007\Common;E:\java\apache-maven-3.2.2\bin;C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin;F:\软件\Eclipse\exlipse 32\eclipse;;.
七月 21, 2016 4:49:42 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:nutzbook' did not find a matching property.
七月 21, 2016 4:49:42 下午 org.apache.coyote.http11.Http11Protocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
七月 21, 2016 4:49:42 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 1076 ms
七月 21, 2016 4:49:42 下午 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
七月 21, 2016 4:49:42 下午 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.44
七月 21, 2016 4:49:43 下午 org.apache.catalina.loader.WebappClassLoader validateJarFile
信息: validateJarFile(F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\servlet-api-2.5.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
2016-7-21 16:49:43.408 WARN [main] !!You are using default SystemLog! Don't use it in Production environment!!
2016-7-21 16:49:43.418 INFO [main] NutFilter[nutz] starting ...
2016-7-21 16:49:43.749 DEBUG [main] Locations for Scans:
[JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\nutz-last.jar], JarResourceLocation [jarPath=C:\Program Files\Java\jdk1.7.0_79\lib\tools.jar], JarResourceLocation [jarPath=F:\软件\Tomcat\apache-tomcat-6.0.44\bin\bootstrap.jar], FileSystemResourceLocation [root=F:\软件\Eclipse\exlipse 32\eclipse]]
2016-7-21 16:49:44.19 DEBUG [main] Locations for Scans:
[JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\nutz-last.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\standard.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\mysql-connector-java-5.0.0-beta-bin.jar], JarResourceLocation [jarPath=C:\Program Files\Java\jdk1.7.0_79\lib\tools.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\druid-1.0.16.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\commons-pool.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\h2-1.2.131.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\commons-dbcp.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\servlet-api-2.5.jar], JarResourceLocation [jarPath=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\lib\jstl.jar], FileSystemResourceLocation [root=F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\nutzbook\WEB-INF\classes], JarResourceLocation [jarPath=F:\软件\Tomcat\apache-tomcat-6.0.44\bin\bootstrap.jar], FileSystemResourceLocation [root=F:\软件\Eclipse\exlipse 32\eclipse]]
2016-7-21 16:49:44.24 DEBUG [main] MainModule:
2016-7-21 16:49:44.44 DEBUG [main] Loading by class org.nutz.mvc.impl.NutLoading
2016-7-21 16:49:44.48 INFO [main] Nutz Version : 1.r.56
2016-7-21 16:49:44.48 INFO [main] Nutz.Mvc[nutz] is initializing ...
2016-7-21 16:49:44.48 DEBUG [main] Web Container Information:
2016-7-21 16:49:44.50 DEBUG [main] - Default Charset : UTF-8
2016-7-21 16:49:44.51 DEBUG [main] - Current . path : F:\软件\Eclipse\exlipse 32\eclipse.
2016-7-21 16:49:44.51 DEBUG [main] - Java Version : 1.7.0_79
2016-7-21 16:49:44.51 DEBUG [main] - File separator : \
2016-7-21 16:49:44.52 DEBUG [main] - Timezone : Asia/Shanghai
2016-7-21 16:49:44.52 DEBUG [main] - OS : Windows 7 amd64
2016-7-21 16:49:44.53 DEBUG [main] - ServerInfo : Apache Tomcat/6.0.44
2016-7-21 16:49:44.53 DEBUG [main] - Servlet API : 2.5
2016-7-21 16:49:44.53 DEBUG [main] - ContextPath : /nutzbook
2016-7-21 16:49:44.54 DEBUG [main] - context.tempdir : F:\Eclise存储.metadata.plugins\org.eclipse.wst.server.core\tmp0\work\Catalina\localhost\nutzbook
2016-7-21 16:49:44.55 DEBUG [main] MainModule:
2016-7-21 16:49:44.55 DEBUG [main] >> app.root = F:/Eclise存储/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/nutzbook
2016-7-21 16:49:44.147 DEBUG [main] Using 94 castor for Castors
2016-7-21 16:49:44.149 DEBUG [main] @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.wendal.nutzbook", "*tx"],init=[])
2016-7-21 16:49:44.185 DEBUG [main] Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
2016-7-21 16:49:44.185 DEBUG [main] loading ioc js config from [dao.js]
2016-7-21 16:49:44.192 DEBUG [main] Loaded 2 bean define from path=[ioc/] --> [dataSource, dao]
2016-7-21 16:49:44.199 DEBUG [main] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2016-7-21 16:49:44.230 DEBUG [main] Found : class net.wendal.nutzbook.module.UserModule
2016-7-21 16:49:44.239 INFO [main] Found 1 classes in 1 base-packages!
beans = ["userModule"]
2016-7-21 16:49:44.240 DEBUG [main] Loaded 5 bean define from reader --
[txREPEATABLE_READ, txREAD_COMMITTED, txNONE, txSERIALIZABLE, txREAD_UNCOMMITTED]
2016-7-21 16:49:44.244 INFO [main] NutIoc init begin ...
2016-7-21 16:49:44.248 INFO [main] ... NutIoc init complete
2016-7-21 16:49:44.249 DEBUG [main] MainModule:
2016-7-21 16:49:44.253 INFO [main] Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
2016-7-21 16:49:44.256 DEBUG [main] @Views(DefaultViewMaker.class)
2016-7-21 16:49:44.265 DEBUG [main] @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
2016-7-21 16:49:44.273 DEBUG [main] module class location 'file:/F:/Eclise存储/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/nutzbook/WEB-INF/classes/net/wendal/nutzbook/MainModule.class'
2016-7-21 16:49:44.274 DEBUG [main] > scan 'net.wendal.nutzbook'
2016-7-21 16:49:44.277 DEBUG [main] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2016-7-21 16:49:44.278 DEBUG [main] >> add 'net.wendal.nutzbook.module.UserModule'
2016-7-21 16:49:44.285 INFO [main] Optional processor class not found, disabled : org.nutz.integration.shiro.NutShiroProcessor
2016-7-21 16:49:44.291 INFO [main] Optional processor class not found, disabled : org.nutz.plugins.validation.ValidationProcessor
2016-7-21 16:49:44.303 DEBUG [main] '/user/count' >> UserModule.count(...) : int | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2016-7-21 16:49:44.304 INFO [main] Found 1 module methods
2016-7-21 16:49:44.305 DEBUG [main] @Localization not define
2016-7-21 16:49:44.305 INFO [main] Setup application...
2016-7-21 16:49:44.306 DEBUG [main] Get 'dao'
2016-7-21 16:49:44.309 DEBUG [main] Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
2016-7-21 16:49:44.310 DEBUG [main] >> Load definition name=dao
2016-7-21 16:49:44.312 DEBUG [main] Loading define for name=dao
2016-7-21 16:49:44.334 DEBUG [main] Found IocObject(dao) in JsonLoader(paths=[ioc/])
2016-7-21 16:49:44.334 DEBUG [main] >> Make...'dao'
2016-7-21 16:49:44.352 DEBUG [main] Load class org.nutz.dao.impl.NutDao without AOP
2016-7-21 16:49:44.353 DEBUG [main] Save object 'dao' to [app]
2016-7-21 16:49:44.356 DEBUG [main] Get 'dataSource'<>
2016-7-21 16:49:44.356 DEBUG [main] >> Load definition name=dataSource
2016-7-21 16:49:44.356 DEBUG [main] Loading define for name=dataSource
2016-7-21 16:49:44.367 DEBUG [main] Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2016-7-21 16:49:44.367 DEBUG [main] >> Make...'dataSource'<>
2016-7-21 16:49:44.390 DEBUG [main] Load class com.alibaba.druid.pool.DruidDataSource without AOP
2016-7-21 16:49:44.390 DEBUG [main] Save object 'dataSource' to [app]
七月 21, 2016 4:49:44 下午 com.alibaba.druid.pool.vendor.MySqlValidConnectionChecker warn
警告: Cannot resolve com.mysq.jdbc.Connection.ping method. Will use 'SELECT 1' instead.
java.lang.NullPointerException
at com.alibaba.druid.pool.vendor.MySqlValidConnectionChecker.(MySqlValidConnectionChecker.java:50)
at com.alibaba.druid.pool.DruidDataSource.initValidConnectionChecker(DruidDataSource.java:892)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:608)
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.nutz.ioc.trigger.MethodEventTrigger.trigger(MethodEventTrigger.java:18)
at org.nutz.ioc.weaver.DefaultWeaver.onCreate(DefaultWeaver.java:72)
at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:138)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209)
at org.nutz.ioc.val.ReferValue.get(ReferValue.java:24)
at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:75)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:235)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:146)
at net.wendal.nutzbook.MainSetup.init(MainSetup.java:17)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:298)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:119)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4076)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4730)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:759)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
七月 21, 2016 4:49:44 下午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
2016-7-21 16:49:44.465 DEBUG [main] Get 'dataSource'<>
2016-7-21 16:49:44.474 DEBUG [main] NutDao[_selfId=0] init ...
2016-7-21 16:49:44.502 INFO [main] Init file-pool by: C:\Users\sony/.nutz/tmp/dao/ [200000]
2016-7-21 16:49:44.503 DEBUG [main] file-pool.home: 'C:\Users\sony.nutz\tmp\dao'
2016-7-21 16:49:44.504 INFO [main] file-pool.cursor: 0
2016-7-21 16:49:44.514 DEBUG [main] Jdbcs init complete
2016-7-21 16:49:44.514 INFO [main] Get Connection from DataSource for JdbcExpert, if I lock at here, check your database server and configure
2016-7-21 16:49:44.689 DEBUG [main] JDBC Driver --> mysql-connector-java-5.0.0-beta ( $Date: 2005-11-17 16:14:47 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
2016-7-21 16:49:44.689 DEBUG [main] JDBC Name --> MySQL-AB JDBC Driver
2016-7-21 16:49:44.689 DEBUG [main] JDBC URL --> jdbc:mysql://localhost:3306/nutzbook
2016-7-21 16:49:44.694 DEBUG [main] Mysql : character_set_client=utf8
2016-7-21 16:49:44.695 DEBUG [main] Mysql : character_set_connection=utf8
2016-7-21 16:49:44.695 DEBUG [main] Mysql : character_set_database=utf8
2016-7-21 16:49:44.695 DEBUG [main] Mysql : character_set_filesystem=binary
2016-7-21 16:49:44.696 DEBUG [main] Mysql : character_set_results=
2016-7-21 16:49:44.696 DEBUG [main] Mysql : character_set_server=utf8
2016-7-21 16:49:44.696 DEBUG [main] Mysql : character_set_system=utf8
2016-7-21 16:49:44.697 DEBUG [main] Mysql : character_sets_dir=C:\Program Files (x86)\MySQL\MySQL Server 5.6\share\charsets\
2016-7-21 16:49:44.698 DEBUG [main] Mysql : database=nutzbook
2016-7-21 16:49:44.698 DEBUG [main] Mysql : user=root@localhost
2016-7-21 16:49:44.712 DEBUG [main] Database info --> MYSQL:[MySQL - 5.6.5-m8]
2016-7-21 16:49:44.721 DEBUG [main] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2016-7-21 16:49:44.777 DEBUG [main] Table 't_user' doesn't exist!
2016-7-21 16:49:44.782 DEBUG [main] Table 't_user' doesn't exist!
2016-7-21 16:49:44.802 DEBUG [main] CREATE TABLE t_user(
id INT(32) AUTO_INCREMENT,
name VARCHAR(50) UNIQUE NOT NULL,
password VARCHAR(50),
salt VARCHAR(50),
ct DATETIME,
ut DATETIME,
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=utf8
2016-7-21 16:49:44.852 DEBUG [main] SELECT COUNT(*) FROM t_user
2016-7-21 16:49:44.862 DEBUG [main] INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 |
|-------|--------|------|---------------------|---------------------|
| admin | 123456 | 1000 | 2016-07-21 16:49:44 | 2016-07-21 16:49:44 |
For example:> "INSERT INTO t_user(name,password,salt,ct,ut) VALUES('admin','123456','1000','2016-07-21 16:49:44','2016-07-21 16:49:44') "
2016-7-21 16:49:44.869 DEBUG [main] SQLException
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2820)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1159)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:684)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:768)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:268)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:82)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:316)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:59)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:271)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
at net.wendal.nutzbook.MainSetup.init(MainSetup.java:28)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:298)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:119)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4076)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4730)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:759)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2016-7-21 16:49:44.871 ERROR [main] Error happend during start serivce!
org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 |
|-------|--------|------|---------------------|---------------------|
| admin | 123456 | 1000 | 2016-07-21 16:49:44 | 2016-07-21 16:49:44 |
For example:> "INSERT INTO t_user(name,password,salt,ct,ut) VALUES('admin','123456','1000','2016-07-21 16:49:44','2016-07-21 16:49:44') "'
PreparedStatement:
'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:94)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:316)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:59)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:271)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
at net.wendal.nutzbook.MainSetup.init(MainSetup.java:28)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:298)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:119)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4076)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4730)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:759)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2820)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1159)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:684)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:768)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:268)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:82)
... 29 more
2016-7-21 16:49:44.873 ERROR [main] try to depose ioc
2016-7-21 16:49:44.873 INFO [main] org.nutz.ioc.impl.NutIoc@1441653591 is closing. startup date [16-07-21 16:49:44.244]
2016-7-21 16:49:44.874 DEBUG [main] Depose object 'dataSource' ...
七月 21, 2016 4:49:44 下午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} closed
2016-7-21 16:49:44.878 DEBUG [main] Depose object 'dao' ...
2016-7-21 16:49:44.879 INFO [main] org.nutz.ioc.impl.NutIoc@1441653591 is deposed. startup date [16-07-21 16:49:44.244]
七月 21, 2016 4:49:44 下午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 |
|-------|--------|------|---------------------|---------------------|
| admin | 123456 | 1000 | 2016-07-21 16:49:44 | 2016-07-21 16:49:44 |
For example:> "INSERT INTO t_user(name,password,salt,ct,ut) VALUES('admin','123456','1000','2016-07-21 16:49:44','2016-07-21 16:49:44') "'
PreparedStatement:
'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
at org.nutz.lang.born.BornContext.doBorn(BornContext.java:60)
at org.nutz.lang.Mirror.born(Mirror.java:990)
at org.nutz.lang.Lang.wrapThrow(Lang.java:169)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:298)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:119)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4076)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4730)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:759)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 |
|-------|--------|------|---------------------|---------------------|
| admin | 123456 | 1000 | 2016-07-21 16:49:44 | 2016-07-21 16:49:44 |
For example:> "INSERT INTO t_user(name,password,salt,ct,ut) VALUES('admin','123456','1000','2016-07-21 16:49:44','2016-07-21 16:49:44') "'
PreparedStatement:
'INSERT INTO t_user(name,password,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:94)
at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:316)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:59)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:271)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
at net.wendal.nutzbook.MainSetup.init(MainSetup.java:28)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
... 20 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'ct' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2820)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1159)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:684)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:768)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:268)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:82)
... 29 more
七月 21, 2016 4:49:44 下午 org.apache.catalina.core.StandardContext start
严重: Error filterStart
七月 21, 2016 4:49:44 下午 org.apache.catalina.core.StandardContext start
严重: Context [/nutzbook] startup failed due to previous errors
七月 21, 2016 4:49:44 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
严重: The web application [/nutzbook] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
七月 21, 2016 4:49:44 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
严重: The web application [/nutzbook] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
2016-7-21 16:49:44.935 DEBUG [Finalizer] NutDao[_selfId=0] finalize
七月 21, 2016 4:49:44 下午 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
七月 21, 2016 4:49:45 下午 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
七月 21, 2016 4:49:45 下午 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/18 config=null
七月 21, 2016 4:49:45 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2484 ms