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.

Reply via email to