JDBC does not specify what SQL dialect you can use; it simply passes the SQL on to the driver and lets the driver either pass it on directly to the database, or parse the SQL itself. Because of this, the solidDB® JDBC Driver behavior is particular to solidDB®.
In some functions, the JDBC specification leaves some details open. For the details particular to solidDB®’s implementation of the methods, check JDBC driver interfaces and methods.
The solidDB® JDBC Driver provides support for catalogs and schemas in solidDB®.
Executing stored procedures
In solidDB® databases, stored procedures can be called by executing statements CALL proc_name [( parameter ...)]’ as in any other SQL statement. Procedures can also be used in JDBC in the same way, through a standard CallableStatement interface.
Note solidDB® stored procedures can return result sets. Calling procedures through the JDBC CallableStatement interface is not necessary. For an example of calling solidDB® procedures using JDBC, see the source code for the Sample 3 application in Code examples.