RE: [Squirrel-sql-develop] Tech Support Gave Up On SquirreL

[Colin B. <Col...@as...>]

Hi,

> I have been using SQuirreL for the last few months and gave a shot at 
> advocacy by trying to convince techSupport/helpDesk to use SQuirreL for 
> users who needed a SQl tool as opposed to some $$$$ alternatives.

Exactly what I like to hear :-)

> While the first might seem odd it really isnt. When they did install the
1.4 
> jre on some machines it ended up by default setting itself up as the
plugin 
> for IE. This broke some old internal apps that used the default jre
supplied 
> with IE and Netscape. They ended up solving the issues but it caused a 
> headache.
> Is there any way that SQuirreL can be shipped with a JRE that doesn't 
> install? Meaning a JRE that would just be in the SQuirreL bin dir and just

> be used for SQuirreL? This would obviously be a much larger DL (obviously 
> SQurreL should be avail without a bundled JRE as well) but would make it 
> much simpler to install.

This isn't something I want to do as it complicates the release process and
I don't have enough time to work on SQuirreL as it is. Nor do I believe that
applications should be installing multiple versions of VMs on PCs, you can
end up in quite a mess.

When the JRE is installed you can specify which browsers you want the java
plugin to be used by. All your tech support has to do is to change it not to
specify IE or Netscape. Or after the install they can use the control panel
to change the default VM back to what it is originally. Here at my work
these kinds of settings are locked down so that if I change them they get
changed back to what they should be automatically.

> The second one I can't argue with because I dont know what setup they are 
> using for other tools. To me setting it up seemed easy (was a while ago so
I 
> dont fully remember the details) but it seemingly has to be simplified.
Its 
> possible that it was setting up drivers etc that isnt necessary for other 
> non java based tools.
> Is there a way this can be simplified?

Without knowing what it is they found complicated I cannot really answer the
question however this may help.

Theres two pieces of config requried to connect to a database.

1. Point the driver definition to the driver jars.

2. Create an alias.

For the driver definition if the JDBC drivers are installed in the
%CLASSPATH% (Windows) or $CLASSPATH (Unix/Linux) or if they have been copied
to the jre/lib/ext directory then no configuration of the SQuirreL driver
definition is necessary. SQuirreL will just use the drivers. In fact any
Java application on the PC will be able to use the drivers.

Theres no getting around point 2, however it can be simplified. Install
SQuirreL on a PC and create the aliases that you want everybody to have
access to. I assume that the installer for SQuirreL would be on a network
share so copy up the file <users home>/.squirrel-sql/SQLAliases.xml to the
network share. Then install SQuirreL on a second PC. Copy the file
SQLAliases.xml from the network share to the same place on the second PC. A
simple batch file or shell script could take care of this.

Col

-----Original Message-----
From: L Rutker [mailto:lr...@ho...]
Sent: Sunday, 22 June 2003 14:50
To: squ...@li...
Subject: [Squirrel-sql-develop] Tech Support Gave Up On SquirreL


Hi,
I have been using SQuirreL for the last few months and gave a shot at 
advocacy by trying to convince techSupport/helpDesk to use SQuirreL for 
users who needed a SQl tool as opposed to some $$$$ alternatives.
They gave it a try but gave up.
Here were the reasons:
a) needs an up to date jvm
b) config issues.

While the first might seem odd it really isnt. When they did install the 1.4

jre on some machines it ended up by default setting itself up as the plugin 
for IE. This broke some old internal apps that used the default jre supplied

with IE and Netscape. They ended up solving the issues but it caused a 
headache.
Is there any way that SQuirreL can be shipped with a JRE that doesn't 
install? Meaning a JRE that would just be in the SQuirreL bin dir and just 
be used for SQuirreL? This would obviously be a much larger DL (obviously 
SQurreL should be avail without a bundled JRE as well) but would make it 
much simpler to install.
The second one I can't argue with because I dont know what setup they are 
using for other tools. To me setting it up seemed easy (was a while ago so I

dont fully remember the details) but it seemingly has to be simplified. Its 
possible that it was setting up drivers etc that isnt necessary for other 
non java based tools.
Is there a way this can be simplified?

Lou

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus



-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
Squirrel-sql-develop mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop