Hi, The settings file is only stored if you change a setting, or after you login.
The command line documentation and the Javadocs are not in the PDF. If you find a way to include it in the PDF, then a patch would be welcome. > I would appreciate to have a sample properties file to get information on how to e.g. setup a different port in it. I think it's quite easy to figure it out by looking at the properties file, and by reading the documentation. Regards, Thomas On Sun, Mar 24, 2013 at 7:40 AM, Ben <[email protected]> wrote: > Ok, thank you. > > The link you mentioned is for connecting from Java to server. > > What about passing a properties file at cmdline in h2.bat? > > I found no tag "-properties" in whole pdf manual. > > When I make a guess and change the line in h2.bat to > > @java -cp "h2-1.3.171.jar;%H2DRIVERS%;%CLASSPATH%" org.h2.tools.Console > -properties ".\myproperties" %* > > ...then no properties file is created in the folder where h2-1.3.171.jar > is located. > Do users have to create this file manually? > > In general I miss the (default) properties file at all after installation > of H2. O.k. by default it should be in > C:\Documents and Settings\[username] > I guess this is only the directory for old WinXP. For (64bit) Win7 it > should be: > > C:\Users\[username]\.h2.server.properties > > But I didn't find the default properties file there neither. > > I would appreciate to have a sample properties file to get information on > how to e.g. setup a different port in it. > When I search the pdf manual for "server.properties" I did NOT find any > info about syntax. > > How does it work? > > Thank you > Ben > > > > > > > On Saturday, March 23, 2013 9:22:56 AM UTC+1, Thomas Mueller wrote: > >> Hi, >> >> The directory where the file is stored / loaded is configurable when >> starting the Server tool with the "-properties" setting. See: >> http://h2database.com/javadoc/**org/h2/tools/Server.html#main_**String.<http://h2database.com/javadoc/org/h2/tools/Server.html#main_String.> >> .. >> >> Regards, >> Thomas >> >> >> >> On Sat, Mar 23, 2013 at 9:14 AM, Ben <[email protected]> wrote: >> >>> As the documentation shows the settings file ".h2.server.properties" is >>> stored by default in the users home directory >>> Under Window in >>> >>> C:\Documents and Settings\[username]. >>> >>> Can I somehow put it into another directory (e.g. the installation >>> directory of H2)? >>> >>> This would mean I have either to pass the new location as cmdline >>> argument to H2 >>> or to setup a (new) enviroment variable like >>> >>> set H2CONFIG=D:\database\H2\.h2.**server.properties >>> >>> Among other considerations I need this to have always a portable H2 >>> version on USB Stick at hand. >>> >>> In best case H2 itself should have internally a search order: >>> >>> 1.) Users home directoryQ >>> 2.) Own installation directory >>> >>> Thank you >>> Ben >>> >>> >>> -- >>> 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 h2-database...@**googlegroups.com. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at >>> http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >>> . >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
