通过工具能够连上，数据库连接，用户名密码都没有问题。有的说是数据库连接超时造成的，本机的不应该啊

问答通过工具能够连上，数据库连接，用户名密码都没有问题。有的说是数据库连接超时造成的，本机的不应该啊

发布于 3352天前作者 qq_c6efc20e 2132 次浏览复制上一个帖子下一个帖子

标签: dao

2015-10-20 09:45:11,887 INFO (NutSessionListener.java:41) - NutIoc SessionScope is Enable.
2015-10-20 09:45:11,892 INFO (NutFilter.java:71) - NutFilter[nutz] starting ...
2015-10-20 09:45:14,571 INFO (NutLoading.java:52) - Nutz Version : 1.b.52
2015-10-20 09:45:14,571 INFO (NutLoading.java:53) - Nutz.Mvc[nutz] is initializing ...
2015-10-20 09:45:14,835 INFO (AnnotationIocLoader.java:47) - Scan complete ! Found 15 classes in 1 base-packages!
beans = ["basicDao", "dictionaryService", "dictionaryDao", "loginAction", "loginDao", "contractDao", "demoService", "commonDao", "logingService", "commonService", "dateUtils", "contractService", "cacheUtils", "payAction", "demoDao"]
2015-10-20 09:45:14,847 INFO (NutLoading.java:140) - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
2015-10-20 09:45:14,897 WARN (ViewProcessor.java:29) - Not a good idea : Return String ,and using JsonView!! (Using @Ok("raw") or return map/list/pojo)--> PayAction.doPost(...)
2015-10-20 09:45:14,910 INFO (NutLoading.java:200) - Found 4 module methods
2015-10-20 09:45:14,912 INFO (NutLoading.java:250) - Setup application...
2015-10-20 09:45:15,009 INFO (NutFilePool.java:23) - Init file-pool by: C:\Users\jialong/.nutz/tmp/dao/ [200000]
2015-10-20 09:45:15,011 INFO (NutFilePool.java:60) - file-pool.cursor: 0
2015-10-20 09:45:15,020 INFO (Jdbcs.java:98) - Get Connection from DataSource for JdbcExpert
2015-10-20 09:45:36,187 ERROR (NutLoading.java:116) - Error happend during start serivce!
org.nutz.ioc.IocException: create ioc bean fail name=dao ioc define:
{
"type" :"org.nutz.dao.impl.NutDao",
"singleton" :true,
"args" :[{
"type" :"refer",
"value" :"dataSource"
}],
"fields" :[],
"scope" :"app"
}
at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:132)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:194)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:212)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:139)
at cn.com.myapp.main.FinanceSetup.init(FinanceSetup.java:31)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:253)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:112)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter.init(NutFilter.java:78)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4574)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5193)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.nutz.lang.born.BorningException: Fail to born 'org.nutz.dao.impl.NutDao'
by args: [
@(org.apache.commons.dbcp.BasicDataSource@61d9faa6)] becasue:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:19)
at org.nutz.ioc.weaver.DefaultWeaver.born(DefaultWeaver.java:67)
at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:103)
... 25 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.nutz.trans.Trans.getConnectionAuto(Trans.java:254)
at org.nutz.dao.jdbc.Jdbcs.getExpert(Jdbcs.java:101)
at org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:155)
at org.nutz.dao.impl.NutDao.(NutDao.java:113)
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:525)
at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
... 27 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
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:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
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:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 38 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.(Socket.java:425)
at java.net.Socket.(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:292)
... 54 more
SEVERE: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.ioc.IocException: create ioc bean fail name=dao ioc define:
{
"type" :"org.nutz.dao.impl.NutDao",
"singleton" :true,
"args" :[{
"type" :"refer",
"value" :"dataSource"
}],
"fields" :[],
"scope" :"app"
}
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:525)
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:931)
at org.nutz.lang.Lang.wrapThrow(Lang.java:164)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:117)
at org.nutz.mvc.ActionHandler.(ActionHandler.java:19)
at org.nutz.mvc.NutFilter.init(NutFilter.java:78)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4574)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5193)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.nutz.ioc.IocException: create ioc bean fail name=dao ioc define:
{
"type" :"org.nutz.dao.impl.NutDao",
"singleton" :true,
"args" :[{
"type" :"refer",
"value" :"dataSource"
}],
"fields" :[],
"scope" :"app"
}
at org.nutz.ioc.impl.ObjectMakerImpl.make(ObjectMakerImpl.java:132)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:194)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:212)
at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:139)
at cn.com.myapp.main.FinanceSetup.init(FinanceSetup.java:31)
at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:253)
at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:112)
... 19 more
Caused by: org.nutz.lang.born.BorningException: Fail to born 'org.nutz.dao.impl.NutDao'
by args: [
@(org.apache.commons.dbcp.BasicDataSource@61d9faa6)] becasue:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

wendal

1楼•3352天前

一般就是 jdbcUrl写错，没编译，忘记启动数据库

qq_c6efc20e 2楼•3352天前

jdbcURl写错

请先登陆