Answers - SQuirreL SQL Client.
Plugins and drivers are two different types
of software. A driver allows you to connect to a particular database
(Oracle, Sybase, DB2, etc.) We cannot legally ship most drivers with
SQuirreL (in the installer or from the update site) as they are
proprietary and most database vendors require users to download them
directly from their website.
Plugins are another piece of software whose purpose is to enhance
SQuirreL's ability to render and work with objects that are stored
in the database after a connection is made. Some plugins are
database-specific and are named according to the database that they
are activated for. When start a session in SQuirreL, if the plugin
that corresponds with that database type is installed, it will be
activated when a connection is made and SQuirreL will have more
capabilities than without that plugin installed and activated.
There are other plugins, that are not database-specific (for
example, graph, codecompletion, syntax highlighting, etc.) that
are activated regardless of the type of database, if they have
been installed. If you choose "standard" and no "optional"
plugins when prompted by the installer, then you get a useful
subset of plugins that are helpful regardless of the database type.
You can check to see which plugins you have installed by opening
up the plugin status table (Plugins -> Summary), or by looking
in the <SQUIRREL_INSTALL_DIR>/plugins folder.
All preference data is stored in the /.squirrel-sql/
folder. The folder is typically /home/
on UNIX and C:\Documents and Settings\ on
Windows. The aliases are stored in SQLAliases23.xml and
SQLAliases23_treeStructure.xml, while the driver definitions are found
in SQLDrivers.xml. Other preference data is also stored in various
files in this directory.
Yes there is. Open Global Preferences from
the File menu and then click on Data Type Control tab. Scroll down to
the bottom. Scroll down to the "FLOAT, REAL, DOUBLE, NUMERIC" section,
select "Use default format".
For startup performance, fine-grain control
was introduced to allow you to specify which schemas are loaded. This
is a big deal for Oracle as it has by default many schemas which are
rarely used and some that are used occasionally that have tons of
objects in them (e.g. SYS). You can control this configuration per
alias as follows:
- Right-click on the alias and choose "Alias Properties".
- In the "Schemas" tab of the resulting dialog, choose
"Specify Schema loading and caching".
- Click the "Connect database to refresh Schema table"
button.(Now, for each schema listed you are able to specify whether
or not tables, views and/or procedures are loaded into the object
tree, by clicking the cell in Tables, Views, or Procedures.
- Turn off all schemas and then explicitly add the ones you
need for this particular alias. You can achieve this easily with the
buttons below the schema table. It forms a sentence that should read
"Set <All Objects> in all Schemas to <Don't load>", then
click Apply. All Table, View and Procedure cells move to "Don't load"
- Find your schema and change the Tables, Views and Procedures
cells for that row to "Load ..." (caching will help if you have a
large number of objects that are always present)
- Next find the SYS schema and change it to load VIEWS.
- Start a new session with that alias and SYS views will be
loaded into the object tree of that new session
Doug Lawry has reported that the following steps
are required in order to install SQuirreL SQL Client on Windows Vista.
- Start "cmd.exe" using "Run as administrator"
- Change directory to the file location
- Run "java -jar squirrel-sql-2.5.1-install.jar"
Andrew Melton has reported that disabling
Desktop Effects (and using metacity) solved the problem. Furthermore,
he also reports that after re-enabling Desktop Effects SQuirreL still
renders correctly. Additionally, this
Java bug seems to be at least related to if not the same problem.
In theory SQuirreL should work with any DBMS
that has a JDBC 2.0 driver. However not all drivers/DBMS's are fully
complient with the JDBC 2.0 specification. People have reported
SQuirreL working with the following:
Please send us an email if you have
used SQuirreL successfully with other products.
Different versions of SQuirreL have different
minimum JVM version requirements. The following table provides a
summary of the version requirements:
||Minimum JVM Version
|2.4 - 2.6.x
|2.0 - 2.3.x
Early versions of the Sun 1.3.0 VM on Linux
throw a segmentation fault when running SQuirreL. Either update to the
latest 1.3.1 VM or pass the -classic flag to the Java executable -
java -classic -cp...
Early beta versions of the Microsoft type 4 JDBC
driver had a bug which would cause this error when trying to connect.
Go to the General Tab in the Global Preferences dialog and change the
SQL Login Timeout to 0.
When connecting to Microsoft SQL Server with
auto-commit off or changing auto-commit to false for an existing
connection you may get this error. To stop it from occuring enable the
'selectmethod=cursor' driver property in the alias.
Versions of PostgreSQL prior to 7.1.3 didn't
supply sufficent metadata to build the object tree in SQuirreL. A fix
has been put into SQuirreL so that it would work with PostgreSQL
This is a known problem with JDK1.3.0 on some
platforms. Upgrade your Java version to 1.3.1 or better.
Right-click on the schema in the explorer and
select refresh, objects should appear as normal.
This is a bug in earlier versions of the
Informix JDBC driver and is known to be fixed in version 9.4 of
Informix and version 2.21 of the Informix JDBC driver.
JRE/JDBC Version mismatch
The driver being used ... is not JDBC N.N compliant.
You should consider getting a more recent version of this driver.
It's telling you that your JRE version is
much newer than your driver's supported JDBC version. In general, it's
hard to tell how well tested an older driver is with a newer
JVM(1.4+). The odds are good that the newer JVM wasn't available when
the older driver was written. So the warning message is there to let
you know that you aren't getting the most efficient use from SQuirreL
2.x and your database driver. SQuirreL 2.x requires JVM 1.4 or higher
so your choices are limited there. Upgrade your JDBC driver if
possible - if not, then you can disable the warning. To disable it go
to Global Preferences -> General and uncheck the checkbox next to Warning
for JRE/JDBC Version Mismatch