impossible se connecter a une datasource

**sajedose** · 07/04/2008, 16h57

salut chers développeurs
s'il vous plait si quelqu'un a une idée sur l'exception suivante :

Etat HTTP 500 - Exception sur l'accès à la BDD org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu )

type Rapport d'état

message Exception sur l'accès à la BDD org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu )

description Le serveur a rencontré une erreur interne (Exception sur l'accès à la BDD org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu )) qui l'a empêché de satisfaire la requête.
Apache Tomcat/5.0.28

j'essaye de me connecter à oracle a travers une datasource créer sous le serveur tomcat

voila mon server.xml

Code xml :

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
Resource name="jdbc/TutoPool" type="javax.sql.DataSource"/>
    <Resource auth="Container" description="User database that can be updated and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
    <ResourceParams name="jdbc/TutoPool">
      <parameter>
        <name>validationQuery</name>
        <value>SELECT 1</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:oracle:thin:@localhost:1521:OPERA</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>opera</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>8</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>10000</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>oracle.jdbc.OracleDriver</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>opera</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>8</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>

merci de bien m'aider

**khattat** · 07/04/2008, 19h22

salut,
essayer de mettre la définition du source de données dans le fichier context.xml(emplacement <TOMCAT_HOME>/conf/context.xml)

**Jacques - 06** · 08/04/2008, 08h03

Au vu du message, tu es connecté à la base de données (Oracle) car le message d'erreur est renvoyé par celle-ci (ORA-0923). Le problème vient de la requête SQL que tu essayes d'exécuter et qui n'est pas syntaxiquement correcte, comme le décrit le message.

le problème vient de ton paramètre

Code :

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

1
2
<name>validationQuery</name>
<value>SELECT 1</value>

"Select 1" n'est pas valide, remplace par

Code :

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

SELECT dummy from dual

Jacques Desmazières

**sajedose** · 08/04/2008, 12h35

merci merci maintenant le message d'erreur est maintenant de type :

Code :

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

1
2
 
Etat HTTP 500 - Exception sur l'accès à la BDD org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

j'avance comme même !!!

merci de bien m'aider merci beaucoup

**Jacques - 06** · 08/04/2008, 12h44

Peux-tu poster la stack complète (voir dans les logs Tomcat) ?

Jacques Desmazières

**sajedose** · 08/04/2008, 13h17

oui voici la trace d'erreur de mon fichier log

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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
 
2008-04-08 11:03:11 StandardHost[localhost]: Erreur lors du déploiement de l'application pour le chemin de contexte null
java.lang.IllegalArgumentException: Le chemin de contexte est requis
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
	at org.apache.commons.digester.Digester.endElement(Digester.java:1061)
	at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.commons.digester.Digester.parse(Digester.java:1567)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
	at org.apache.catalina.startup.HostConfig.checkContextLastModified(HostConfig.java:800)
	at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1085)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:327)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.StandardHost.backgroundProcess(StandardHost.java:800)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1619)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1628)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1608)
	at java.lang.Thread.run(Thread.java:619)
 
2008-04-08 11:04:43 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@7616ad')
2008-04-08 11:04:43 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@caf083')
2008-04-08 11:04:43 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@1742dfe')
2008-04-08 11:04:43 StandardContext[/servlets-examples]SessionListener: contextDestroyed()
2008-04-08 11:04:43 StandardContext[/servlets-examples]ContextListener: contextDestroyed()
2008-04-08 11:04:43 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@1b493c6')
2008-04-08 11:04:43 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@51e67c')
2008-04-08 11:04:43 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@f2da21')
2008-04-08 11:04:43 StandardContext[/jsp-examples]SessionListener: contextDestroyed()
2008-04-08 11:04:43 StandardContext[/jsp-examples]ContextListener: contextDestroyed()
2008-04-08 11:04:49 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
2008-04-08 11:04:49 StandardContext[/jsp-examples]ContextListener: contextInitialized()
2008-04-08 11:04:49 StandardContext[/jsp-examples]SessionListener: contextInitialized()
2008-04-08 11:04:49 StandardContext[/servlets-examples]ContextListener: contextInitialized()
2008-04-08 11:04:49 StandardContext[/servlets-examples]SessionListener: contextInitialized()
2008-04-08 11:04:49 StandardHost[localhost]: Erreur lors du déploiement de l'application pour le chemin de contexte null
java.lang.IllegalArgumentException: Le chemin de contexte est requis
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
	at org.apache.commons.digester.Digester.endElement(Digester.java:1061)
	at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.commons.digester.Digester.parse(Digester.java:1567)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
	at org.apache.catalina.core.StandardService.start(StandardService.java:480)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
 
2008-04-08 11:04:50 StandardContext[/manager]HTMLManager: init: Associated with Deployer 'localhost'
2008-04-08 11:04:50 StandardContext[/manager]HTMLManager: init: Global resources are available
2008-04-08 11:04:50 StandardContext[/manager]HTMLManager: list: Listing contexts for virtual host 'localhost'
2008-04-08 11:05:02 StandardContext[/TutoPool]La servlet TutoPool est marqué comme indisponible
2008-04-08 11:10:10 StandardHost[localhost]: Erreur lors du déploiement de l'application pour le chemin de contexte null
java.lang.IllegalStateException: Le chemin de contexte /opera est déjà utilisé
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
	at org.apache.commons.digester.Digester.endElement(Digester.java:1061)
	at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.commons.digester.Digester.parse(Digester.java:1567)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
	at org.apache.catalina.startup.HostConfig.checkContextLastModified(HostConfig.java:800)
	at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1085)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:327)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.StandardHost.backgroundProcess(StandardHost.java:800)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1619)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1628)
	at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1608)
	at java.lang.Thread.run(Thread.java:619)
 
2008-04-08 11:10:12 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@3a0ab1')
2008-04-08 11:10:12 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@940f82')
2008-04-08 11:10:12 StandardContext[/servlets-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@864e43')
2008-04-08 11:10:12 StandardContext[/servlets-examples]SessionListener: contextDestroyed()
2008-04-08 11:10:12 StandardContext[/servlets-examples]ContextListener: contextDestroyed()
2008-04-08 11:10:12 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@15bfdbd')
2008-04-08 11:10:12 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@6f8b2b')
2008-04-08 11:10:12 StandardContext[/jsp-examples]ContextListener: attributeReplaced('org.apache.catalina.WELCOME_FILES', '[Ljava.lang.String;@119e583')
2008-04-08 11:10:12 StandardContext[/jsp-examples]SessionListener: contextDestroyed()
2008-04-08 11:10:12 StandardContext[/jsp-examples]ContextListener: contextDestroyed()
2008-04-08 11:10:17 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
2008-04-08 11:10:17 StandardContext[/jsp-examples]ContextListener: contextInitialized()
2008-04-08 11:10:17 StandardContext[/jsp-examples]SessionListener: contextInitialized()
2008-04-08 11:10:18 StandardContext[/servlets-examples]ContextListener: contextInitialized()
2008-04-08 11:10:18 StandardContext[/servlets-examples]SessionListener: contextInitialized()
2008-04-08 11:10:18 StandardHost[localhost]: Erreur lors du déploiement de l'application pour le chemin de contexte null
java.lang.IllegalStateException: Le chemin de contexte /opera est déjà utilisé
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
	at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
	at org.apache.commons.digester.Digester.endElement(Digester.java:1061)
	at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76)
	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.commons.digester.Digester.parse(Digester.java:1567)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:863)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
	at org.apache.catalina.core.StandardService.start(StandardService.java:480)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
 
2008-04-08 11:10:19 StandardContext[/manager]HTMLManager: init: Associated with Deployer 'localhost'
2008-04-08 11:10:19 StandardContext[/manager]HTMLManager: init: Global resources are available
2008-04-08 11:10:19 StandardContext[/manager]HTMLManager: list: Listing contexts for virtual host 'localhost'
2008-04-08 11:10:21 StandardContext[/manager]HTMLManager: list: Listing contexts for virtual host 'localhost'
2008-04-08 11:10:21 StandardContext[/manager]HTMLManager: list: Listing contexts for virtual host 'localhost'
2008-04-08 11:13:59 StandardContext[/TutoPool]La servlet TutoPool est marqué comme indisponible

impossible se connecter a une datasource

Tomcat et TomEE Java

Vue hybride

Discussions similaires

Partager

Partager