Thread: [Squirrel-sql-users] How do I set default settings directory?
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: <Ton...@ge...> - 2010-08-25 16:46:21
|
Greetings, I have been using squirrel for some time and we're moving to standardize the installation on all our users to the same settings. This will require that we change the default config directory from C:\Documents and Setting \%USERNAME%\.squirrel-sql to non-unique folder in windows for the image installer. We we're thinking of using C:\SQL_CONFIG\ as out common repository for config updates. I am not entirely sure how to change the default bat file (or the log4j file if necessary) to change this default. I saw the command line changes that are supposed to be used but I am simply not getting the command syntax correct in TMP_PARMS in the bat file. Any ideas? Thanks in advance, Tony Hunt |
From: Cristiano G. <cri...@gm...> - 2010-08-25 23:34:31
|
Hi Tony! On 08/25/2010 06:06 PM, Ton...@ge... wrote: > > Greetings, > (...) > > I saw the command line changes that are supposed to be used but I am simply > not getting the command syntax correct in TMP_PARMS in the bat file. > > Any ideas? Tony, this may not apply to you, but note that there is a longstanding bug in the bat file, where one line defines the TMP_PARMS environment variable and the line that references it calls it TMP_PARAMS (notice the added "A"). Hope this helps! Bye Cris |
From: Philipp B. <Philipp@Boenisch.de> - 2010-08-26 07:34:03
|
Hey Tony, some days ago I asked nearly the same question. My solution for that is an extra batch file, which calls the original one like this: "%PFAD_SQUIRREL%\squirrel-sql.bat" /user-settings-dir %PFAD_KONFIG_LOKAL% But still you will have some problems. Every time when a user close SQuirreL the config files ares saved in the user settings dir. When some users change "their" configuration it is "rolled out" to every user, who starts SQuirreL with the same user settings dir. For that my batch file first copies the SQLAliases23.xml, SQLDrivers.xml and SQLAliases23_treeStructure.xml from the central drive to the users local drive and SQuirreL starts with this local drive. Another advantage is that the user can do whatever he wants, when SQuirreL is restarted the default aliases and drivers are "restored". Also I placed the jdbc driver on the central drive and copy them to the local drive. Afterwards you have to edit SQLDrivers.xml because it contains the path to the jar files. Greetings, Philipp Bönisch 2010/8/25 <Ton...@ge...>: > > Greetings, > > I have been using squirrel for some time and we're moving to standardize > the installation on all our users to the same settings. This will require > that we change the default config directory from C:\Documents and Setting > \%USERNAME%\.squirrel-sql to non-unique folder in windows for the image > installer. > > We we're thinking of using C:\SQL_CONFIG\ as out common repository for > config updates. > > I am not entirely sure how to change the default bat file (or the log4j > file if necessary) to change this default. > > I saw the command line changes that are supposed to be used but I am simply > not getting the command syntax correct in TMP_PARMS in the bat file. > > Any ideas? > > Thanks in advance, > > Tony Hunt > > > ------------------------------------------------------------------------------ > Sell apps to millions through the Intel(R) Atom(Tm) Developer Program > Be part of this innovative community and reach millions of netbook users > worldwide. Take advantage of special opportunities to increase revenue and > speed time-to-market. Join now, and jumpstart your future. > http://p.sf.net/sfu/intel-atom-d2d > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |