Re: [Squirrel-sql-users] How do I set default settings directory?

[Philipp B. <Philipp@Boenisch.de>]

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
>