SQL Validator Plugin

Introduction

This plugin will validate your SQL against the ISO SQL standard. It does this by using a Web Service provided by Mimer SQL. The SQL that is validated is stored anonymously to be used by the ISO SQL Standards committee.

If you can't connect to the SQL Validation web service then you may need to specify a proxy server in the "Proxy" tab of the Global Preferences dialog.

For more information on the web service consult the Mimer SQL Validation web site.

Note If you use this plugin with JDK 1.3 you will need a JAXP 1.1 XML compliant parser such as xml-xerces or the JAXP 1.1 reference implementation. 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.

New Global Preferences Tab

The Global Preferences dialog has a new "SQL Validator" tab. This specifies the information to send to the Web Service. You can either logon anonymously or use a user name and password that have been supplied to you by Mimer SQL.

You can choose whether to send client details to the Web Service. If the "Anonymous Client" checkbox is unchecked then the Client and Version details shown will be sent to the Web Service along with your validation request otherwise "N/A" will be sent for these fields.

New Menu Items

An "SQL Validation" hierarchical menu has been added to the "Session" menu. This has the following menu items:

Connect to SQL Validator: This will present you with a "logon" dialog and allow you to connect to the SQL Validation web service. If you have already connected then the previous connection will first be closed.
Disconnect from SQL Validator: If you have previously connected to the SQL Validation web service then this option will disconnect you.
Validate SQL: This option will attempt to validate the current SQL in the SQL entry area. If you aren't connected to the SQL Validation web service then it will first display a "logon" dialog to allow you to connect. Results are shown in the message area at the bottom of the session window. This option has also been added to the popup menu in the SQL entry area.