Platforms to show: All Mac Windows Linux Cross-Platform

Back to JavaCallableStatementMBS class.

Previous items

JavaCallableStatementMBS.setDouble(parameterName as string, x as Double)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java double value.

The driver converts this to an SQL DOUBLE value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.setFloat(parameterName as string, x as single)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java float value.

The driver converts this to an SQL FLOAT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.setInt(parameterName as string, x as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java int value.

The driver converts this to an SQL INTEGER value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.setLong(parameterName as string, x as int64)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java long value.

The driver converts this to an SQL BIGINT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.setNull(parameterName as string, sqlType as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to SQL NULL.

Note: You must specify the parameter's SQL type.

Parameters:
parameterName - the name of the parameter
sqlType - the SQL type code defined in java.sql.Types

See also:

JavaCallableStatementMBS.setNull(parameterName as string, sqlType as Integer, typeName as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to SQL NULL.

This version of the method setNull should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.

Parameters:
parameterName - the name of the parameter
sqlType - a value from java.sql.Types
typeName - the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value

See also:

JavaCallableStatementMBS.setShort(parameterName as string, x as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java short value.

The driver converts this to an SQL SMALLINT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.setString(parameterName as string, x as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Sets the designated parameter to the given Java String value.

The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value

JavaCallableStatementMBS.wasNull as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Retrieves whether the last OUT parameter read had the value of SQL NULL.

Note that this method should be called only after calling a getter method; otherwise, there is no value to use in determining whether it is null or not.

Returns:
true if the last parameter read was SQL NULL; false otherwise

Previous items

The items on this page are in the following plugins: MBS Java Plugin.


💬 Ask a question or report a problem
The biggest plugin in space...