Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-18 Thread Thomas Mueller
Hi, > I want to build a stand alone server (one big jar holding my pljava classes > and a java Main class which will start the tcp server, the webserver and > queing deamon, which is part of my application). Do you actually need the server mode? Do you have a client application that connects to

Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-15 Thread Peter Yuill
Hi Chris, 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. To

Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-14 Thread Christian123456789
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 l

Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-14 Thread LRichard
Ok, help me out. I want a server running a database named "prod" > running on port 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 - >

Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-14 Thread Christian123456789
> 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

Re: H2 in Servermode Url,File,Port,Parameters Question

2011-12-14 Thread LRichard
Have a look at http://www.h2database.com/html/tutorial.html#using_server. The org.h2.tools.Server class is in charge of exposing the server. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.

H2 in Servermode Url,File,Port,Parameters Question

2011-12-14 Thread Christian123456789
Hi I am very new to H2 but I realy like the <>. Since I am havily using Postgres and pljava (and having a lot of troubles with them), I am thinking about switching to H2. But there is my first Question ... I was not able to figure out how I can start a H2 server by defining the following paramete