Setting up your development environment for an IP
Requirements for compiling an IP
Setting up the IP source and schema
Setting up an OpenAccess SDK Service and data source
Connecting to your data source
Interface Provider class
Overview: Interface Provider class
IP methods reference
ipGetDsInfo
Creating an oa_ds_info Object
ipGetInfo
ipGetSupport
ipGetTypesInfo
Creating an oa_types_info object
ipConnect
ipDCL
ipDDL
ipDisconnect
ipEndTransaction
ipExecute
ipfuncxxx
ipGetLongData
ipGetScalarFunctions
ipNative
ipProcedure
ipProcedureDynamic
ipPrivilege
ipSchema
ipSchemaEx
ipSetInfo
ipStartTransaction
OpenAccess SDK SQL Engine core methods for Java
Passing data to and from the OpenAccess SDK SQL Engine
Exchanging data
Working with rows
Getting column handles
Bulk fetching
Reference tables
Helper classes
oa_ds_info class
setDSInfo method
oa_ds_info Default constructor
oa_ds_info overloaded constructor
oa_types_info class
setTypesInfo method
oa_types_info default constructor
oa_types_info overloaded constructor
ResultBuffer class
putNull method
putShort method
putInt method
putBigInt method
putReal method
putDouble method
putString method
putLongString method
putDate method
putTime method
putTimeStamp method
putBinary method
putLongBinary method
setColumnType method
setCheckIsTargetRow method
setNoRowsInBuffer method
getErrorIndex method
Pass-Through Mode methods
setResultColumnType method
setNoOfResColumns method
setColumnXoTypes method
schemaobj_column class
SetObjInfo method
getColumnName method
getTableName method
getTableObj method
getTableOwner method
getTableQualifier method
schemaobj_fkey class
SetObjInfo method
getFKColumnName method
getFKTableName method
getFKTableOwner method
getFKTableQualifier method
getPKColumnName method
getPKTableName method
getPKTableOwner method
getPKTableQualifier method
schemaobj_pkey class
schemaobj_proc class
SetObjInfo method
getOwner method
getProcName method
getQualifier method
schemaobj_proccolumn class
SetObjInfo method
getColumnName method
getOwner method
getProcName method
getQualifier method
schemaobj_stat class
SetObjInfo method
getTableName method
getTableObj method
getTableOwner method
getTableQualifier method
schemaobj_table class
SetObjInfo method
getTableName method
getTableOwner method
getTableQualifier method
xo_tm class
getVal method
Using the setVal method with a selected field
Using the setVal method to set a date
Using the setVal method to set a time
Using setVal to Set a Timestamp
xo_int class
xo_int
getVal method
xo_long class
xo_long
getVal method
xo_short class
xo_short
getVal method
xo_type class
xo_type
getLength method
getNull method
getPrecision method
getRadix method
getScale method
getType method
scalar_function class
Defining a Basic Scalar Function
Using scalar_function method to specify result details
Using the scalar_function method to specify result details and map to a column
Custom scalar functions
SQL Engine core methods API
scalar_function
dam_getSetOfCustomConditionLists
dam_describeCustomCond
dam_describeCustomCondEx2
Using Custom Scalar Functions in a WHERE Clause
Using Custom Scalar Functions With a Java IP
Methods for Java reference
dam_addColAliasxxxValToRow
dam_addError
dam_addErrorEx
dam_addLOBLocatorValToRow
dam_addOutputRow
dam_addResultBufferToTable
dam_addRowBufferToRowTable
dam_addRowToRowSet
dam_addRowToTable
dam_addxxxValToRow
dam_add_schemaobj
dam_allocOutputRow
dam_allocResultBuffer
dam_allocRow
dam_allocRowSet
dam_clearError
dam_compareCol
dam_copyRow
dam_createVal
dam_describeCol
dam_describeColDetail
dam_describeColResAlias
dam_describeColScalar
dam_describeColScalarEx2
dam_describeCond
dam_describeCondEx
dam_describeIndex
dam_describeIndexCol
dam_describeJoinCond
dam_describeJoinTable
dam_describeProcedure
dam_describeScalarEx
dam_describeScalarEx2
dam_describeTable
dam_describeTableByProcessOrder
dam_describeTableCorrelationName
dam_describeTableFunction and dam_describeTableFunctionW
dam_evaluateColCond
dam_freeBulkValue
dam_freeResultBuffer
dam_freeRow
dam_freeSetOfConditionList
dam_getBulkRowStatusArray
dam_getBulkValueToSet
dam_getCol
dam_getColByNameAndType
dam_getColByNum
dam_getColCount
dam_getColInCond
dam_getColOption
dam_getColToSet
dam_getCondRightVal
dam_getCondVal
dam_getFirstCol
dam_getFirstCond
dam_getFirstCondList
dam_getFirstGrantedObject
dam_getFirstGrantee
dam_getFirstIndexCol
dam_getFirstInsertRow
dam_getFirstPrivilege
dam_getFirstSchemaObject
dam_getFirstValExp
dam_getFirstValueSet
dam_getFirstView
dam_getGroupByCol
dam_getInfo
dam_getInputRow
dam_getIP_hcol
dam_getIP_hstmt
dam_getJoinColValue
dam_getJoinQuery
dam_getMemTree
dam_getNextCol
dam_getNextCond
dam_getNextCondList
dam_getNextGrantedObject
dam_getNextGrantee
dam_getNextIndexCol
dam_getNextInsertRow
dam_getNextJoinStmt
dam_getNextPrivilege
dam_getNextSchemaObject
dam_getNextValExp
dam_getNextValueSet
dam_getNextView
dam_getOptimalIndexAndConditions
dam_getOrderByCol
dam_getOriginalQueryParamCount
dam_getOriginalQueryParamValue
dam_getQuery
dam_getQueryFirstResultValue
dam_getQueryNextResultValue
dam_getRestrictionList
dam_getRole
dam_getRowBuffer
dam_getSchemaObjectList
dam_getSetOfConditionListsEx
dam_getTableSearchExp
dam_getTableStmt
dam_getTableFunctionArgList
dam_getUpdateRow
dam_getUpdateRowAsExp
dam_getUser
dam_getValueOfExp
dam_getValueToSet
dam_getValueTypeOfExp
dam_ip_ddl
dam_isSearchPatternObject
dam_isSchemaTableFunction() and dam_isSchemaTableFunctionW
dam_isTableFunction
dam_isTargetRow
dam_isTargetRowForConditionList
dam_setInfo
dam_setIP_hcol
dam_setIP_hstmt
dam_setJoinOrder
dam_setOption
Connection Options Values for dam_setOption
Statement Options for dam_setOption
Condition List Options for dam_setOption
dam_strlikecmp
tm_trace
SQL Engine parse tree methods for Java
Pass-through query processing
SQL pass-through and advanced query methods reference
damex_addxxxColValToRow
damex_addResultBufferToTable
damex_addxxxResValToRow
damex_addRowToTable
damex_allocResultBuffer
damex_allocRow
damex_describeCaseElem
damex_describeCaseValExp
damex_describeCol
damex_describeCond
damex_describeDataChainVal
damex_describeDeleteQuery
damex_describeInsertQuery
damex_describeLogicExp
damex_describeOrderByExp
damex_describeScalarValExp
damex_describeScalarValExpEx2
damex_describeSelectQuery
damex_describeSelectTopClause
damex_describeTable
damex_describeTableFunction and damex_describeTableFunctionW
damex_describeTableJoinInfo
damex_describeUpdateQuery
damex_describeVal
damex_describeValExp
damex_describeValExpEx
damex_freeResultBuffer
damex_getCol
damex_getColByNum
damex_getFirstCaseElem
damex_getFirstCol
damex_getFirstColInList
damex_getFirstInsertRow
damex_getFirstInsertValExp
damex_getFirstTable
damex_getFirstUpdateSet
damex_getFirstValExp
damex_getNextCaseElem
damex_getNextCol
damex_getNextColInList
damex_getNextInsertRow
damex_getNextInsertValExp
damex_getNextTable
damex_getNextUpdateSet
damex_getNextValExp
damex_getQuery
damex_getQueryType
damex_getTable
damex_getTableByNum
Setting Up the samples
Description of the samples
Static schema: example1
Dynamic schema: example3
Dynamic schema: memory
Setting up a sample on Windows
Setting up a sample on Linux/UNIX
Embedding OpenAccess SDK Server in Java applications
Java API
oasload.OaServerControl
Sample For Windows
Files for embedding in Java applications
Compiling Java sample
Running Java sample
Sample for UNIX
Files for embedding in Java applications
Running Java sample in install_dir/shlibsrv
Remarks
Deploying on a JBoss Application server
Installing the JBoss sample on Windows
Configuring JBoss
Running the application
Setting up your development environment for an IP
Running the application