pb connexion bdd struts tomcat

**mackab** · 09/05/2007, 17h27

bonjour à tous,

j'ai installé sous DEBIAN tomcat5.5 afin d'utiliser un logiciel qui s'appelle gestcv.
j'ai bien créer une base de données, j'arrive à faire fonctionner tomcat, j'ai mis le fichier.war dans weppaps et je peux voir le dossier gestcv sous tomcat.

le problème viens du fait que lorsque je suis sur la page de gestcv et que j'essai de me connecter, il me met une erreur du type:

type Rapport d'état
message /gestcv-1.0.0/user/
description La ressource demandée (/gestcv-1.0.0/user/) n'est pas disponible.

le log de catalina me renvoie cela:

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
 
DEBUG net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-09 16:23:02,819 - Url demandée : accueil.do 
DEBUG net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-09 16:23:02,819 - UserPrincipal : GenericPrincipal[a(gestcv_admin,gestcv_user,)] 
Hibernate: select user0_.USR_ID_N as COL1_4_, user0_1_.COL_NOM_C as COL2_4_, user0_1_.COL_PRENOM_C as COL3_4_, user0_1_.COL_DATENAISSANCE_D as COL4_4_, user0_1_.COL_LIEUNAISSANCE_C as COL5_4_, user0_1_.COL_PERMISB_B as COL6_4_, user0_1_.COL_EMAIL_C as COL7_4_, user0_1_.COL_DATE_DEBUTCARRIERE_D as COL8_4_, user0_1_.COL_TITRE_C as COL9_4_, user0_1_.COL_UTILISATEURCREATION_C as COL10_4_, user0_1_.COL_DATECREATION_D as COL11_4_, user0_1_.COL_UTILISATEURMODIFICATION_C as COL12_4_, user0_1_.COL_DATEMODIFICATION_D as COL13_4_, user0_1_.COL_ID_AGENCE_N as COL14_4_, user0_1_.COL_ID_SITUATION_FAMILIALE_N as COL15_4_, user0_.USR_LOGIN_C as USR2_5_, user0_.USR_PASSWORD_C as USR3_5_ from T_USER user0_ inner join T_COLLABORATEUR user0_1_ on user0_.USR_ID_N=user0_1_.COL_ID_N where 1=1 and user0_.USR_LOGIN_C=?
ERROR net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-09 16:23:03,155 - Impossible to load user :  
ERROR net.sourceforge.commons.exception.ExceptionHandler 2007-05-09 16:23:03,188 - Erreur inattendue (mapping = ActionConfig[path=/user/accueil,name=userAccueilForm,parameter=dispatch,scope=request,type=net.sourceforge.gestcv.action.user.AccueilAction) 
java.lang.NullPointerException
	at net.sourceforge.gestcv.action.user.AccueilAction.load(AccueilAction.java:29)
	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:585)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	at net.sourceforge.formview.struts.action.FormViewDispatchAction.dispatchMethod(FormViewDispatchAction.java:36)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,310 - Looking up message 'menu.user.link.user_newCV' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,310 - Looking up message 'menu.user.link.user_newCV' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,310 - Looking up message 'menu.user.link.user_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,310 - Looking up message 'menu.user.link.user_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,310 - Looking up message 'menu.user.link.admin_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,311 - Looking up message 'menu.user.link.admin_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,311 - Looking up message 'menu.user.link.logout' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-09 16:23:03,311 - Looking up message 'menu.user.link.logout' in Struts' MessageResources

je vois bien qu il y a un pb de connexion à la bdd mais je ne vois pas du tout comment le résoudre...si quelqu un a une idée...
merci d'avance!

**maxf1** · 23/05/2007, 13h18

Est-ce que ta base correspond a cette requete?

Code :

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

Hibernate: select user0_.USR_ID_N as COL1_4_, user0_1_.COL_NOM_C as COL2_4_, user0_1_.COL_PRENOM_C as COL3_4_, user0_1_.COL_DATENAISSANCE_D as COL4_4_, user0_1_.COL_LIEUNAISSANCE_C as COL5_4_, user0_1_.COL_PERMISB_B as COL6_4_, user0_1_.COL_EMAIL_C as COL7_4_, user0_1_.COL_DATE_DEBUTCARRIERE_D as COL8_4_, user0_1_.COL_TITRE_C as COL9_4_, user0_1_.COL_UTILISATEURCREATION_C as COL10_4_, user0_1_.COL_DATECREATION_D as COL11_4_, user0_1_.COL_UTILISATEURMODIFICATION_C as COL12_4_, user0_1_.COL_DATEMODIFICATION_D as COL13_4_, user0_1_.COL_ID_AGENCE_N as COL14_4_, user0_1_.COL_ID_SITUATION_FAMILIALE_N as COL15_4_, user0_.USR_LOGIN_C as USR2_5_, user0_.USR_PASSWORD_C as USR3_5_ from T_USER user0_ inner join T_COLLABORATEUR user0_1_ on user0_.USR_ID_N=user0_1_.COL_ID_N where 1=1 and user0_.USR_LOGIN_C=?

Donc en gros est-ce c'est hibernate qui a généré cette requete via ta base ou est-ce qu'elle a lu un fichier de mapping dans gestcv qui ne correspond pas à ta base?

**mackab** · 23/05/2007, 17h27

alors, j'ai trouvé un fichier hibernate.cfg.xml qui dit les choses suivantes:

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
 
<?xml version='1.0' encoding='utf-8'?>
 
<!DOCTYPE hibernate-configuration
 
    PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
 
 
<hibernate-configuration>
 
	<session-factory>
 
		<!-- Uncomment this line to use the datasource -->
 
		<!-- BEGIN lines used for the JDBC connection -->
 
		 <property name="hibernate.connection.datasource">java:comp/env/jdbc/gestcv_bd</property> 
 
 
 
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
 
		<property name="hibernate.connection.url">jdbc:mysql://localhost/gestcv?useServerPrepStmts=false</property>
 
		<property name="hibernate.connection.username">root</property>
 
		<property name="hibernate.connection.password">neuneu</property>
 
		<property name="hibernate.connection.pool_size">4</property>
 
 
 
		<!-- END lines used for the JDBC connection -->
 
		<property name="show_sql">true</property>
 
		<property name="use_outer_join">true</property>
 
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>										
 
 
 
		<mapping resource="net/sourceforge/gestcv/bean/Agence.hbm.xml"/>	
 
		<mapping resource="net/sourceforge/gestcv/bean/TableReference.hbm.xml"/>	
 
		<mapping resource="net/sourceforge/gestcv/bean/Domaine.hbm.xml"/>
 
		<mapping resource="net/sourceforge/gestcv/bean/Competence.hbm.xml"/>
 
 
 
		<mapping resource="net/sourceforge/gestcv/bean/Collaborateur.hbm.xml"/>			
 
		<mapping resource="net/sourceforge/gestcv/bean/User.hbm.xml"/>		
 
 
 
		<mapping resource="net/sourceforge/gestcv/bean/RubriqueType.hbm.xml"/>	
 
		<mapping resource="net/sourceforge/gestcv/bean/Rubrique.hbm.xml"/>
 
		<mapping resource="net/sourceforge/gestcv/bean/CollaborateurFormation.hbm.xml"/>
 
		<mapping resource="net/sourceforge/gestcv/bean/CollaborateurCompetence.hbm.xml"/>
 
 
 
 
 
		<mapping resource="net/sourceforge/gestcv/bean/ModeleRTF.hbm.xml"/>								 
 
	</session-factory>
 
</hibernate-configuration>

ca à l'air d'etre la bonne base de données mais ca ne se connecte jamais... impossible de récupérer une valeur dans la base de données...

**maxf1** · 24/05/2007, 16h48

Ce n'est pas ta base de donnée à toi???

Car comme je l'ai dit gestcv est un vieux projet si mes souvenirs sont bon et il est peut-etre et meme très probable qu'il soit out dated. Donc que la base ne soit plus active ou alors que les mots de passe aient changé.

Essaye avec ta propre base de données.

Es-tu sur que tu a as mis le driverJDBC dans le classpath de la webapp?

**mackab** · 24/05/2007, 17h19

alors d'abord je ne suis pas sur que jdbc soit dans le classpath..
en fait j'ai un fichier: spring-jdbc-1.2.6.jar dans le fichier CATALINA_HOME/common/lib
mais faut il que je définnisse dans le cllasspath un chemin vers ce jdbc*.jar?
si oui c'est dans quel fichier de conf qu il faut le faire?

pour la base de données j'ai utilisé celle de gestcv en executant un sript SQL et avec phpmyadmin je vois bien que c'est les meme mot de passe...

**djo.mos** · 24/05/2007, 17h27

Je ne sais pas pour le Spring-jdbc, mais ce que dont tu auras besoin c'est plutôt mysql-connector.jar disponible ici. Tu dois ensuite le mettre dans WEB-INF/lib. Changes aussi hibernate.cfg.xml en mettant la classe du Driver à
org.gjt.mm.mysql.Driver

**mackab** · 24/05/2007, 17h50

bon j'ai rajouté le mysql-connector.jar (il y en avait deja un mais une version plus ancienne)
j'ai changé le driver dans hibernate-struts.xml
j'ai tout relancé et j'ai toujours la même page qui s'affiche..user pas disponible..
par contre l'erreur a changée dans le Catalina.out: "Impossible to load user "

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
24 mai 2007 16:49:54 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/j2sdk1.5-sun/jre/lib/i386/client:/usr/lib/j2sdk1.5-sun/jre/lib/i386:/usr/lib/j2sdk1.5-sun/jre/../lib/i386
24 mai 2007 16:49:54 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
24 mai 2007 16:49:54 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 803 ms
24 mai 2007 16:49:54 org.apache.catalina.core.StandardService start
INFO: Démarrage du service Catalina
24 mai 2007 16:49:54 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
24 mai 2007 16:49:54 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
log4j:WARN No appenders could be found for logger (org.apache.catalina.startup.TldConfig).
log4j:WARN Please initialize the log4j system properly.
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:49:57,768 - Loading form-view rules file from '/WEB-INF/form-view.xml' 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:49:57,826 - Adding Global States => Name : CREATE, Behaviour : READ-WRITE 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:49:57,826 - Adding Global States => Name : READ, Behaviour : READ-ONLY 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:49:57,826 - Adding Global States => Name : UPDATE, Behaviour : READ-WRITE 
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:49:57,835 - Loading validation rules file from '/WEB-INF/validation.xml' 
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:49:57,900 - Loading displayer-config rules file from '/WEB-INF/displayers-config.xml' 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,939 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,948 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,948 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,951 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,951 - Adding Displayer Config => Name : select 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,951 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,951 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,952 - Adding Property  => Name : date 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,952 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,952 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,952 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,952 - Adding Displayer Config => Name : input_text 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,953 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,954 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,954 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,954 - Adding Displayer Config => Name : input_checkbox 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,954 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,955 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,956 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,956 - Adding Displayer Config => Name : input_radio 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,956 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,956 - Adding Displayer Config => Name : input_button 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,957 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,957 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,959 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,960 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,960 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,960 - Adding Displayer Config => Name : input_file 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,960 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,960 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,961 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,962 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,962 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:49:57,962 - Adding Displayer Config => Name : textarea 
INFO net.sourceforge.jsptabcontrol.struts.plugin.JSPTabControlPlugin 2007-05-24 16:50:00,665 - Loading jsptabcontrol-config rules file from '/WEB-INF/jstabcontrol-config.xml' 
24 mai 2007 16:50:01 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Démarrage de Coyote HTTP/1.1 sur http-8080
24 mai 2007 16:50:01 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
24 mai 2007 16:50:01 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/28  config=null
24 mai 2007 16:50:01 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
24 mai 2007 16:50:01 org.apache.catalina.startup.Catalina start
INFO: Server startup in 7425 ms
DEBUG net.sourceforge.jsptabcontrol.struts.plugin.JSPTabControlPlugin 2007-05-24 16:50:08,851 - Destroying FormViewPlugIn 
DEBUG net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:50:08,851 - Destroying FormViewPlugIn 
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:50:49,213 - Loading form-view rules file from '/WEB-INF/form-view.xml' 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:50:49,267 - Adding Global States => Name : CREATE, Behaviour : READ-WRITE 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:50:49,267 - Adding Global States => Name : READ, Behaviour : READ-ONLY 
DEBUG net.sourceforge.formview.FormViewResources 2007-05-24 16:50:49,267 - Adding Global States => Name : UPDATE, Behaviour : READ-WRITE 
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:50:49,276 - Loading validation rules file from '/WEB-INF/validation.xml' 
INFO net.sourceforge.formview.struts.plugin.FormViewPlugIn 2007-05-24 16:50:49,327 - Loading displayer-config rules file from '/WEB-INF/displayers-config.xml' 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,360 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,366 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,366 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,368 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,368 - Adding Displayer Config => Name : select 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,369 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,369 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,369 - Adding Property  => Name : date 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,370 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,370 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,370 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,370 - Adding Displayer Config => Name : input_text 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,370 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,371 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,371 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,371 - Adding Displayer Config => Name : input_checkbox 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,372 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,372 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,373 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,373 - Adding Displayer Config => Name : input_radio 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,374 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,374 - Adding Displayer Config => Name : input_button 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,374 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,374 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,376 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,376 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,377 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,377 - Adding Displayer Config => Name : input_file 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,378 - Adding Property  => Name : required 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,378 - Adding Property  => Name : maxlength 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,378 - Adding Behaviour  => Name : READ-ONLY 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,379 - Adding Behaviour  => Name : INVISIBLE 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,379 - Adding Behaviour  => Name : ERROR 
DEBUG net.sourceforge.formview.displayer.DisplayersConfigResources 2007-05-24 16:50:49,379 - Adding Displayer Config => Name : textarea 
INFO net.sourceforge.jsptabcontrol.struts.plugin.JSPTabControlPlugin 2007-05-24 16:50:51,737 - Loading jsptabcontrol-config rules file from '/WEB-INF/jstabcontrol-config.xml' 
DEBUG net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-24 16:50:57,767 - Url demandée : accueil.do 
DEBUG net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-24 16:50:57,768 - UserPrincipal : GenericPrincipal[b(gestcv_user,)] 
ERROR net.sourceforge.gestcv.action.GestcvRequestProcessor 2007-05-24 16:50:57,770 - Impossible to load user :  
ERROR net.sourceforge.commons.exception.ExceptionHandler 2007-05-24 16:50:57,809 - Erreur inattendue (mapping = ActionConfig[path=/user/accueil,name=userAccueilForm,parameter=dispatch,scope=request,type=net.sourceforge.gestcv.action.user.AccueilAction) 
java.lang.NullPointerException
	at net.sourceforge.gestcv.action.user.AccueilAction.load(AccueilAction.java:29)
	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:585)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	at net.sourceforge.formview.struts.action.FormViewDispatchAction.dispatchMethod(FormViewDispatchAction.java:36)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.user_newCV' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.user_newCV' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.user_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.user_accueil' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.logout' in Struts' MessageResources 
DEBUG net.sourceforge.gestcv.util.menu.displayer.HorizontalMenuDisplayer 2007-05-24 16:50:57,928 - Looking up message 'menu.user.link.logout' in Struts' MessageResources

**mackab** · 24/05/2007, 17h50

je voulais dire hibernate-cfg.xml....
désolé

**djo.mos** · 24/05/2007, 17h54

Veux tu STP nous fournir le code d'AcceuilAction ?

**mackab** · 24/05/2007, 17h58

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
package net.sourceforge.gestcv.action.admin;
 
 
 
import javax.servlet.http.HttpServletRequest;
 
import javax.servlet.http.HttpServletResponse;
 
 
 
import org.apache.struts.action.ActionForm;
 
import org.apache.struts.action.ActionForward;
 
import org.apache.struts.action.ActionMapping;
 
 
 
import net.sourceforge.gestcv.action.GestcvDispatchAction;
 
import net.sourceforge.gestcv.form.admin.AccueilForm;
 
 
 
public class AccueilAction extends GestcvDispatchAction {
 
 
 
	public ActionForward load(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception {
 
		AccueilForm form = (AccueilForm)actionForm;
 
		return display(mapping, actionForm, request, response);
 
	}
 
 
 
	public ActionForward display(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception {
 
 
 
		return mapping.findForward("display");
 
	}
 
}

**mackab** · 24/05/2007, 18h03

oups decidemment je fais que des bétises...
voila le bon AccueilAction:

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
package net.sourceforge.gestcv.action.user;
 
 
 
import java.util.Collection;
 
 
 
import javax.servlet.http.HttpServletRequest;
 
import javax.servlet.http.HttpServletResponse;
 
 
 
import net.sourceforge.commons.displaytag.pagination.PaginatedListImpl;
 
import net.sourceforge.gestcv.action.GestcvDispatchAction;
 
import net.sourceforge.gestcv.dao.criteria.CollaborateurCriteria;
 
import net.sourceforge.gestcv.dto.AgenceDTO;
 
import net.sourceforge.gestcv.dto.UserDTO;
 
import net.sourceforge.gestcv.form.user.AccueilForm;
 
import net.sourceforge.gestcv.service.IAgenceService;
 
import net.sourceforge.gestcv.service.IUserService;
 
import net.sourceforge.gestcv.util.UserUtil;
 
 
 
import org.apache.struts.action.ActionForm;
 
import org.apache.struts.action.ActionForward;
 
import org.apache.struts.action.ActionMapping;
 
 
 
 
 
public class AccueilAction extends GestcvDispatchAction {
 
 
 
		public ActionForward load(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception {
 
			AccueilForm form = (AccueilForm)actionForm;
 
			// Par defaut on positionne le crietere agence sur celui de l'utilisateur connecte
 
			UserDTO userDTO = UserUtil.getGestcvUser();
 
			AgenceDTO agenceDTO = userDTO.getAgence();
 
			if (agenceDTO != null) {
 
				form.setIdAgence(getString(agenceDTO.getId()));
 
			}
 
			return display(mapping, actionForm, request, response);
 
		}
 
 
 
		public ActionForward display(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception {
 
			AccueilForm form = (AccueilForm)actionForm;
 
 
 
			// CHARGEMENT DE LA LISTE DES AGENCES
 
			IAgenceService agenceService = getAgenceService();
 
			Collection agenceList = agenceService.findAllAgence();
 
			request.setAttribute("agenceList", agenceList);
 
 
 
			// CHARGEMENT DE LA LISTE DES MODELES RTF
 
			Collection modeleRTFList = agenceService.findAllModeleRTF();			
 
			request.setAttribute("modeleRTFList", modeleRTFList);
 
 
 
			// CHARGEMENT DE LA LISTE PAGINEES DES COLLABORATEURS SELON LES CRITERES
 
			IUserService userService = getUserService();
 
			String collaborateurListId = "collaborateurList";
 
			PaginatedListImpl paginatedCollaborateurList = PaginatedListImpl.fromRequest(collaborateurListId, request);
 
			// Construction des criteres de recherches
 
			CollaborateurCriteria criteria = new CollaborateurCriteria();
 
			// Critere nom collaborateur
 
			String nom = form.getNomCollaborateur();
 
			if (nom != null && nom.length() > 0)
 
				criteria.setNom(nom);
 
			// Critere prenom collaborateur
 
			String prenom = form.getPrenomCollaborateur();
 
			if (prenom != null && prenom.length() > 0)
 
				criteria.setPrenom(prenom); 
 
			criteria.setIdAgence(getInteger(form.getIdAgence())); // Critere Agence
 
			String nomCompetence = form.getNomCompetence();
 
			if (nomCompetence != null && nomCompetence.length() > 0)
 
				criteria.setNomCompetenceLike(nomCompetence); // Critere Competence
 
			// Recuperation de la liste pagine en filtrant les donnees sur les criteres de recherches
 
			userService.findCollaborateurByCriteria(criteria, paginatedCollaborateurList);
 
			request.setAttribute(collaborateurListId, paginatedCollaborateurList);
 
 
 
			return mapping.findForward("display");
 
		}
 
 
 
}

**djo.mos** · 24/05/2007, 18h06

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
public ActionForward load(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception {
 
			AccueilForm form = (AccueilForm)actionForm;
 
			// Par defaut on positionne le crietere agence sur celui de l'utilisateur connecte
 
			UserDTO userDTO = UserUtil.getGestcvUser();
 
			AgenceDTO agenceDTO = userDTO.getAgence();
 
			if (agenceDTO != null) {
 
				form.setIdAgence(getString(agenceDTO.getId()));
 
			}
 
			return display(mapping, actionForm, request, response);
 
		}

Dans ce bout de code, quelle est la ligne 29 ?

**mackab** · 24/05/2007, 18h09

la ligne 29 correspond à :

Code :

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

AgenceDTO agenceDTO = userDTO.getAgence();

**djo.mos** · 24/05/2007, 18h16

Ton problème vient du fait que UserDTO est null !
UserUtil.getGestcvUser() retourne null !

A toi de voir d'où est ce qu'elle récupère l'utilisateur connecté et pourquoi ce dernier est null !

**mackab** · 24/05/2007, 18h20

merci beaucoup pour ton aide.. j'espère que je vais m'en sortir..
je ne sais pas trop où trouver ca car je n'ai pas codé l'appli, g juste déployé un.war dans tomcat.. mais bon je vais chercher..
encore merci!

pb connexion bdd struts tomcat

Struts 1 Java

Discussions similaires

Partager

Partager