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:alexan...@foken.de http://www.foken.de/alexander/
