Page Comparison

...

Property

UI Field Name

Description

Specifications

Required

Anchor

	credentials - Database
	credentials - Database

credentials

Credentials

Credentials for this Database Connection.

N

Anchor

	dbDescription - Database
	dbDescription - Database

dbDescription

Description

Description of this record.

N

Anchor

	dbDriver - Database
	dbDriver - Database

dbDriver

Driver

Name of the JDBC driver.

Y

Anchor

	dbMaxRows - Database
	dbMaxRows - Database

dbMaxRows

Maximum Rows

If necessary, specifies a limit to the number of rows you want returned by the SQL statement.

N

Anchor

	dbType - Database
	dbType - Database

dbType

Database Type

Type of Database.

Valid Values:

Default is MySQL (1).

Y

Anchor

	dbUrl - Database
	dbUrl - Database

dbUrl

Connection URL

URL of the database.

Y

Anchor

	exportReleaseLevel - Database
	exportReleaseLevel - Database

exportReleaseLevel

n/a

Universal Controller release that the record was exported from.

read only

N

Anchor

	exportTable - Database
	exportTable - Database

exportTable

n/a

Record table information.

read only

N

Anchor

	name - Database
	name - Database

name

Connection Name

Name used within the Controller to identify this Database Connection.

Y

Anchor

	opswiseGroups - Database
	opswiseGroups - Database

opswiseGroups

Member of Business Services

Business Services that this record belongs to.

XML

Panel

JSON

Panel

N

Anchor

	retainSysIds - Database
	retainSysIds - Database

retainSysIds

n/a

Specification for whether or not the Create a Database Connection web service will persist the sysId property.

Note

title	Note

In XML web services, retainSysIds is specified as an attribute in the <databaseConnection> element.

Valid values: true/false (default is true).

N

Anchor

	sysId - Database
	sysId - Database

sysId

n/a

System ID field in the database for this Database Connection record.

Persisted only if retainSysIds is set to true.

N

...

XML Response

JSON Response

Expand

title	XML Response

<databaseConnections>  
    <databaseConnection exportReleaseLevel="7.2.0.0" exportTable="ops_database_connection" version="3">
        <credentials />
        <dbDescription />
        <dbDriver>com.mysql.jdbc.Driver</dbDriver>
        <dbMaxRows />
        <dbType>My SQL</dbType>
        <dbUrl>jjdbc:mysql://localhost:3306/uc</dbUrl>
        <name>Database Connection 1</name>
        <opswiseGroups />
        <sysId>62701879a6264107bb757a952bcc65cc</sysId>
    </databaseConnection>
    <databaseConnection exportReleaseLevel="7.2.0.0" exportTable="ops_database_connection" version="6">
        <credentials />
        <dbDescription />
        <dbDriver>com.mysql.jdbc.Driver</dbDriver>
        <dbMaxRows />
        <dbType>My SQL</dbType>
        <dbUrl>jdbc:mysql://localhost:3306/uc</dbUrl>
        <name>Database Connection 2</name>
        <opswiseGroups />
        <sysId>3d7a03053ad64de1b21b6849e6deafd9</sysId>
    </databaseConnection>
<databaseConnections>

Expand

title	JSON Response

[ 
    {
    "credentials": null,
    "dbDriver": "com.mysql.jdbc.Driver",
    "dbMaxRows": null,
    "dbType": "My SQL",
    "dbUrl": "jdbc:mysql://localhost:3306/uc",/uc",
    "dbDescription": null,
    "exportReleaseLevel": "7.2.0.0",
     "dbDescriptionexportTable": null,"ops_database_connection",
     "name": "Database Connection 1",
    "opswiseGroups": null,
    "sysId": "62701879a6264107bb757a952bcc65cc",
    "version": 3
    },
    {
    "credentials": null,
    "dbDescription": null,
    "dbDriver": "com.mysql.jdbc.Driver",
    "dbMaxRows": null,
    "dbType": "My SQL",
    "dbUrl": "jdbc:mysql://localhost:3306/uc",
    "exportReleaseLevel": "7.2.0.0",
    "exportTable": "ops_database_connection",
    "name": "Database Connection 2",
    "opswiseGroups": null,
    "sysId": "3d7a03053ad64de1b21b6849e6deafd9",
    "version": 6
    }
]

...

Versions Compared

Old Version 4

New Version 5

Key