For more information about using database functions with AquaLogic Data Services Platform, refer to Creating and Working with XQuery Function Libraries in Data Services Developer's Guide. Using Custom Database Functions through AquaLogic Data Services Platformīuilt-in or custom functions in your database can be made available through data services once the function has been registered with AquaLogic Data Services Platform through a library. Techniques for publishing data services as SQL are described in Publishing Data Services Functions for SQL Use in the Data Services Developer's Guide.įor details on accessing the AquaLogic Data Services Platform JDBC driver, and information on the relationship between data services artifacts and JDBC, see About the AquaLogic Data Services Platform JDBC Driver. Once deployed, the newly created SQL objects are available to your application through standard JDBC. Build and deploy your AquaLogic Data Services Platform application.Publish data service functions to a special schema that models them as SQL objects.
Dbvisualizer describe command how to#
This chapter explains how to use SQL to access data services as well as how to set up and use the AquaLogic Data Services Platform JDBC driver.
Dbvisualizer describe command driver#
You can use the JDBC driver to execute SQL92 SELECT queries, or stored procedures over AquaLogic Data Services Platform applications. The driver implements the java.sql.* interface in JDK 1.4x to provide access to an AquaLogic Data Services Platform server through the JDBC interface. SQL access is provided through the AquaLogic Data Services Platform JDBC driver. Application developers also can use a standalone Query Plan Viewer utility which supports both XQuery and SQL.īEA AquaLogic Data Services Platform supports table parameters, an extension to SQL-92. But the ability to handle SQL is also useful in other contexts.įor example, it is useful to be able to run ad hoc SQL queries against data services using tools such as DbVisualizer.
This is necessary in the case of many reporting tools such as Crystal Reports, Hyperion, and Business Objects. This script outputs the product breadcrumb required for edocs documentation.Īpplications can access data services through SQL.