If I recall, the "jdbc:h2:path" url will accept any username/password you give it and create the database appropriately. You don't have to use the default "sa"/(blank)
On Tue, Oct 20, 2009 at 8:15 PM, Michael Gentry <mgen...@masslight.net> wrote: > An embedded database is one that runs internally instead of requiring > a separate database server. This makes it convenient for standalone > applications. > > For the database connection itself, though, you'd want something like: > > JDBC URL: jdbc:h2:~/mydb > Username: sa > Password: <blank> > > As for PostgreSQL support in H2, I don't know anything about that. Sorry. > > mrg > > > On Tue, Oct 20, 2009 at 8:00 PM, Eric Lazarus <ericllaza...@yahoo.com> wrote: >> Folks >> >> Thanks for you folks direction on using H2 as our database but we are a bit >> stuck on how to do it. We are moving toward using Cayenne 3.0M6 and H2 for >> the desktop version of an application that should be as idiot proof as >> possible. We want for the end user to not have to understand that there is a >> database there at all. >> >> Any suggestions about how we should configure things? For example, should we >> configure H2 to run embedded if we don't want the end user to have to be >> aware of it? How DO we configure it that way? What should we be reading to >> figure out how to do that? I am not even sure we understand what it means to >> run "embeded." Does that mean that that database is in the same VM? That we >> don't go via JDBC at all? >> >> Also, we are trying to load a postgres dump into H2 and am failing because >> H2 does not support the COPY statement. I have tried enabling postgres >> compatibility mode by appending ';MODE=PostgreSQL' to my database url. This >> results in a error message stating 'File not found 'backup.sql'. I tried >> putting my dump in a file by that name and got the same message. >> >> I also tried sticking 'SET MODE PostgreSQL ;' at the top of my SQL dump >> file. This had no effect the script still abended with a syntax error on the >> COPY command. >> >> Where the best place to ask H2 questions? Is there an IRC room? A list serve? >> >> thanks! >> >> Eric >> >> +1 (917) 589-6579 >> >> >> >
