I have an app, in which I have embedded an instance of H2, and everything's 
working great from the 'inside'

now I'd like to learn how to use the different servers, here's where I am

this works fine:

Connection cnx = DriverManager.getConnection(connectionString);
Server.startWebServer(cnx);

but I'd like to wind up with an instance of the server, to check status, 
shut it down, etc, which this method doesnt return

so I tried this:

Server server = Server.createWebServer(new String[]{"-trace"});
server.start();
Server.openBrowser(server.getURL());
System.out.println("server status:" + server.getStatus());

this doesnt work, and as far as I can tell, the problem is driver not 
found, and the solution is to modify the user's classpath so the driver can 
be found... true? this doesnt seem correct...

meanwhile, I also tried this:

Server server = Server.createTcpServer(new String[]{"-tcpPort", "9090", 
"-tcpAllowOthers"});
server.start();

which works, mostly... the goal is to then connect w/ any third party 
client that supports jdbc, like razor, or squirrel. I am able to connect, 
but when I do, I dont see my database, just the system tables, etc. it's as 
though it's not finding my database despite what look like correct urls

do I use relative or absolute paths in the url? is this form reliable 
"~/dbfolder/dbname" reliable on mac os?

and given that my database name is "fred", the corresponding file is named 
"fred.h2.db" -- is this what I should use in the url? doesnt seem like it 
from the examples, but I'm stuck so I'm trying everything

any thoughts?  

thanks for your help







-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to