vFabric SQLFire Reference

The vFabric SQLFire Reference describes the SQLFire command-line utilities, APIs, and Standard Query Language (SQL) implementation.

• Configuration Properties
  SQLFire uses JDBC connection properties, connection boot properties, and Java system properties to configure SQLFire members and connections.
• JDBC API
  Information about the SQLFire implementation of java.sql classes, interfaces, and methods.
• sqlf Launcher Commands
  Use the sqlf command-line utility to launch SQLFire utilities.
• sqlf Interactive Commands
  sqlf implements an interactive command-line tool that is based on the Apache Derby ij tool. Use sqlf to run scripts or interactive queries against a SQLFire cluster.
• SQLFire API
  Here are brief descriptions of SQLFire classes and interfaces, with links to the JavaDoc and pertinent user guide sections.
• SQL Language Reference
  Read about the SQLFire implementation of and requirements for SQL keywords, statements, clauses, expressions, functions, and more.
• System Tables
  Tables that SQLFire uses to manage the distributed system and its data. All system tables are part of the SYS schema.
• Exception Messages and SQL States
  The JDBC driver returns SQLExceptions for all errors from SQLFire. If the exception originated in a user type but is not itself an SQLException, it is wrapped in an SQLException. SQLFire-specific SQLExceptions use SQLState class codes starting with X. Standard SQLState values are returned for exceptions where appropriate.
• ADO.NET Driver Reference
  The SQLFire ADO.NET driver implements Microsoft's ADO.NET interfaces and abstract classes.
• vFabric SQLFire Limitations
  Note the basic limitations and known issues in this release of SQLFire and its supported platforms.