Executing component methods

After instantiating the stub class, use the stub class instance to invoke the component’s methods. Each method in the stub interface corresponds to a method in the component interface that you have narrowed the proxy object to.

The following table lists the datatypes displayed in EAServer Manager, the equivalent CORBA IDL types, and the Java datatypes used in stub methods.

To convert between the IDL-mapped datatypes and from core java.* classes, use these classes from the com.sybase.CORBA.jdbc11 package:

public class <Type>Holder {
    // Current value
    public <type> value;
    // Default constructor
    public <Type>Holder() {}
    // Constructor that sets initial value
    public <Type>Holder(<type> v) {
      this.value = v;
    }
}

This structure is defined by the CORBA Java-language bindings specification.

In EAServer Manager, a method’s property sheet indicates whether the method returns zero, one, or multiple result sets. This setting determines the return code of the stub method as follows:

• A method that returns 0 result sets returns void.

• A method that returns a single result set returns TabularResults.ResultSet.

• A method that returns multiple result sets returns an array of TabularResults.ResultSet.

The TabularResults IDL module defines the TabularResults::ResultSet CORBA IDL datatype, which maps to TabularResults.ResultSet in Java. Most applications will convert objects of this type to a java.sql.ResultSet by calling one of the following methods:

After converting the result set to java.sql.ResultSet, use standard JDBC calls to retrieve the rows and columns. Alternatively, pass the result set to a data-aware control that displays the data to the end user.

The example below calls a stub method returnsRows() that returns a single result set:

import com.sybase.CORBA.jdbc11.SQL;
...
    java.sql.ResultSet rs = 
       SQL.getResultSet(myStub.returnsRows());
    ... code to process rows or pass result set
        to a data-aware control ...

The example below calls a stub method returnsResults() which returns multiple result sets:

import com.sybase.CORBA.jdbc11.SQL;
...
  java.sql.ResultSet rs;
  TabularResults.ResultSet[] trs_array = 
      myStub.returnsResults();

  for (int i = 0; i < trs_array.length; i++)
  {
    rs = SQL.getResultSet(trs_array[i]);
    ... code to process rows or pass result set
        to a data-aware control ...
  }