oracle.AWXML
Class AWConnection

java.lang.Object
  |
  +--oracle.AWXML.AWConnection

public class AWConnection

extends java.lang.Object

Initializes a JDBC connection and opens an OLAP session using the AWXML analytic workspace.

The AWXML analytic workspace contains the OLAP programs that implement the instructions generated by the Analytic Workspace Java API.

The AWConnection object executes the following OLAP DML command.

aw attach sys.awxml last

The arguments to the AWConnection constructor are a user ID, password, and connect string. The connection can be either thick or thin.

The connect string for a thin client has the format host_name:instance_name:port#.

The connect string for a thick client has the format user_id/password@host_name:instance_name:port# and uses an entry in the tnsnames.ora file to connect to the Database.

The AWConnection class uses the OLAP API SPLExecutor class to execute OLAP DML commands in the Database.

An AWConnection object is only used by client applications that connect through JDBC. It is not used to implement information stored in XML.

CommitMode

public static java.lang.String CommitMode

AWConnection

public AWConnection(java.lang.String user,
                    java.lang.String pwd,
                    java.lang.String inputConnectString)

Opens a Database connection through JDBC using the credentials and connect string passed as input. Opens an OLAP session and attaches the sys.awxml analytic workspace. sys.awxml contains the OLAP DML programs that implement the Analytic Workspace API.

For a thin connection (recommended) specify the connect string: host_name:instance_name:port# For a thick connection specify the connect string: user_id/password@host_name:instance_name:port#

The following illustrates a thin connection to the main instance at port 1521 on the machine mysun-sun:

   String conn1 = "mysun-sun.us.oracle.com:1521:main";
   String user = "xademo";
   String pwd = "xademo";
   String conn = conn1;
          try {
             AWConnection awConnection = new AWConnection(user, pwd, conn );

Parameters:

user - A String containing the user ID for the connection.

pwd - A String containing the password for the connection.

inputConnectString - A String containing the connect string.