ODBC

[Carlos Crosetti]

I will be installing the latst jBPM ebgine that comes with H2 - so
later on I would like to query the bpm DB by the means of doing
statnard ODBC connection and exceuting SQL. Whre can I downloa the H2
ODBC driver and a tutotial on how toconfigure a DSN to get into the
jBPM schema?

regards, Carlos

[Thomas Mueller]

Hi,

See the documentation: Advanced / ODBC Driver.

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[Carlos Crosetti]

Is there an ODBC driver for H2?

On Sat, Jun 9, 2012 at 1:14 AM, <h2-da...@googlegroups.com> wrote:

  Today's Topic Summary

Group: http://groups.google.com/group/h2-database/topics

• Sorting with index [5 Updates]
• JdbcConnectionPool [1 Update]

 Sorting with index

Noel Grandin <noelg...@gmail.com> 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 <patrice.h...@gmail.com> 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 <noelg...@gmail.com>
 
 
--
Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site :
http://histoiremondiale.free.fr


 

Petr Holik <hol...@gmail.com> 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 <rami....@gmail.com> Jun 08 07:34PM +0300  

Something I have been also wondering.
 
- rami


 

Noel Grandin <noelg...@gmail.com> 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

Ryan How <rh...@exemail.com.au> 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.
To unsubscribe from this group, send an empty message.
For more options, visit this group.

[Ryan How]

Yes, use postgres odbc driver. See docs

http://www.h2database.com/html/advanced.html#odbc_driver