Discussion :

[yozine]

Bonjour,

je me récolte une erreur de connection que je comprend pas:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
Created MBeanServer with ID: 162dbb6:116d82c47d5:-8000:FR-D-SINT5-24:1
14 dÚc. 2007 11:21:29 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
DÚmarrage du service Tomcat-Standalone
Apache Tomcat/4.1.36-LE-jdk14
2007-12-14 11:21:53,621 [main] ERROR com.ancv.guide.metier.Commun - jdbcConnect:
 cannot establish connection: Communications link failure due to underlying exce
ption:
 
** BEGIN NESTED EXCEPTION **
 
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect
 
STACKTRACE:
 
java.net.SocketException: java.net.ConnectException: Connection timed out: conne
ct
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:264)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnecti
on(DriverManagerConnectionFactory.java:94)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:300)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericOb
jectPool.java:816)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:171)
 
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at com.ancv.guide.metier.Commun.jdbcConnect(Commun.java:432)
        at com.ancv.guide.metier.Commun.jdbcConnect(Commun.java:400)
        at com.ancv.guide.metier.Commun.jdbcConnect(Commun.java:375)
        at com.ancv.guide.metier.Commun.listeDomaine(Commun.java:190)
        at com.ancv.guide.plugin.ConfigPlugIn.init(ConfigPlugIn.java:173)
        at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServle
t.java:1158)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:486)
        at javax.servlet.GenericServlet.init(GenericServlet.java:213)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:880)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:76
8)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3484)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:3
710)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:777)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:76
0)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:538)
 
        at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDe
ployer.java:663)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.jav
a:216)
        at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:217)
        at org.apache.commons.digester.Rule.end(Rule.java:253)
        at org.apache.commons.digester.Digester.endElement(Digester.java:1222)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1720)
        at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:667)
        at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
        at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
 
        at org.apache.commons.digester.Digester.parse(Digester.java:1765)
        at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:339)
        at org.apache.catalina.core.StandardHost.install(StandardHost.java:762)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:439)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:373
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:785)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:331)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1156)
 
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:697)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1148)
 
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:311
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
50)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:221
3)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:459)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:346)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:130)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:151)
 
 
** END NESTED EXCEPTION **
 
 
 
Last packet sent to the server was 15 ms ago.
2007-12-14 11:21:53,621 [main] ERROR com.ancv.guide.metier.Commun - listeDomaine
: Communications link failure due to underlying exception:
 
** BEGIN NESTED EXCEPTION **
 
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect
 
STACKTRACE:
 
java.net.SocketException: java.net.ConnectException: Connection timed out: conne
ct
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:264)

J'ai cette erreur dans la console de tomcat.

[Mister Nono]

Il semble y avoir un time out : peut-être que le serveur de ta base ne répond pas. Essaye de t'y connecter via un navigateur par exemple car tu utilise mysql.

A+

[yozine]

En fait; le projet struts qui appelle la base contient 2 bases. Je travaille sur un partie de l'appli qui n'utilise qu'une seule des deux bases. Du coup, je n'ai loadé qu'un dump dans le serveur Mysql.

Je pense que ca doit venir du fait qu'une des deux bases n'existe pas.