I try to understand the results of the google "java thread dump" but i
do'nt (my english is really poor)

yet I see that this new request give the same thing

*SELECT id FROM limes WHERE id in (SELECT id_limes FROM pourtours_limes)*

Console
5072 rows, 249 ms

In a java program : very long (don't give a result after 1 minute)

But this request

*SELECT id FROM limes WHERE id in (SELECT DISTINCT id_limes FROM
pourtours_limes)*
*
*
Console
5072 rows, 8 ms

In a java program
154 ms

So I think the problem is solved and came from a bad building of my request
: id must be distinct.


2013/1/4 Noel Grandin <[email protected]>

> Google it.
> "java thread dump"
>
>
> On Fri, Jan 4, 2013 at 5:49 PM, Patrice Henrio <
> [email protected]> wrote:
>
>> 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.
>>
>
>  --
> 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