> Have a look at http://www.h2database.com/html/tutorial.html#using_server.
Thanks, of course I have read this - but this is not as self explanory as you may think :-) As you can see there is no switch for "Database" and no switch for connection options like "DEFAULT_CONNECTION=TRUE" ... the only swich accepting an url is "shutdown" ... so there must be a way even in java to set properties. I can not beleve that all things are hard coded :-) Options are case sensitive. Supported options are: [-help] or [-?] Print the list of options [-web] Start the web server with the H2 Console [-webAllowOthers] Allow other computers to connect - see below [-webDaemon] Use a daemon thread [-webPort <port>] The port (default: 8082) [-webSSL] Use encrypted (HTTPS) connections [-browser] Start a browser connecting to the web server [-tcp] Start the TCP server [-tcpAllowOthers] Allow other computers to connect - see below [-tcpDaemon] Use a daemon thread [-tcpPort <port>] The port (default: 9092) [-tcpSSL] Use encrypted (SSL) connections [-tcpPassword <pwd>] The password for shutting down a TCP server [-tcpShutdown "<url>"] Stop the TCP server; example: tcp://localhost [-tcpShutdownForce] Do not wait until all connections are closed [-pg] Start the PG server [-pgAllowOthers] Allow other computers to connect - see below [-pgDaemon] Use a daemon thread [-pgPort <port>] The port (default: 5435) [-properties "<dir>"] Server properties (default: ~, disable: null) [-baseDir <dir>] The base directory for H2 databases (all servers) [-ifExists] Only existing databases may be opened (all servers) [-trace] Print additional trace information (all servers) The options -xAllowOthers are potentially risky. Ok, help me out. I want a server running a database named "prod" running on port 9999 which uses DEFAULT_CONNECTION. The File containing the data should be in C:\H2\Databases\ For now I can start a server like this: java -cp h2-1.3.162.jar org.h2.tools.Server -web -tcp -tcpPort 9999 - baseDir C:/H2/Databases But there are 2 things still missing. Use a Database other than "test" and enable the default_connection. Thanks Chris -- 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.
