Yes, use postgres odbc driver. See docs
http://www.h2database.com/html/advanced.html#odbc_driver
On 10/06/2012 12:13 AM, Carlos Crosetti wrote:
Is there an ODBC driver for H2?
On Sat, Jun 9, 2012 at 1:14 AM, <[email protected]
<mailto:[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]
<mailto:[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]
<mailto:[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]
<mailto:[email protected]>>
--
Si vous vous intéressez à l'histoire, vous pouvez parcourir
mon site :
http://histoiremondiale.free.fr
Petr Holik <[email protected] <mailto:[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]
<mailto:[email protected]>> Jun 08 07:34PM +0300
Something I have been also wondering.
- rami
Noel Grandin <[email protected]
<mailto:[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] <mailto:[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 <mailto:[email protected]>.
To unsubscribe from this group, send
<mailto:[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]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:h2-database%[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.
--
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.
