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... > > Regards, > Thomas > > > > On Sat, Mar 23, 2013 at 9:14 AM, Ben <[email protected] <javascript:>>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 [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
