Catalog Service

Apache OpenOffice Developer's Guide

Database Access

< Previous Section

Next Section >

• Architecture
• Example: Querying the Bibliography Database

• Data Sources in Apache OpenOffice API

• DataSources

• The DataSource Service
• Queries

• Adding and Editing Predefined Queries
• Runtime Settings For Predefined Queries
• The SingleSelectQueryComposer
• The SQLQueryComposer

• Forms and Reports
• Document Links
• Tables and Columns

• Connections

• Connecting Through a DataSource
• Connecting Using the DriverManager and a Database URL
• Connecting Through a Specific Driver
• Driver Specifics

• The SDBC Driver for JDBC
• The SDBC Driver for ODBC
• The SDBC Driver for Adabas D
• The SDBC Driver for ADO
• The SDBC Driver for dBase
• The SDBC Driver for Flat File Formats
• The SDBC Driver for Apache OpenOffice Calc Files
• The SDBC Driver for address books
• The SDBC Driver for embedded HSQL databases

• Connection Pooling
• Piggyback Connections

• Manipulating the Data

• The RowSet Service

• Usage
• Events and Other Notifications
• Clones of the RowSet Service

• Statements

• Creating Statements
• Inserting and Updating Data
• Getting Data from a Table

• Result Sets

• Retrieving Values from Result Sets
• Moving the Result Set Cursor
• Using the getXXX Methods
• Scrollable Result Sets
• Modifiable Result Sets
• Update
• Insert
• Delete
• Seeing Changes in Result Sets

• ResultSetMetaData
• Using Prepared Statements
• PreparedStatement From DataSource Queries

• Database Design

• Using DDL to Change the Database Design
• Using SDBCX to Access the Database Design

• Catalog Service
• Table Service
• Column Service
• Index Service
• Key Service
• View Service
• Group Service
• User Service
• The Descriptor Pattern
• Adding an Index
• Creating a User
• Adding a Group

• Using DBMS Features

• Stored Procedures

• Writing Database Drivers

• SDBC Driver
• Driver Service
• Connection Service
• XDatabaseMetaData Interface
• Statements
• Support Scalar Functions

• Open Group CLI Numeric Functions
• Open Group CLI String Functions
• Open Group CLI Time and Date Functions
• Open Group CLI System Functions
• Open Group CLI Conversion Functions

• Handling Unsupported Functionality
• Extending Database Drivers

< Previous Page

Next Page >

The Catalog object is the highest-level container in the SDBCX layer. It contains structural features of databases, like the schema and security model for the database. The connection, for instance, represents the database, and the Catalog is the database container for the tables, views, groups, and users within a connection or database. To create a catalog object, the database driver must support the interface com.sun.star.sdbcx.XDataDefinitionSupplier and an existing connection object. The following code fragment lists tables in a database.

  // create the Driver with the implementation name
  Object aDriver = xORB.createInstance("com.sun.star.comp.sdbcx.adabas.ODriver");
  // query for the interface
  com.sun.star.sdbc.XDriver xDriver;
  xDriver = (XDriver)UnoRuntime.queryInterface(XDriver.class, aDriver);
  if (xDriver != null) {
      // first create the needed url
      String adabasURL = "sdbc:adabas::MYDB0";
      // second create the necessary properties
      com.sun.star.beans.PropertyValue [] adabasProps = new com.sun.star.beans.PropertyValue[] {
          new com.sun.star.beans.PropertyValue("user", 0, "test1",
              com.sun.star.beans.PropertyState.DIRECT_VALUE),
          new com.sun.star.beans.PropertyValue("password", 0, "test1",
              com.sun.star.beans.PropertyState.DIRECT_VALUE)
      };
 
      // now create a connection to adabas
      XConnection adabasConnection = xDriver.connect(adabasURL, a dabasProps);
      if(adabasConnection != null) {
          System.out.println("Connection could be created!");
          // we need the XDatabaseDefinitionSupplier interface 
          // from the driver to get the XTablesSupplier
          XDataDefinitionSupplier xDDSup = (XDataDefinitionSupplier)UnoRuntime.queryInterface(
              XDataDefinitionSupplier.class, xDriver);
          if (xDDSup != null) {
              XTablesSupplier xTabSup = xDDSup.getDataDefinitionByConnection(adabasConnection);
          if (xTabSup != null) {
              XNameAccess xTables = xTabSup.getTables();
              // now print all table names
              System.out.println("Tables available:");
              String [] aTableNames = xTables.getElementNames();
              for ( int i =0; i<= aTableNames.length-1; i++)
                  System.out.println(aTableNames[i]);
              }
          }
          else {
              System.out.println("The driver is not SDBCX capable!");
          }
 
          // now we dispose the connection to close it
          XComponent xComponent = (XComponent)UnoRuntime.queryInterface(
              XComponent.class, adabasConnection);
          if (xComponent != null) {
              xComponent.dispose();
              System.out.println("Connection disposed!");
          }
      }
      else {
          System.out.println("Connection could not be created!");
      }
  }

Content on this page is licensed under the Public Documentation License (PDL).