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.
