I try to understand the results of the google "java thread dump" but i do'nt (my english is really poor)
yet I see that this new request give the same thing *SELECT id FROM limes WHERE id in (SELECT id_limes FROM pourtours_limes)* Console 5072 rows, 249 ms In a java program : very long (don't give a result after 1 minute) But this request *SELECT id FROM limes WHERE id in (SELECT DISTINCT id_limes FROM pourtours_limes)* * * Console 5072 rows, 8 ms In a java program 154 ms So I think the problem is solved and came from a bad building of my request : id must be distinct. 2013/1/4 Noel Grandin <[email protected]> > Google it. > "java thread dump" > > > On Fri, Jan 4, 2013 at 5:49 PM, Patrice Henrio < > [email protected]> wrote: > >> i do'nt know how to do that. >> >> >> 2013/1/4 Thomas Mueller <[email protected]> >> >>> Hi, >>> >>> If it's blocked, could you get a full thread dump to find out what it's >>> doing? >>> >>> Regards, >>> Thomas >>> >>> >>> >>> On Fri, Jan 4, 2013 at 3:15 PM, Patrice <[email protected]>wrote: >>> >>>> Sorry for my english. >>>> I integrate H2 in a program. >>>> I use this command >>>> *SELECT id FROM limes WHERE * >>>> *id NOT IN (SELECT id_limes FROM pourtours_limes) AND* >>>> *id NOT IN (SELECT id_limes FROM dessins_fleuves);* >>>> In console mode the result is obtained in 470 ms >>>> >>>> When I use in a program by these line >>>> *String txtRequeteLimes = "SELECT id FROM limes WHERE " +* >>>> * "id NOT IN (SELECT id_limes FROM >>>> pourtours_limes) AND " +* >>>> * "id NOT IN (SELECT id_limes FROM >>>> dessins_fleuves)";* >>>> *ResultSet resLimes = >>>> connexionCourante().prepareStatement(txtRequeteLimes).executeQuery(); >>>> * >>>> * >>>> * >>>> where connexionCourante() return *DriverManager.getConnection >>>> (urlBase, nomUtilisateur, motDePasse) ;* >>>> * >>>> * >>>> The request can't end. >>>> >>>> The parameters are good because I test with another request. >>>> But why a good request in console mode is bad in a program ? >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "H2 Database" group. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msg/h2-database/-/l7olDeoCnTEJ. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/h2-database?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/h2-database?hl=en. >>> >> >> >> >> -- >> Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site : >> http://histoiremondiale.free.fr >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site : http://histoiremondiale.free.fr -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
