Overview: Interface Provider class

The following table lists all of the functions and associated methods that the OpenAccess SDK SQL engine can call to process queries. In addition to these functions, the IP must implement any functions it has registered for handling user-defined scalar functions and stored procedures. The oajava.sql.ip class shipped with the product defines each of these methods.

Functions Supported by an IP

The Java class implementing the IP for the OpenAccess SDK SQL engine must implement the interface oajava.sql.ip. An instance of this class is created for each connection and is used to support requests on that connection.

public interface ip
{
    public String   ipGetInfo(int iInfoType);
    public int      ipSetInfo(int iInfoType, String InfoVal);
    public int      ipGetSupport(int iSupportType);
    public int      ipConnect(long tmHandle, long dam_hdbc, 
                        String sDataSourceName, String sUserName, String sPassword,
                        String sCurrentCatalog, String sIPProperties, 
                         String sIPCustomProperties);
    public int      ipDisconnect(long dam_hdbc);
    public int      ipStartTransaction(long dam_hdbc);
    public int      ipEndTransaction(long dam_hdbc, int iType);
    public int      ipExecute(long hstmt, int iStmtType,long hSearchCol,
                        xo_long piNumResRows);    
    public int      ipSchema(long dam_hdbc, long pMemTree, int iType, long pList,
                        Object pSearchObj);
    public int      ipDDL(long hstmt, int iType,xo_long piNumResRows); 
    public int      ipProcedure(long hstmt, int iType, xo_long piNumResRows); 
    public int      ipDCL(long hstmt, int iType,xo_long piNumResRows); 
    public int      ipPrivilege(int iStmtType, String pcUserName,
                        String pcCatalog,String pcSchema,String pcObjName); 
    public int      ipNative(long hstmt, int iCmdType, String szCmd,
                        xo_long piNumResRows); 
    public int      ipSchemaEx(long dam_hstmt, long pMemTree, int iType, 
                        long pList,Object pSearchObj); 
    public int      ipProcedureDynamic(long hstmt, int iType, xo_long piNumResRows);
}