Re: anyone accessing "h2" java database with DBI?

On 05.05.2010 14:24, John Scoles wrote:
> That is what I would say you would have to go with as I could not find 
> a C or C++ interface for it on my quick look at the site.  There must 
> be one someplace though??
Why should there be a C/C++ interface for a Database written entirely in 
Java?

Searching for ODBC on the web site (needs Javascript, else you get a 404 
error), I found the following in 
<http://www.h2database.com/html/advanced.html?highlight=odbc&search=odbc#odbc_driver>:

"This database does not come with its own ODBC driver at this time, but 
it supports the PostgreSQL network protocol. Therefore, the PostgreSQL 
ODBC driver can be used. Support for the PostgreSQL network protocol is 
quite new and should be viewed as experimental. It should not be used 
for production applications."

So, DBD::Pg or DBD::PgPP should be work, with some limitations:

"At this time, only a subset of the PostgreSQL network protocol is 
implemented. Also, there may be compatibility problems on the SQL level, 
with the catalog, or with text encoding. Problems are fixed as they are 
found. Currently, statements can not be canceled when using the PG 
protocol. PostgreSQL ODBC Driver Setup requires a database password; 
that means it is not possible to connect to H2 databases without 
password. This is a limitation of the ODBC driver."

Alexander

>
> cheers
> John
> Alexander Foken wrote:
>> It doesn't seem so. But according to the web page you linked, h2 has 
>> an ODBC driver, so you should be able to use DBD::ODBC. And the web 
>> site shows several JDBC URLs, so there must be a JDBC driver, so you 
>> should be able to use DBD::JDBC.
>>
>> Alexander
>>
>> On 04.05.2010 23:23, David Nicol wrote:
>>> I don't suppose anyone has bothered to construct a DBD for h2?
>>> http://www.h2database.com/html/main.html
>>> the unfortunate choice to name it the same as the level two header
>>> html tag makes it somewhat tricky to search for.
>>>   
>>
>>
>


-- 
Alexander Foken
mailto:[email protected]  http://www.foken.de/alexander/