Aha, I must have missed this: "Starting the server doesn't open a database - databases are opened as soon as a client connects.", this makes absolutly no sense to me - why should the client define the database and the db properties? - but, ok its working that way and it works fine. Since I have a lot of code in pljava DEFAULT_CONNECTION is a compatibility trick. In oralce or postgres stored java funcions you have do access your database with a jdbc connection string like jdbc:default:connection. To get such a connection in H2 you have to enable this feature.
Thanks Chris On 14 Dez., 23:34, LRichard <[email protected]> wrote: > 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. > > OK. Your server is up. > Now, you can use an URL like jdbc:h2:tcp://<server_ip>:9999/prod to connect > to your database. > Sorry for the DEFAULT_CONNECTION, I don't really get what this property may > be useful for... -- 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.
