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.

Reply via email to