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.
