On May 21, 8:28 am, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> > I would like to try to use H2 db with php using pdo.
>
> With 'pdo' you probably mean Caucho Quercus PDO,
> right?http://www.caucho.com/resin/examples/quercus-pdo/index.xtp
> I'm sorry I have never tested it.
>
Hi and thanks for responding.
I didn't want to use Quercus because it requires Apache Tomcat for its
servlet or compiling a module mod_caucho.so and running it in Apache
server.
I was trying to use standard PHP Data Objects (PDO) extension, which
is built in newer PHP distributions (http://www.php.net/manual/en/
book.pdo.php). It includes PostgreSQL driver, that I wanted to use. H2
database has a PG Server built in, so I figured that these two should
work together. And this is what I tried to do.
Basically, I'm trying to find out what is the purpose of pg server in
h2 database and how to use it, but I can't find any information, and
no matter how I try, I can't figure it out.
> > After googling for many hours I couldn't find any solution, not a
> > single example. And I'm stuck.
> > it asks for password and after typing it (I tried both when the sa
> > account has no password and after setting a password) it throws a
> > message:
> > org.h2.jdbc.jdbcSQLException: Wrong user name or password [8004-112].
> > I am not sure, why is jdbc handling this.
>
> Well, it sounds like the user name or password is wrong. If you rename
> or delete the database files, it should work. I suggest to use a
> password such as "sa". If you don't use a password maybe some of the
> layers replaces that with some kind of default password (just a
> guess). As an alternative, you could you append
> ;TRACE_LEVEL_FILE_OUT=3 to the database URL and try again - this
> should write the user name to the .trace.db file so you can verify it.
>
> Regards,
> Thomas
I'm pretty sure that the password supplied was correct. I would be
glad to use tracing, but I see it is possible to enable it only while
connecting with the URL. I will read the manual to see if there is
another way to enable tracing, as I don't use URL to connect to
database.
Thanks again for an answer.
Regards,
Darek
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
