|
Oracle OLAP Analytic Workspace Java API Reference 10g Release 1 (10.1) B12180-01 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.AWXML.AWConnection
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.
Field Summary | |
static java.lang.String |
CommitMode |
Constructor Summary | |
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. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static java.lang.String CommitMode
Constructor Detail |
public AWConnection(java.lang.String user, java.lang.String pwd, java.lang.String inputConnectString)
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 );
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.
|
Oracle OLAP Analytic Workspace Java API Reference 10g Release 1 (10.1) B12180-01 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |