Discussion :

[montis]

Bonjour

Je suis en train de lire le livre Spring par la pratique 1.2 et 2.0 bref il nous demande d'installer le site open source "Tudu lists" dont les archives se trouvent dans le site de l’éditeur il y en a 5 (Tudu-WebFlow.zip, Tudu-Client.zip, Tudu-SpringMVC.zip, Tudu-Portlet.zip, Tudu.zip) bref dans le livre il nous demande d’exécuter le projet Tudu-SpringMVC.zip aprés l'avoir installé bien sur bref j'utilise eclipse kepler avec tomcat7 et jdk 1.7.

Lors de l'execution du projet tout se passe bien la page d'accueil s'affiche de façon normale mais quand j'essaye de me connecter avec le pseudo et le mot de passe qui sont donnés dans le livre j'ai cette erreur :

Code :

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

1
2
3
4
5
6
7
8
34737 [http-bio-8080-exec-8] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error: -22, SQLState: S0002
11:26:27,136 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
34738 [http-bio-8080-exec-8] ERROR org.hibernate.util.JDBCExceptionReporter  - Table not found in statement [select user0_.login as login3_, user0_.password as password3_3_, user0_.first_name as first3_3_3_, user0_.last_name as last4_3_3_, user0_.email as email3_3_, user0_.enabled as enabled3_3_, user0_.creation_date as creation7_3_3_, user0_.last_access_date as last8_3_3_, roles1_.login as login5_, role2_.role as role5_, role2_.role as role0_, todolists3_.login as login6_, todolist4_.id as listId6_, todolist4_.id as id1_, todolist4_.name as name1_1_, todolist4_.rss_allowed as rss3_1_1_, todos5_.todo_list_id as todo7_7_, todos5_.id as id7_, todos5_.id as id2_, todos5_.creation_date as creation2_0_2_, todos5_.description as descript3_0_2_, todos5_.completion_date as completion4_0_2_, todos5_.priority as priority0_2_, todos5_.due_date as due6_0_2_, todos5_.todo_list_id as todo7_0_2_, todos5_.completed as completed0_2_ from user user0_ left outer join user_role roles1_ on user0_.login=roles1_.login left outer join role role2_ on roles1_.role=role2_.role left outer join user_todo_list todolists3_ on user0_.login=todolists3_.login left outer join todo_list todolist4_ on todolists3_.listId=todolist4_.id left outer join todo todos5_ on todolist4_.id=todos5_.todo_list_id where user0_.login=? order by todos5_.description asc]
11:26:27,137 ERROR [JDBCExceptionReporter] Table not found in statement [select user0_.login as login3_, user0_.password as password3_3_, user0_.first_name as first3_3_3_, user0_.last_name as last4_3_3_, user0_.email as email3_3_, user0_.enabled as enabled3_3_, user0_.creation_date as creation7_3_3_, user0_.last_access_date as last8_3_3_, roles1_.login as login5_, role2_.role as role5_, role2_.role as role0_, todolists3_.login as login6_, todolist4_.id as listId6_, todolist4_.id as id1_, todolist4_.name as name1_1_, todolist4_.rss_allowed as rss3_1_1_, todos5_.todo_list_id as todo7_7_, todos5_.id as id7_, todos5_.id as id2_, todos5_.creation_date as creation2_0_2_, todos5_.description as descript3_0_2_, todos5_.completion_date as completion4_0_2_, todos5_.priority as priority0_2_, todos5_.due_date as due6_0_2_, todos5_.todo_list_id as todo7_0_2_, todos5_.completed as completed0_2_ from user user0_ left outer join user_role roles1_ on user0_.login=roles1_.login left outer join role role2_ on roles1_.role=role2_.role left outer join user_todo_list todolists3_ on user0_.login=todolists3_.login left outer join todo_list todolist4_ on todolists3_.listId=todolist4_.id left outer join todo todos5_ on todolist4_.id=todos5_.todo_list_id where user0_.login=? order by todos5_.description asc]
34738 [http-bio-8080-exec-8] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error: -22, SQLState: S0002
11:26:27,137 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
34739 [http-bio-8080-exec-8] ERROR org.hibernate.util.JDBCExceptionReporter  - Table not found in statement [select user0_.login as login3_, user0_.password as password3_3_, user0_.first_name as first3_3_3_, user0_.last_name as last4_3_3_, user0_.email as email3_3_, user0_.enabled as enabled3_3_, user0_.creation_date as creation7_3_3_, user0_.last_access_date as last8_3_3_, roles1_.login as login5_, role2_.role as role5_, role2_.role as role0_, todolists3_.login as login6_, todolist4_.id as listId6_, todolist4_.id as id1_, todolist4_.name as name1_1_, todolist4_.rss_allowed as rss3_1_1_, todos5_.todo_list_id as todo7_7_, todos5_.id as id7_, todos5_.id as id2_, todos5_.creation_date as creation2_0_2_, todos5_.description as descript3_0_2_, todos5_.completion_date as completion4_0_2_, todos5_.priority as priority0_2_, todos5_.due_date as due6_0_2_, todos5_.todo_list_id as todo7_0_2_, todos5_.completed as completed0_2_ from user user0_ left outer join user_role roles1_ on user0_.login=roles1_.login left outer join role role2_ on roles1_.role=role2_.role left outer join user_todo_list todolists3_ on user0_.login=todolists3_.login left outer join todo_list todolist4_ on todolists3_.listId=todolist4_.id left outer join todo todos5_ on todolist4_.id=todos5_.todo_list_id where user0_.login=? order by todos5_.description asc]
11:26:27,138 ERROR [JDBCExceptionReporter] Table not found in statement [select user0_.login as login3_, user0_.password as password3_3_, user0_.first_name as first3_3_3_, user0_.last_name as last4_3_3_, user0_.email as email3_3_, user0_.enabled as enabled3_3_, user0_.creation_date as creation7_3_3_, user0_.last_access_date as last8_3_3_, roles1_.login as login5_, role2_.role as role5_, role2_.role as role0_, todolists3_.login as login6_, todolist4_.id as listId6_, todolist4_.id as id1_, todolist4_.name as name1_1_, todolist4_.rss_allowed as rss3_1_1_, todos5_.todo_list_id as todo7_7_, todos5_.id as id7_, todos5_.id as id2_, todos5_.creation_date as creation2_0_2_, todos5_.description as descript3_0_2_, todos5_.completion_date as completion4_0_2_, todos5_.priority as priority0_2_, todos5_.due_date as due6_0_2_, todos5_.todo_list_id as todo7_0_2_, todos5_.completed as completed0_2_ from user user0_ left outer join user_role roles1_ on user0_.login=roles1_.login left outer join role role2_ on roles1_.role=role2_.role left outer join user_todo_list todolists3_ on user0_.login=todolists3_.login left outer join todo_list todolist4_ on todolists3_.listId=todolist4_.id left outer join todo todos5_ on todolist4_.id=todos5_.todo_list_id where user0_.login=? order by todos5_.description asc]

Voila est ce que vous pouvez m'aider svp ?

Cordialement

[Tcharl]

Bonjour,

Tu dois avoir un fichier .sql dans un des zip (certainement Tudu.zip). Il s'agit d'un dump à exécuter sur ta base de données qui va créer les tables permettant de persister tes données.

[montis]

Bonjour Tcharl

Et bien j'ai pas trouvé de fichier .sql !

[Tcharl]

As-tu un fichier persistence.xml ou un fichier spring dans ton module DAO?

Si oui, il faut vérifier que la notion create-schema et create db sont à true.
Malheureusement la notation dépend du provider (hibernate, openjpa, eclipselink...).