Package com.oracle.bmc.databasemanagement.model

Class CreateSqlJobDetails

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.databasemanagement.model.CreateJobDetails

com.oracle.bmc.databasemanagement.model.CreateSqlJobDetails

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class CreateSqlJobDetails
extends CreateJobDetails

The details specific to the SQL job request.
Note: Objects should always be created or deserialized using the CreateSqlJobDetails.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the CreateSqlJobDetails.Builder, which maintain a set of all explicitly set fields called CreateSqlJobDetails.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	CreateSqlJobDetails.Builder

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors

Constructor

Description

CreateSqlJobDetails(String name, String description, String compartmentId, String managedDatabaseGroupId, String managedDatabaseId, DatabaseSubType databaseSubType, Job.ScheduleType scheduleType, String timeout, JobExecutionResultLocation resultLocation, JobScheduleDetails scheduleDetails, String sqlText, JobInBindsDetails inBinds, JobOutBindsDetails outBinds, SqlJob.SqlType sqlType, SqlJob.OperationType operationType, String userName, String password, String secretId, String namedCredentialId, SqlJob.Role role, Map<String,String> freeformTags, Map<String,Map<String,Object>> definedTags)

Deprecated.

Method Summary

Modifier and Type	Method	Description
static CreateSqlJobDetails.Builder	builder()	Create a new builder.
boolean	equals(Object o)
Map<String,Map<String,Object>>	getDefinedTags()	Defined tags for this resource.
Map<String,String>	getFreeformTags()	Free-form tags for this resource.
JobInBindsDetails	getInBinds()
String	getNamedCredentialId()	The OCID of the Named Credentials containing password secret.
SqlJob.OperationType	getOperationType()	The SQL operation type.
JobOutBindsDetails	getOutBinds()
String	getPassword()	The password for the database user name used to execute the SQL job.
SqlJob.Role	getRole()	The role of the database user.
String	getSecretId()	The OCID of the secret containing the user password.
String	getSqlText()	The SQL text to be executed as part of the job.
SqlJob.SqlType	getSqlType()
String	getUserName()	The database user name used to execute the SQL job.
int	hashCode()
CreateSqlJobDetails.Builder	toBuilder()
String	toString()
String	toString(boolean includeByteArrayContents)	Return a string representation of the object.

Methods inherited from class com.oracle.bmc.databasemanagement.model.CreateJobDetails

getCompartmentId, getDatabaseSubType, getDescription, getManagedDatabaseGroupId, getManagedDatabaseId, getName, getResultLocation, getScheduleDetails, getScheduleType, getTimeout

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

CreateSqlJobDetails

@Deprecated
public CreateSqlJobDetails(String name,
                           String description,
                           String compartmentId,
                           String managedDatabaseGroupId,
                           String managedDatabaseId,
                           DatabaseSubType databaseSubType,
                           Job.ScheduleType scheduleType,
                           String timeout,
                           JobExecutionResultLocation resultLocation,
                           JobScheduleDetails scheduleDetails,
                           String sqlText,
                           JobInBindsDetails inBinds,
                           JobOutBindsDetails outBinds,
                           SqlJob.SqlType sqlType,
                           SqlJob.OperationType operationType,
                           String userName,
                           String password,
                           String secretId,
                           String namedCredentialId,
                           SqlJob.Role role,
                           Map<String,String> freeformTags,
                           Map<String,Map<String,Object>> definedTags)

Deprecated.

Method Detail

builder

public static CreateSqlJobDetails.Builder builder()

Create a new builder.

toBuilder

public CreateSqlJobDetails.Builder toBuilder()

getSqlText

public String getSqlText()

The SQL text to be executed as part of the job.

Returns:

the value

getInBinds

public JobInBindsDetails getInBinds()

getOutBinds

public JobOutBindsDetails getOutBinds()

getSqlType

public SqlJob.SqlType getSqlType()

getOperationType

public SqlJob.OperationType getOperationType()

The SQL operation type.

Returns:

the value

getUserName

public String getUserName()

The database user name used to execute the SQL job.

If the job is being executed on a Managed Database Group, then the user name should exist on all the databases in the group with the same password.

Returns:

the value

getPassword

public String getPassword()

The password for the database user name used to execute the SQL job.

Returns:

the value

getSecretId

public String getSecretId()

The OCID of the secret containing the user password.

Returns:

the value

getNamedCredentialId

public String getNamedCredentialId()

The OCID of the Named Credentials containing password secret.

Returns:

the value

getRole

public SqlJob.Role getRole()

The role of the database user.

Indicates whether the database user is a normal user or sysdba.

Returns:

the value

getFreeformTags

public Map<String,String> getFreeformTags()

Free-form tags for this resource.

Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}

Returns:

the value

getDefinedTags

public Map<String,Map<String,Object>> getDefinedTags()

Defined tags for this resource.

Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {“Operations”: {“CostCenter”: “42”}}

Returns:

the value

toString

public String toString()

Overrides:

toString in class CreateJobDetails

toString

public String toString(boolean includeByteArrayContents)

Return a string representation of the object.

Overrides:

toString in class CreateJobDetails

Parameters:

includeByteArrayContents - true to include the full contents of byte arrays

Returns:

string representation

equals

public boolean equals(Object o)

Overrides:

equals in class CreateJobDetails

hashCode

public int hashCode()

Overrides:

hashCode in class CreateJobDetails