Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user IT Stonebranch

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Macro name changed from html to html-bobswift during server to cloud migration processing.

...

dbUrlexportReleaseLevelexportTable nameopswiseGroups

Business Services that this record belongs to.
 
XML

 
JSON

retainSysIds

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 - DatabasedbUrl - Database

Connection URL

URL of the database.

Y

Anchor
exportReleaseLevel - DatabaseexportReleaseLevel - Databasen/a

Universal Controller release that the record was exported from.

read onlyN
Anchor
exportTable - DatabaseexportTable - Databasen/aRecord table information.read onlyN
Anchor
name - Databasename - Database

Connection Name

Name used within the Controller to identify this Database Connection.

Y

Anchor
opswiseGroups - DatabaseopswiseGroups - Database

Member of Business Services

Panel


Panel

N

Anchor
retainSysIds - DatabaseretainSysIds - Database

n/a

Specification for whether or not the Create a Database Connection web service will persist the sysId property.
Html bobswift
<ul>
<li> As String = MySQL (or My SQL), As Value = 1
<li> As String = MS SQL Server, As Value = 2
<li> As String = Oracle, As Value = 3
<li> As String = DB2, As Value = 4
<li> As String = Sybase SQL Anywhere, As Value = 5
<li> As String = Other, As Value = 6
</ul>


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 onlyN

Anchor
exportTable - Database
exportTable - Database
exportTable

n/aRecord table information.read onlyN

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
Html bobswift
<pre>
&lt;opswiseGroups&gt;
      &lt;opswiseGroup&gt;group1&lt;/opswiseGroup&gt;
      &lt;opswiseGroup&gt;group2&lt;/opswiseGroup&gt;
&lt;/opswiseGroups&gt;
</pre>


 
JSON


Panel
Html bobswift
<pre>
"opswiseGroups": ["group1","group2"]
</pre>


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.


Html bobswift
<ul>
<li> If <b>retainSysIds</b>="true" and <code>sysId</code> is included in the request/response, <code>sysId</code> will be persisted to the database.
<li> If <b>retainSysIds</b>="false" and  <code>sysId</code> is included in the request/response, <code>sysId</code> will be ignored; it will be autogenerated by the Controller. 
</ul>



Note
titleNote

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

...