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.

Reply via email to