BBjJdbcOdbcInfo

Description

In BBj 8.0 and higher, the BBjVector of BBjJdbcOdbcInfo objects provides programmatic access to information about all JDBC and ODBC connections within the current BBjServices environment.

Creation

BBjAPI > BBjAdmin > BBjJdbcOdbcInfo

A BBjVector containing all active BBjJdbcOdbcInfo objects is created through the following BBjAdmin object method:

Return Value

Method

BBjVector

getJdbcOdbcConnections()

Methods of BBjJdbcOdbcInfo

Return Value

Method

void

close()

string

getConnectTime()

string

getDatabase()

string

getHost()

int

getID()

string

getUser()

Remarks

None.

Constants

None.

Example

rem 'Retrieve all active BBjJdbcOdbcConnection Objects

input "Enter User ID: ",userid$
input "Enter Password: ",password$
admin! = BBjAPI().getAdmin(userid$,password$)
vector! = admin!.getJdbcOdbcConnections()
print "Database",@(20),"OpenID",@(26),"Userid",@(36),"Host",
print @(56),"Connect Time"
for i = 0 to vector!.size()-1
    info! = vector!.get(i)
    print @(0),str(info!.getDatabase()),
    : @(20),str(info!.getID ()),
    : @(26),str(info!.getUser()),
    : @(36),str(info!.getHost()),
    : @(56),str(info!.getConnectTime())
next i
stop

See Also

BBjAPI

BBj Object Variables

See the BBj Object Diagram for an illustration of the relationship between BBj Objects.