bonjour, j'ai une question concernant le doc de mapping et surtout les requêtes pour alimenter les listes de référérentiel. On a un soucis sur le référentiel des strates et on ne comprend pas pourquoi on ne voit pas 2 strates (Cc3 et Cc4) dans la liste des states. Je suis donc parti du document de mapping pour voir quelles requêtes étaient appliquées pour alimenter la liste et j'ai modifié la conf de log4j pour avoir directement les requêtes HSQL (et non hibernate). Modification de la conf : log4j.logger.org.hibernate.SQL=DEBUG log4j.logger.org.hibernate.type=TRACE J'ai bien récupéré dans les logs les requêtes exécutées (cf plus bas dans mon mail), par contre, ces requêtes ne ramènent rien alors que dans l'écran de saisie j'ai bien une liste de strates. Comment c'est possible ? Je ne vois aucune autre requête exécutée concernant la table location dans les logs. Sinon, est ce que vous pouvez me dire où vous en êtes sur la mise à jour des spécifications ? Merci Christian [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,356 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,357 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,357 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,357 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,357 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,357 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,358 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,359 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,359 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,359 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,359 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [303] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,360 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,360 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,360 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,361 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,361 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,361 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,361 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,361 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,362 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,362 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,366 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,367 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,367 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,367 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,367 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,368 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,368 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,379 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,382 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,382 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,382 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,382 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [303] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,383 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,383 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,383 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,384 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,384 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,384 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,384 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,384 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,385 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,385 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,389 DEBUG org.hibernate.SQL - select locationim0_.ID as col_0_0_, locationim0_.LABEL as col_1_0_, locationim0_.NAME as col_2_0_, locationim0_.STATUS_FK as col_3_0_ from LOCATION locationim0_ cross join LOCATION_HIERARCHY locationhi1_ cross join LOCATION locationim2_ where locationhi1_.PARENT_LOCATION_FK=locationim2_.ID and (locationim0_.STATUS_FK in (? , ?)) and locationim0_.LOCATION_LEVEL_FK=? and locationim0_.LOCATION_CLASSIFICATION_FK=? and locationim0_.ID=locationhi1_.CHILD_LOCATION_FK and locationhi1_.PARENT_LOCATION_FK=? and locationim2_.LOCATION_LEVEL_FK=? [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,390 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,390 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,390 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [INTEGER] - [304] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,390 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [INTEGER] - [2] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,391 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [INTEGER] - [61990] [SwingWorker-pool-2-thread-5] 2015-09-15 11:25:52,391 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [INTEGER] - [301] -- Site Ifremer <http://www.ifremer.fr> Christian BONNET Centre de Brest ZI de la pointe du diable CS 10070 - 29280 Plouzané Département Infrastructures Marines et Numériques (IMN) Unité Informatique et Données Marines (IDM) Service Ingénierie des Systèmes d'Information (ISI) christian.bonnet@ifremer.fr <mailto:christian.bonnet@ifremer.fr> www.ifremer.fr <http://www.ifremer.fr> Tel : +33 (0)2.98.22.46.16 Fax : +33 (0)2.98.22.46.44
