|
From: <man...@us...> - 2010-08-21 18:11:57
|
Revision: 5825
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=5825&view=rev
Author: manningr
Date: 2010-08-21 18:11:49 +0000 (Sat, 21 Aug 2010)
Log Message:
-----------
Initial changes to convert from Ant build to Maven build
Added Paths:
-----------
trunk/sql12/squirrelsql-translations/
trunk/sql12/squirrelsql-translations/pom.xml
trunk/sql12/squirrelsql-translations/src/
trunk/sql12/squirrelsql-translations/src/main/
trunk/sql12/squirrelsql-translations/src/main/resources/
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_bg_BG.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_cs_CZ.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_de_DE.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_es.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_fr.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_it_IT.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_ko_KR.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_pl.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_pt_BR.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_ru.jar
trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_zh_CN.jar
trunk/sql12/web-site/pom.xml
trunk/sql12/web-site/src/
trunk/sql12/web-site/src/main/
trunk/sql12/web-site/src/main/resources/
trunk/sql12/web-site/src/main/resources/faq.html
trunk/sql12/web-site/src/main/resources/images/
Removed Paths:
-------------
trunk/sql12/web-site/faq.html
trunk/sql12/web-site/images/
Property Changed:
----------------
trunk/sql12/web-site/
Property changes on: trunk/sql12/squirrelsql-translations
___________________________________________________________________
Added: svn:ignore
+ target
.settings
.project
.classpath
Added: trunk/sql12/squirrelsql-translations/pom.xml
===================================================================
--- trunk/sql12/squirrelsql-translations/pom.xml (rev 0)
+++ trunk/sql12/squirrelsql-translations/pom.xml 2010-08-21 18:11:49 UTC (rev 5825)
@@ -0,0 +1,79 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+
+ <parent>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-root-pom</artifactId>
+ <version>3.2.0-SNAPSHOT</version>
+ </parent>
+
+ <groupId>net.sf.squirrel-sql.translations</groupId>
+ <artifactId>squirrelsql-translations</artifactId>
+ <version>3.2.0-SNAPSHOT</version>
+ <packaging>jar</packaging>
+
+ <name>SQuirreL-SQL Translations</name>
+ <description>
+ The project that contains all of the translation jars that are shipped with the installer
+ </description>
+ <inceptionYear>2001</inceptionYear>
+ <developers>
+ <developer>
+ <name>Gerd Wagner</name>
+ <roles>
+ <role>Administrator</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ <developer>
+ <name>Rob Manning</name>
+ <roles>
+ <role>Developer</role>
+ <role>Release Manager</role>
+ </roles>
+ </developer>
+ </developers>
+ <licenses>
+ <license>
+ <name>GNU Lesser General Public License</name>
+ <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
+ <distribution>repo</distribution>
+ </license>
+ </licenses>
+ <url>http://www.squirrelsql.org/</url>
+ <scm>
+ <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/</connection>
+ <developerConnection>scm:svn:http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/</developerConnection>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/</url>
+ </scm>
+ <issueManagement>
+ <system>SourceForge Tracker</system>
+ <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
+ </issueManagement>
+ <ciManagement>
+ <system>Hudson</system>
+ <url>https://www.squirrel-sql.org/hudson/</url>
+ </ciManagement>
+
+ <!-- This is blatant copy/paste from squirrelsql-launcher pom.xml -->
+ <build>
+ <resources>
+ <resource>
+ <directory>src/main/resources</directory>
+ </resource>
+ </resources>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-jar-plugin</artifactId>
+ <configuration>
+ <archive>
+ <addMavenDescriptor>false</addMavenDescriptor>
+ </archive>
+ </configuration>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
\ No newline at end of file
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_bg_BG.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_bg_BG.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_cs_CZ.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_cs_CZ.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_de_DE.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_de_DE.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_es.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_es.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_fr.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_fr.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_it_IT.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_it_IT.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_ko_KR.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_ko_KR.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_pl.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_pl.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_pt_BR.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_pt_BR.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_ru.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_ru.jar)
===================================================================
(Binary files differ)
Copied: trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_zh_CN.jar (from rev 5805, trunk/sql12/translations/squirrel-sql_zh_CN.jar)
===================================================================
(Binary files differ)
Property changes on: trunk/sql12/web-site
___________________________________________________________________
Added: svn:ignore
+ target
.settings
.project
.classpath
Deleted: trunk/sql12/web-site/faq.html
===================================================================
--- trunk/sql12/web-site/faq.html 2010-08-21 18:11:08 UTC (rev 5824)
+++ trunk/sql12/web-site/faq.html 2010-08-21 18:11:49 UTC (rev 5825)
@@ -1,587 +0,0 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-<html>
-<head>
-<meta name="generator" content="HTML Tidy, see www.w3.org">
-<title></title>
-</head>
-<body>
-<table summary="FAQ Table" border="0" cellpadding="0" cellspacing="0"
- width="100%">
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_t.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tr.gif" width="10" height="10"></td>
- </tr>
-
- <tr>
- <td class="body_left_border"> </td>
- <td width='100%' bgcolor="white" valign="top">
- <h1 class="body">FAQ - SQuirreL SQL Client.</h1>
-
- <p></p>
-
- <ul>
- <li><a href="#faq13">I removed the directory where SQuirreL
- was installed, and installed it into a new location. I was surprised
- to see all of my alias, drivers and preference settings were
- maintained when I launched SQuirreL from the new location. Where are
- alias, driver and preference configurations persisted?</a>
- <li><a href="#faq12">Is there a way to configure Squirrel to
- show integers without commas? We use integer IDs that look like
- 1000234. Squirrel is currently showing the ID as 1,000,234</a>
- <li><a href="#faq11">I don't see Oracle system tables/views
- list in the code completion dialog. Can I configure this somehow?</a></li>
-
- <li><a href="#faq10">How do I install SQuirreL SQL Client on
- Windows Vista?</a></li>
-
- <li><a href="#faq9">I get a blank window when running
- SQuirreL on Fedora Core while using Desktop Effects (Compiz) and the
- Sun JDK.</a></li>
-
- <li><a href="#faq0">What database systems does SQuirreL work
- with?</a></li>
-
- <li><a href="#faq1">What version of the JVM is SQuirreL
- compatible with?</a></li>
-
- <li><a href="#faq2">I get a "Segmentation fault" on Linux</a></li>
-
- <li><a href="#faq3">I get a "Login has timed out" error with
- Microsoft SQL Server</a></li>
-
- <li><a href="#faq3_1">I get a "Can't start a cloned
- connection while in manual transaction mode" error with Microsoft SQL
- Server</a></li>
-
- <li><a href="#faq4">I don't see an object tree with
- PostgreSQL</a></li>
-
- <li><a href="#faq5">I get a "NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></li>
-
- <li><a href="#faq6">Ingres reports "Error: contsbt:
- ca.edbc.util.EdbcEx: No MST is currently in progress, cannot declare
- another cursor." when I connect and nothing is listed under the
- schema name in the Object Tree.</a></li>
-
- <li><a href="#faq7">Informix reports "The specified table
- (schema.table) is not in the database" when trying to view the
- contents of a table in the current schema.</a></li>
-
- <li><a href="#faq8">I am using SQuirreL 2.x and when I
- connect to a database I get the following warning message:</a></li>
- </ul>
-
- <pre>
- 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.
-
-</pre> <br>
- </td>
- <td class="body_right_border"> </td>
- </tr>
-
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_bl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_b.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_br.gif" width="10" height="10"></td>
- </tr>
-</table>
-
-<p class="menu_divider">
-<table summary="Plugin Section" border="0" cellpadding="0"
- cellspacing="0" width="100%">
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_t.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tr.gif" width="10" height="10"></td>
- </tr>
-
- <tr>
- <td class="body_left_border"> </td>
- <td width='100%' bgcolor="white" valign="top">
- <h1 class="body">FAQ - Plugins.</h1>
-
- <br>
-
-
- <ul>
- <li><a href="#plug0">How do I write a plugin?</a></li>
-
- <li><a href="#plug1">What are these directories "Colin Bell"
- and "Johan Compagner" in the plugins directory?</a></li>
-
- <li><a href="#plug2">I can't see any "Look and Feel" files.</a></li>
-
- <li><a href="#plug3">I get a <tt>java.lang.NoClassDefFoundError:
- org/w3c/dom/Node</tt> error when trying to validate SQL.</a></li>
- </ul>
-
- <br>
- </td>
- <td class="body_right_border"> </td>
- </tr>
-
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_bl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_b.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_br.gif" width="10" height="10"></td>
- </tr>
-</table>
-
-<p class="menu_divider">
-<table summary="Answers" border="0" cellpadding="0" cellspacing="0"
- width="100%">
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_t.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tr.gif" width="10" height="10"></td>
- </tr>
-
- <tr>
- <td class="body_left_border"> </td>
- <td width='100%' bgcolor="white" valign="top">
- <h1 class="body">Answers - SQuirreL SQL Client.</h1>
-
-
- <h1 class="question"><a name="faq13">I removed the directory
- where SQuirreL was installed, and installed it into a new location. I
- was surprised to see all of my alias, drivers and preference settings
- were maintained when I launched SQuirreL from the new location. Where
- are alias, driver and preference configurations persisted?</a></h1>
-
- <div class="answer">All preference data is stored in the <user.home>/.squirrel-sql/
- folder. The <user.home> folder is typically /home/<username>
- on UNIX and C:\Documents and Settings\<username> 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.</div>
-
- <h1 class="question"><a name="faq12">Is there a way to
- configure Squirrel to show integers without commas? We use integer IDs
- that look like 1000234. Squirrel is currently showing the ID as
- 1,000,234.</a></h1>
-
- <div class="answer">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".</div>
-
- <h1 class="question"><a name="faq11">I don't see Oracle
- system tables/views list in the code completion dialog. Can I
- configure this somehow?</a></h1>
-
- <div class="answer">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:
-
- <ol>
- <li>Right-click on the alias and choose "Alias Properties".</li>
-
- <li>In the "Schemas" tab of the resulting dialog, choose
- "Specify Schema loading and caching".</li>
-
- <li>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.</li>
-
- <li>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"
- value.</li>
-
- <li>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)</li>
-
- <li>Next find the SYS schema and change it to load VIEWS.</li>
-
- <li>Start a new session with that alias and SYS views will be
- loaded into the object tree of that new session</li>
- </ol>
- </div>
-
- <h1 class="question"><a name="faq10">How do I install
- SQuirreL SQL Client on Windows Vista?</a></h1>
-
- <p class="answer">Doug Lawry has reported that the following steps
- are required in order to install SQuirreL SQL Client on Windows Vista.<br>
- </p>
-
- <ol>
- <li>Start "cmd.exe" using "Run as administrator"</li>
-
- <li>Change directory to the file location</li>
-
- <li>Run "java -jar squirrel-sql-2.5.1-install.jar"</li>
- </ol>
-
- <h1 class="question"><a name="faq9">I get a blank SQuirreL
- 2.4 window when running on Fedora Core while using Desktop Effects
- (Compiz) and Sun Java 1.5. What gives?</a></h1>
-
- <p class="answer">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, <a
- href="http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6429775">this
- Java bug</a> seems to be at least related to if not the same problem.</p>
-
- <h1 class="question"><a name="faq0">What database systems
- does SQuirreL work with?</a></h1>
-
- <p class="answer">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:</p>
-
- <ul>
- <li><a href="http://axion.tigris.org/">Axion Java RDBMS</a>.</li>
-
- <li><a href="http://www.daffodildb.com/one-dollar-db.html">Daffodil
- (One$DB)</a></li>
-
- <li><a href="http://db.apache.org/derby/">Apache Derby</a>
- (formerly Cloudscape) <a
- href="http://db.apache.org/derby/integrate/SQuirreL_Derby.html">Using
- SQuirreL SQL with Derby</a> (by Susan Cline)</li>
-
- <li><a
- href="http://www.fujitsu-siemens.com/rl/products/software/sesamsql.html">
- Fujitsu Siemens SESAM/SQL-Server</a> with the <a
- href="http://www.fujitsu-siemens.com/rl/products/software/sesamsqljdbc.html">
- SESAM/SQL</a> JDBC driver.</li>
-
- <li><a href="http://sourceforge.net/projects/firebird/">Firebird</a>
- with the JayBird JCA/JDBC Driver.</li>
-
- <li><a href="http://www.frontbase.com/">FrontBase</a></li>
-
- <li><a href="http://hsqldb.sourceforge.net/">HSQL</a>.</li>
-
- <li><a href="http://hsql.sourceforge.net/">Hypersonic SQL</a>.</li>
-
- <li><a href="http://www.h2database.com/">H2</a></li>
-
- <li><a href="http://www.ibm.com/">IBM DB2</a> for Linux, OS/400
- and Windows.</li>
-
- <li><a href="http://www.informix.com/">Informix</a>.</li>
-
- <li><a href="http://www.ingres.com/">CA Ingres</a> 2.6 SP2 with
- EDBC driver v1.8 (probably works with Caribou Lake driver too).</li>
-
- <li><a href="http://www.instantdb.com/">InstantDB</a>.</li>
-
- <li><a href="http://www.interbase.com/">Interbase</a> with the <a
- href="http://www.interbase.com/">Interclient</a> JDBC driver.</li>
-
- <li><a href="http://mckoi.com/database/">Mckoi SQL</a>.</li>
-
- <li><a href="http://www.microsoft.com">Microsoft Access</a> with
- the JDBC/ODBC bridge.</li>
-
- <li><a href="http://www.microsoft.com">Microsoft SQL Server</a>
- with the Microsoft, <a href="http://www.weblogic.com">WebLogic</a>
- and <a href="http://jtds.sourceforge.net">jTDS</a> JDBC drivers.</li>
-
- <li><a href="http://www.mimer.com/">Mimer SQL</a></li>
-
- <li><a href="http://www.mysql.com">MySQL</a> with the <a
- href="http://mmmysql.sourceforge.net/">MM MySQL</a> JDBC driver.</li>
-
- <li><a href="http://www.netezza.com">Netezza</a> Data Warehouse
- with 4.0.4P2 Driver</li>
-
- <li><a href="http://www.oracle.com">Oracle 8i, 9i and 10g</a>
- with the Oracle thin and OCI drivers.</li>
-
- <li><a href="http://www.pointbase.com">Pointbase</a>.</li>
-
- <li><a href="http://www.postgresql.org">PostgreSQL 7.1.3 and
- higher.</a>.</li>
-
- <li><a href="http://www.progress.com">Progress OpenEdge
- 10.1x</a>.</li>
-
- <li><a href="http://www.sapdb.org">SAPDB</a>.</li>
-
- <li><a href="http://www.sybase.com">Sybase</a> with the <a
- href="http://www.sybase.com">JConnect</a> JDBC driver. There are
- currently some issues with Sybase JConnect 5.5 and SQuirreL 1.1
- although JConnect 4.5 seems to work.</li>
-
- <li><a
- href="http://www.ncr.com/en/solutions/data_warehousing/dataware.htm">Teradata
- Warehouse</a></li>
-
- <li><a href="http://www.thinksql.co.uk">ThinkSQL RDBMS</a>.</li>
-
- <li><a href="http://www.vertica.com">Vertica</a> Analytic
- Database</li>
- </ul>
-
- <p class="answer">Please send us an <a
- href="mailto:man...@us...">email</a> if you have
- used SQuirreL successfully with other products.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq1">Which version of the JVM
- is SQuirreL compatible with?</a></h1>
-
- <p class="answer">Different versions of SQuirreL have different
- minimum JVM version requirements. The following table provides a
- summary of the version requirements:<br>
- </p>
-
- <table align="center" border="2" cellpadding="5"
- summary="Compatibility Matrix">
- <tr>
- <th>SQuirreL Version</th>
- <th>Minimum JVM Version</th>
- </tr>
-
- <tr align="center">
- <td>3.0+</td>
- <td>1.6</td>
- </tr>
-
- <tr align="center">
- <td>2.4 - 2.6.x</td>
- <td>1.5</td>
- </tr>
-
- <tr align="center">
- <td>2.0 - 2.3.x</td>
- <td>1.4.2</td>
- </tr>
-
- <tr align="center">
- <td>1.1 Final</td>
- <td>1.3.1</td>
- </tr>
- </table>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq2">I get a "Segmentation
- fault" on Linux</a></h1>
-
- <p class="answer">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 -
- i.e.</p>
-
- <p class="code">java -classic -cp...</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq3">I get a "Login has timed
- out" error with Microsoft SQL Server</a></h1>
-
- <p class="answer">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.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq3_1">I get a "Can't start a
- cloned connection while in manual transaction mode" error with
- Microsoft SQL Server</a></h1>
-
- <p class="answer">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.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq4">I don't see an object
- tree with PostgreSQL</a></h1>
-
- <p class="answer">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
- 7.1.2.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq5">I get a
- "NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></h1>
-
- <p class="answer">This is a known problem with JDK1.3.0 on some
- platforms. Upgrade your Java version to 1.3.1 or better.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq6">Ingres reports "Error:
- contsbt: ca.edbc.util.EdbcEx: No MST is currently in progress, cannot
- declare another cursor." when I connect and nothing is listed under
- the schema name in the Object Tree</a></h1>
-
- <p class="answer">Right-click on the schema in the explorer and
- select refresh, objects should appear as normal.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq7">Informix reports "The
- specified table (schema.table) is not in the database" when trying to
- view the contents of a table in the current schema</a></h1>
-
- <p class="answer">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.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="faq8">I am using SQuirreL 2.x
- and when I connect to a database I get the following warning message:</a></h1>
-
- <pre>
- 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.
-
-</pre>
-
- <div class="answer">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 <b><i>Warning
- for JRE/JDBC Version Mismatch</i></b></div>
-
- <br>
-
-
- <p><a href="#top">Top</a></p>
- </td>
- <td class="body_right_border"> </td>
- </tr>
-
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_bl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_b.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_br.gif" width="10" height="10"></td>
- </tr>
-</table>
-
-<p class="menu_divider">
-<table summary="Plugin Answers" border="0" cellpadding="0"
- cellspacing="0" width="100%">
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_t.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_tr.gif" width="10" height="10"></td>
- </tr>
-
- <tr>
- <td class="body_left_border"> </td>
- <td width='100%' bgcolor="white" valign="top">
- <h1 class="body">Answers - Plugins.</h1>
-
- <h1 class="question"><a name="plug0">How do I write a plugin?</a></h1>
-
- <p class="answer">There is some information in the document <a
- href="http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/doc/plugins.html">
- plugins.html</a> which you can find in the docs directory within your
- SQuirreL program directory. This document badly needs a lot of work
- and its on our todo list. You can also look at the existing plugins to
- see how they've done things.</p>
-
- <p class="answer">If you have an idea for a plugin just send a
- message to the SQuirreL Developers list giving a brief description.
- This helps to ensure that two people don't develop the same plugin.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="plug1">What are these
- directories "Colin Bell" and "Johan Compagner" in the plugins
- directory?</a></h1>
-
- <p class="answer">Some people have reported these directories
- appearing when running JDK 1.3 on Windows 2000. It appears to be a
- problem with the Hotspot VM. Passing the -classic flag to the java
- executable fixes the problem - i.e.</p>
-
- <p class="code">java -classic -cp...</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="plug2">I can't see any "Look
- and Feel" files.</a></h1>
-
- <p class="answer">This can be caused by the <a href="#plug1">What
- are these directories "Colin Bell" and "Johan Compagner" in the
- plugins directory?</a> problem.</p>
-
- <p><a href="#top">Top</a></p>
-
- <h1 class="question"><a name="plug3">I get a
- java.lang.NoClassDefFoundError: org/w3c/dom/Node error when trying to
- validate SQL.</a></h1>
-
- <p class="answer">If you use the SQL Validator plugin with JDK 1.3
- you will need a JAXP 1.1 XML compliant parser such as <a
- href="http://xml.apache.org/dist/xerces-j/">xml-xerces</a> or the <a
- href="http://java.sun.com/xml/jaxp/index.html">JAXP 1.1 reference
- implementation</a>. Copy the jar files from your XML parser to the
- directory <squirrel-sql>/plugins/sqlval/lib. For xml-xerces this
- should be xerces.jar and for JAXP 1.1 reference implementation this
- should be crimson.jar and jaxp.jar.</p>
-
- <p><a href="#top">Top</a></p>
- </td>
- <td class="body_right_border"> </td>
- </tr>
-
- <tr>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_bl.gif" width="10" height="10"></td>
- <td width='100%' height='10'><img alt="border image" border="0"
- src="images/border_b.gif" width="100%" height="10"></td>
- <td width='10' height='10'><img alt="border image" border="0"
- src="images/border_br.gif" width="10" height="10"></td>
- </tr>
-</table>
-</body>
-</html>
-
Added: trunk/sql12/web-site/pom.xml
===================================================================
--- trunk/sql12/web-site/pom.xml (rev 0)
+++ trunk/sql12/web-site/pom.xml 2010-08-21 18:11:49 UTC (rev 5825)
@@ -0,0 +1,77 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+
+ <parent>
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>squirrel-root-pom</artifactId>
+ <version>3.2.0-SNAPSHOT</version>
+ </parent>
+
+ <groupId>net.sf.squirrel-sql</groupId>
+ <artifactId>website</artifactId>
+ <version>3.2.0-SNAPSHOT</version>
+ <packaging>jar</packaging>
+
+ <name>Website Files</name>
+ <description>Website Files needed by the installer.</description>
+ <inceptionYear>2001</inceptionYear>
+ <developers>
+ <developer>
+ <name>Gerd Wagner</name>
+ <roles>
+ <role>Administrator</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ <developer>
+ <name>Rob Manning</name>
+ <roles>
+ <role>Release Manager</role>
+ <role>Developer</role>
+ </roles>
+ </developer>
+ </developers>
+ <licenses>
+ <license>
+ <name>GNU Lesser General Public License</name>
+ <url>http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt</url>
+ <distribution>repo</distribution>
+ </license>
+ </licenses>
+ <url>http://www.squirrelsql.org/</url>
+ <scm>
+ <connection>scm:svn:https://squirrel-sql.svn.sourceforge.net/svnroot/squirrel-sql/trunk/sql12/</connection>
+ <developerConnection>scm:svn:http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/</developerConnection>
+ <url>http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/</url>
+ </scm>
+ <issueManagement>
+ <system>SourceForge Tracker</system>
+ <url>http://sourceforge.net/tracker/?group_id=28383%26atid=393414</url>
+ </issueManagement>
+ <ciManagement>
+ <system>Hudson</system>
+ <url>https://www.squirrel-sql.org/hudson/</url>
+ </ciManagement>
+
+ <build>
+ <resources>
+ <resource>
+ <directory>src/main/resources</directory>
+ </resource>
+ </resources>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-jar-plugin</artifactId>
+ <version>${jar-plugin-version}</version>
+ <configuration>
+ <archive>
+ <addMavenDescriptor>false</addMavenDescriptor>
+ </archive>
+ </configuration>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
\ No newline at end of file
Copied: trunk/sql12/web-site/src/main/resources/faq.html (from rev 5805, trunk/sql12/web-site/faq.html)
===================================================================
--- trunk/sql12/web-site/src/main/resources/faq.html (rev 0)
+++ trunk/sql12/web-site/src/main/resources/faq.html 2010-08-21 18:11:49 UTC (rev 5825)
@@ -0,0 +1,587 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+<meta name="generator" content="HTML Tidy, see www.w3.org">
+<title></title>
+</head>
+<body>
+<table summary="FAQ Table" border="0" cellpadding="0" cellspacing="0"
+ width="100%">
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_t.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tr.gif" width="10" height="10"></td>
+ </tr>
+
+ <tr>
+ <td class="body_left_border"> </td>
+ <td width='100%' bgcolor="white" valign="top">
+ <h1 class="body">FAQ - SQuirreL SQL Client.</h1>
+
+ <p></p>
+
+ <ul>
+ <li><a href="#faq13">I removed the directory where SQuirreL
+ was installed, and installed it into a new location. I was surprised
+ to see all of my alias, drivers and preference settings were
+ maintained when I launched SQuirreL from the new location. Where are
+ alias, driver and preference configurations persisted?</a>
+ <li><a href="#faq12">Is there a way to configure Squirrel to
+ show integers without commas? We use integer IDs that look like
+ 1000234. Squirrel is currently showing the ID as 1,000,234</a>
+ <li><a href="#faq11">I don't see Oracle system tables/views
+ list in the code completion dialog. Can I configure this somehow?</a></li>
+
+ <li><a href="#faq10">How do I install SQuirreL SQL Client on
+ Windows Vista?</a></li>
+
+ <li><a href="#faq9">I get a blank window when running
+ SQuirreL on Fedora Core while using Desktop Effects (Compiz) and the
+ Sun JDK.</a></li>
+
+ <li><a href="#faq0">What database systems does SQuirreL work
+ with?</a></li>
+
+ <li><a href="#faq1">What version of the JVM is SQuirreL
+ compatible with?</a></li>
+
+ <li><a href="#faq2">I get a "Segmentation fault" on Linux</a></li>
+
+ <li><a href="#faq3">I get a "Login has timed out" error with
+ Microsoft SQL Server</a></li>
+
+ <li><a href="#faq3_1">I get a "Can't start a cloned
+ connection while in manual transaction mode" error with Microsoft SQL
+ Server</a></li>
+
+ <li><a href="#faq4">I don't see an object tree with
+ PostgreSQL</a></li>
+
+ <li><a href="#faq5">I get a "NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></li>
+
+ <li><a href="#faq6">Ingres reports "Error: contsbt:
+ ca.edbc.util.EdbcEx: No MST is currently in progress, cannot declare
+ another cursor." when I connect and nothing is listed under the
+ schema name in the Object Tree.</a></li>
+
+ <li><a href="#faq7">Informix reports "The specified table
+ (schema.table) is not in the database" when trying to view the
+ contents of a table in the current schema.</a></li>
+
+ <li><a href="#faq8">I am using SQuirreL 2.x and when I
+ connect to a database I get the following warning message:</a></li>
+ </ul>
+
+ <pre>
+ 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.
+
+</pre> <br>
+ </td>
+ <td class="body_right_border"> </td>
+ </tr>
+
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_bl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_b.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_br.gif" width="10" height="10"></td>
+ </tr>
+</table>
+
+<p class="menu_divider">
+<table summary="Plugin Section" border="0" cellpadding="0"
+ cellspacing="0" width="100%">
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_t.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tr.gif" width="10" height="10"></td>
+ </tr>
+
+ <tr>
+ <td class="body_left_border"> </td>
+ <td width='100%' bgcolor="white" valign="top">
+ <h1 class="body">FAQ - Plugins.</h1>
+
+ <br>
+
+
+ <ul>
+ <li><a href="#plug0">How do I write a plugin?</a></li>
+
+ <li><a href="#plug1">What are these directories "Colin Bell"
+ and "Johan Compagner" in the plugins directory?</a></li>
+
+ <li><a href="#plug2">I can't see any "Look and Feel" files.</a></li>
+
+ <li><a href="#plug3">I get a <tt>java.lang.NoClassDefFoundError:
+ org/w3c/dom/Node</tt> error when trying to validate SQL.</a></li>
+ </ul>
+
+ <br>
+ </td>
+ <td class="body_right_border"> </td>
+ </tr>
+
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_bl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_b.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_br.gif" width="10" height="10"></td>
+ </tr>
+</table>
+
+<p class="menu_divider">
+<table summary="Answers" border="0" cellpadding="0" cellspacing="0"
+ width="100%">
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_t.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tr.gif" width="10" height="10"></td>
+ </tr>
+
+ <tr>
+ <td class="body_left_border"> </td>
+ <td width='100%' bgcolor="white" valign="top">
+ <h1 class="body">Answers - SQuirreL SQL Client.</h1>
+
+
+ <h1 class="question"><a name="faq13">I removed the directory
+ where SQuirreL was installed, and installed it into a new location. I
+ was surprised to see all of my alias, drivers and preference settings
+ were maintained when I launched SQuirreL from the new location. Where
+ are alias, driver and preference configurations persisted?</a></h1>
+
+ <div class="answer">All preference data is stored in the <user.home>/.squirrel-sql/
+ folder. The <user.home> folder is typically /home/<username>
+ on UNIX and C:\Documents and Settings\<username> 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.</div>
+
+ <h1 class="question"><a name="faq12">Is there a way to
+ configure Squirrel to show integers without commas? We use integer IDs
+ that look like 1000234. Squirrel is currently showing the ID as
+ 1,000,234.</a></h1>
+
+ <div class="answer">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".</div>
+
+ <h1 class="question"><a name="faq11">I don't see Oracle
+ system tables/views list in the code completion dialog. Can I
+ configure this somehow?</a></h1>
+
+ <div class="answer">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:
+
+ <ol>
+ <li>Right-click on the alias and choose "Alias Properties".</li>
+
+ <li>In the "Schemas" tab of the resulting dialog, choose
+ "Specify Schema loading and caching".</li>
+
+ <li>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.</li>
+
+ <li>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"
+ value.</li>
+
+ <li>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)</li>
+
+ <li>Next find the SYS schema and change it to load VIEWS.</li>
+
+ <li>Start a new session with that alias and SYS views will be
+ loaded into the object tree of that new session</li>
+ </ol>
+ </div>
+
+ <h1 class="question"><a name="faq10">How do I install
+ SQuirreL SQL Client on Windows Vista?</a></h1>
+
+ <p class="answer">Doug Lawry has reported that the following steps
+ are required in order to install SQuirreL SQL Client on Windows Vista.<br>
+ </p>
+
+ <ol>
+ <li>Start "cmd.exe" using "Run as administrator"</li>
+
+ <li>Change directory to the file location</li>
+
+ <li>Run "java -jar squirrel-sql-2.5.1-install.jar"</li>
+ </ol>
+
+ <h1 class="question"><a name="faq9">I get a blank SQuirreL
+ 2.4 window when running on Fedora Core while using Desktop Effects
+ (Compiz) and Sun Java 1.5. What gives?</a></h1>
+
+ <p class="answer">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, <a
+ href="http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6429775">this
+ Java bug</a> seems to be at least related to if not the same problem.</p>
+
+ <h1 class="question"><a name="faq0">What database systems
+ does SQuirreL work with?</a></h1>
+
+ <p class="answer">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:</p>
+
+ <ul>
+ <li><a href="http://axion.tigris.org/">Axion Java RDBMS</a>.</li>
+
+ <li><a href="http://www.daffodildb.com/one-dollar-db.html">Daffodil
+ (One$DB)</a></li>
+
+ <li><a href="http://db.apache.org/derby/">Apache Derby</a>
+ (formerly Cloudscape) <a
+ href="http://db.apache.org/derby/integrate/SQuirreL_Derby.html">Using
+ SQuirreL SQL with Derby</a> (by Susan Cline)</li>
+
+ <li><a
+ href="http://www.fujitsu-siemens.com/rl/products/software/sesamsql.html">
+ Fujitsu Siemens SESAM/SQL-Server</a> with the <a
+ href="http://www.fujitsu-siemens.com/rl/products/software/sesamsqljdbc.html">
+ SESAM/SQL</a> JDBC driver.</li>
+
+ <li><a href="http://sourceforge.net/projects/firebird/">Firebird</a>
+ with the JayBird JCA/JDBC Driver.</li>
+
+ <li><a href="http://www.frontbase.com/">FrontBase</a></li>
+
+ <li><a href="http://hsqldb.sourceforge.net/">HSQL</a>.</li>
+
+ <li><a href="http://hsql.sourceforge.net/">Hypersonic SQL</a>.</li>
+
+ <li><a href="http://www.h2database.com/">H2</a></li>
+
+ <li><a href="http://www.ibm.com/">IBM DB2</a> for Linux, OS/400
+ and Windows.</li>
+
+ <li><a href="http://www.informix.com/">Informix</a>.</li>
+
+ <li><a href="http://www.ingres.com/">CA Ingres</a> 2.6 SP2 with
+ EDBC driver v1.8 (probably works with Caribou Lake driver too).</li>
+
+ <li><a href="http://www.instantdb.com/">InstantDB</a>.</li>
+
+ <li><a href="http://www.interbase.com/">Interbase</a> with the <a
+ href="http://www.interbase.com/">Interclient</a> JDBC driver.</li>
+
+ <li><a href="http://mckoi.com/database/">Mckoi SQL</a>.</li>
+
+ <li><a href="http://www.microsoft.com">Microsoft Access</a> with
+ the JDBC/ODBC bridge.</li>
+
+ <li><a href="http://www.microsoft.com">Microsoft SQL Server</a>
+ with the Microsoft, <a href="http://www.weblogic.com">WebLogic</a>
+ and <a href="http://jtds.sourceforge.net">jTDS</a> JDBC drivers.</li>
+
+ <li><a href="http://www.mimer.com/">Mimer SQL</a></li>
+
+ <li><a href="http://www.mysql.com">MySQL</a> with the <a
+ href="http://mmmysql.sourceforge.net/">MM MySQL</a> JDBC driver.</li>
+
+ <li><a href="http://www.netezza.com">Netezza</a> Data Warehouse
+ with 4.0.4P2 Driver</li>
+
+ <li><a href="http://www.oracle.com">Oracle 8i, 9i and 10g</a>
+ with the Oracle thin and OCI drivers.</li>
+
+ <li><a href="http://www.pointbase.com">Pointbase</a>.</li>
+
+ <li><a href="http://www.postgresql.org">PostgreSQL 7.1.3 and
+ higher.</a>.</li>
+
+ <li><a href="http://www.progress.com">Progress OpenEdge
+ 10.1x</a>.</li>
+
+ <li><a href="http://www.sapdb.org">SAPDB</a>.</li>
+
+ <li><a href="http://www.sybase.com">Sybase</a> with the <a
+ href="http://www.sybase.com">JConnect</a> JDBC driver. There are
+ currently some issues with Sybase JConnect 5.5 and SQuirreL 1.1
+ although JConnect 4.5 seems to work.</li>
+
+ <li><a
+ href="http://www.ncr.com/en/solutions/data_warehousing/dataware.htm">Teradata
+ Warehouse</a></li>
+
+ <li><a href="http://www.thinksql.co.uk">ThinkSQL RDBMS</a>.</li>
+
+ <li><a href="http://www.vertica.com">Vertica</a> Analytic
+ Database</li>
+ </ul>
+
+ <p class="answer">Please send us an <a
+ href="mailto:man...@us...">email</a> if you have
+ used SQuirreL successfully with other products.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq1">Which version of the JVM
+ is SQuirreL compatible with?</a></h1>
+
+ <p class="answer">Different versions of SQuirreL have different
+ minimum JVM version requirements. The following table provides a
+ summary of the version requirements:<br>
+ </p>
+
+ <table align="center" border="2" cellpadding="5"
+ summary="Compatibility Matrix">
+ <tr>
+ <th>SQuirreL Version</th>
+ <th>Minimum JVM Version</th>
+ </tr>
+
+ <tr align="center">
+ <td>3.0+</td>
+ <td>1.6</td>
+ </tr>
+
+ <tr align="center">
+ <td>2.4 - 2.6.x</td>
+ <td>1.5</td>
+ </tr>
+
+ <tr align="center">
+ <td>2.0 - 2.3.x</td>
+ <td>1.4.2</td>
+ </tr>
+
+ <tr align="center">
+ <td>1.1 Final</td>
+ <td>1.3.1</td>
+ </tr>
+ </table>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq2">I get a "Segmentation
+ fault" on Linux</a></h1>
+
+ <p class="answer">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 -
+ i.e.</p>
+
+ <p class="code">java -classic -cp...</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq3">I get a "Login has timed
+ out" error with Microsoft SQL Server</a></h1>
+
+ <p class="answer">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.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq3_1">I get a "Can't start a
+ cloned connection while in manual transaction mode" error with
+ Microsoft SQL Server</a></h1>
+
+ <p class="answer">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.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq4">I don't see an object
+ tree with PostgreSQL</a></h1>
+
+ <p class="answer">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
+ 7.1.2.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq5">I get a
+ "NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></h1>
+
+ <p class="answer">This is a known problem with JDK1.3.0 on some
+ platforms. Upgrade your Java version to 1.3.1 or better.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq6">Ingres reports "Error:
+ contsbt: ca.edbc.util.EdbcEx: No MST is currently in progress, cannot
+ declare another cursor." when I connect and nothing is listed under
+ the schema name in the Object Tree</a></h1>
+
+ <p class="answer">Right-click on the schema in the explorer and
+ select refresh, objects should appear as normal.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq7">Informix reports "The
+ specified table (schema.table) is not in the database" when trying to
+ view the contents of a table in the current schema</a></h1>
+
+ <p class="answer">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.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="faq8">I am using SQuirreL 2.x
+ and when I connect to a database I get the following warning message:</a></h1>
+
+ <pre>
+ 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.
+
+</pre>
+
+ <div class="answer">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 <b><i>Warning
+ for JRE/JDBC Version Mismatch</i></b></div>
+
+ <br>
+
+
+ <p><a href="#top">Top</a></p>
+ </td>
+ <td class="body_right_border"> </td>
+ </tr>
+
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_bl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_b.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_br.gif" width="10" height="10"></td>
+ </tr>
+</table>
+
+<p class="menu_divider">
+<table summary="Plugin Answers" border="0" cellpadding="0"
+ cellspacing="0" width="100%">
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_t.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_tr.gif" width="10" height="10"></td>
+ </tr>
+
+ <tr>
+ <td class="body_left_border"> </td>
+ <td width='100%' bgcolor="white" valign="top">
+ <h1 class="body">Answers - Plugins.</h1>
+
+ <h1 class="question"><a name="plug0">How do I write a plugin?</a></h1>
+
+ <p class="answer">There is some information in the document <a
+ href="http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/doc/plugins.html">
+ plugins.html</a> which you can find in the docs directory within your
+ SQuirreL program directory. This document badly needs a lot of work
+ and its on our todo list. You can also look at the existing plugins to
+ see how they've done things.</p>
+
+ <p class="answer">If you have an idea for a plugin just send a
+ message to the SQuirreL Developers list giving a brief description.
+ This helps to ensure that two people don't develop the same plugin.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="plug1">What are these
+ directories "Colin Bell" and "Johan Compagner" in the plugins
+ directory?</a></h1>
+
+ <p class="answer">Some people have reported these directories
+ appearing when running JDK 1.3 on Windows 2000. It appears to be a
+ problem with the Hotspot VM. Passing the -classic flag to the java
+ executable fixes the problem - i.e.</p>
+
+ <p class="code">java -classic -cp...</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="plug2">I can't see any "Look
+ and Feel" files.</a></h1>
+
+ <p class="answer">This can be caused by the <a href="#plug1">What
+ are these directories "Colin Bell" and "Johan Compagner" in the
+ plugins directory?</a> problem.</p>
+
+ <p><a href="#top">Top</a></p>
+
+ <h1 class="question"><a name="plug3">I get a
+ java.lang.NoClassDefFoundError: org/w3c/dom/Node error when trying to
+ validate SQL.</a></h1>
+
+ <p class="answer">If you use the SQL Validator plugin with JDK 1.3
+ you will need a JAXP 1.1 XML compliant parser such as <a
+ href="http://xml.apache.org/dist/xerces-j/">xml-xerces</a> or the <a
+ href="http://java.sun.com/xml/jaxp/index.html">JAXP 1.1 reference
+ implementation</a>. Copy the jar files from your XML parser to the
+ directory <squirrel-sql>/plugins/sqlval/lib. For xml-xerces this
+ should be xerces.jar and for JAXP 1.1 reference implementation this
+ should be crimson.jar and jaxp.jar.</p>
+
+ <p><a href="#top">Top</a></p>
+ </td>
+ <td class="body_right_border"> </td>
+ </tr>
+
+ <tr>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_bl.gif" width="10" height="10"></td>
+ <td width='100%' height='10'><img alt="border image" border="0"
+ src="images/border_b.gif" width="100%" height="10"></td>
+ <td width='10' height='10'><img alt="border image" border="0"
+ src="images/border_br.gif" width="10" height="10"></td>
+ </tr>
+</table>
+</body>
+</html>
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
