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.
