Is there an ODBC driver for H2? On Sat, Jun 9, 2012 at 1:14 AM, <[email protected]> wrote:
> Today's Topic Summary > > Group: http://groups.google.com/group/h2-database/topics > > - Sorting with index <#137cf73cdb9e3f30_group_thread_0> [5 Updates] > - JdbcConnectionPool <#137cf73cdb9e3f30_group_thread_1> [1 Update] > > Sorting with > index<http://groups.google.com/group/h2-database/t/dda37e867b15b3b8> > > Noel Grandin <[email protected]> Jun 08 01:56PM +0200 > > H2 doesn't support stepping through an index backwards, you would need > to create a reverse index to support that. > > Something like : > > create index idx_id_desc on test(id desc) > > > On 2012-06-07 16:04, Petr Holik wrote: > > > > > patrice henrio <[email protected]> Jun 08 02:10PM +0200 > > I can give my experience (not big, 2 or 3 M) with à complex > request sorting on a column : without index more than 15 minutes, with > index 7 seconds. > > 2012/6/8 Noel Grandin <[email protected]> > > > -- > Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site : > http://histoiremondiale.free.fr > > > > > Petr Holik <[email protected]> Jun 08 09:11AM -0700 > > Hello Noel, > thanks for, reply your sugestion works. BUT > I do not see the reason why H2 does not support this? Binary tree > which is > used in H2 can support stepping backward and forward, am I right? > Should not be this enhancement request? It is very often request in > web > application that user can user sort data ASC or DESC... > > Or there should be updated documentation in crate index syntax. There > is no > word about fact that index can be crated on DESC column. > > Petr > > On Friday, June 8, 2012 1:56:45 PM UTC+2, Noel Grandin wrote: > > > > > Rami Ojares <[email protected]> Jun 08 07:34PM +0300 > > Something I have been also wondering. > > - rami > > > > > Noel Grandin <[email protected]> Jun 08 10:03PM +0200 > > > Should not be this enhancement request? It is very often request in > web > > application that user can user sort data ASC or DESC... > > Patches are welcome, the code is open-source..... > > > Or there should be updated documentation in crate index syntax. > There is no > > word about fact that index can be crated on DESC column. > > I will see what I can do about updating the documentation, > > > > > JdbcConnectionPool<http://groups.google.com/group/h2-database/t/d8230f16cec77920> > > Ryan How <[email protected]> Jun 08 02:57PM +0800 > > Thanks, I'll just have to be careful that all connections are closed. > I've got a web app that has a connection per request and closes them > at > the end, but for some background tasks it doesn't use that framework. > Maybe I should implement some kind of thread factory which makes sure > the connection is cleaned up when the thread ends, and deny a > connection > being given unless it is for a thread that is part of that thread > group. > > On 8/06/2012 5:30 AM, Nate Sammons wrote: > > > > You received this message because you are subscribed to the Google Group > h2-database. > You can post via email <[email protected]>. > To unsubscribe from this group, > send<[email protected]>an empty message. > For more options, > visit<http://groups.google.com/group/h2-database/topics>this group. > > -- > 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.
