Skip navigation links


com.essbase.eas.server.dbms
Class JDBCImplementation

java.lang.Object
  extended by com.essbase.eas.server.dbms.JDBCImplementation

Direct Known Subclasses:
ServerLogJDBC

public class JDBCImplementation
extends java.lang.Object

Supports conversion of mid-tier database objects to XML representation. how to use this class for jdbc support: 1. user must first open jdbc cnx by calling: openCNX() 2. then execute the SQL via: getResultSet, getXML, getReplicationXML, modifyData 3. then close the jdbc cnx after all rows are processed via: closeCNX()

Version:
1.0.0, 06/06/2001 Created (based upon a version by PaintedWord)
Author:
Hung Vo

Field Summary
 java.sql.Connection con
           
 java.lang.String database
           
 java.lang.String error
           
 java.util.Properties props
           
 java.sql.PreparedStatement pstmt
           
 boolean result
           
 java.sql.ResultSet rs
           
static boolean showBinds
           
static boolean showSql
           
 java.sql.Statement stmt
           

 

Constructor Summary
JDBCImplementation()
           

 

Method Summary
 boolean bindInt(int index, int value)
           
 boolean bindString(int index, java.lang.String value)
           
 boolean bindTimestamp(int index, java.sql.Timestamp value)
           
 void closeCNX()
          closes result set, statement object, and jdbc cnx
 void commit()
           
 boolean createPreparedStmt(java.lang.String sql)
           
 boolean execPreparedStmt()
           
 boolean execSQL(java.lang.String sql)
          execute an sql statement
 java.lang.String getError()
           
 java.sql.ResultSet getResultSet(java.lang.String query)
           
 boolean isConnected()
           
 boolean openCNX()
          opens a jdbc cnx and create a statement object.
static void printSql(java.lang.String sql)
           
 void setAutoCommit(boolean flag)
           
static void showSql(boolean show)
           

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

rs

public java.sql.ResultSet rs

con

public java.sql.Connection con

stmt

public java.sql.Statement stmt

pstmt

public java.sql.PreparedStatement pstmt

result

public boolean result

error

public java.lang.String error

database

public java.lang.String database

props

public java.util.Properties props

showSql

public static boolean showSql

showBinds

public static boolean showBinds

Constructor Detail

JDBCImplementation

public JDBCImplementation()

Method Detail

getResultSet

public java.sql.ResultSet getResultSet(java.lang.String query)

execSQL

public boolean execSQL(java.lang.String sql)
execute an sql statement
Parameters:
sql - the SQL statement to execute

execPreparedStmt

public boolean execPreparedStmt()

createPreparedStmt

public boolean createPreparedStmt(java.lang.String sql)

bindString

public boolean bindString(int index,
                          java.lang.String value)

bindInt

public boolean bindInt(int index,
                       int value)

bindTimestamp

public boolean bindTimestamp(int index,
                             java.sql.Timestamp value)

openCNX

public boolean openCNX()
opens a jdbc cnx and create a statement object.

commit

public void commit()

setAutoCommit

public void setAutoCommit(boolean flag)

closeCNX

public void closeCNX()
closes result set, statement object, and jdbc cnx

getError

public java.lang.String getError()

isConnected

public boolean isConnected()

showSql

public static void showSql(boolean show)

printSql

public static void printSql(java.lang.String sql)

Skip navigation links


Copyright © 2001, 2012, Oracle. All rights reserved.