Platforms to show: All Mac Windows Linux Cross-Platform
Back to JavaCallableStatementMBS class.
JavaCallableStatementMBS.Constructor Private
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 15.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
JavaCallableStatementMBS.getBlob(parameterIndex as Integer) as JavaBlobMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
See also:
JavaCallableStatementMBS.getBlob(parameterName as string) as JavaBlobMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
See also:
JavaCallableStatementMBS.getBoolean(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is false.
See also:
JavaCallableStatementMBS.getBoolean(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is false.
See also:
JavaCallableStatementMBS.getByte(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getByte(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getClob(parameterIndex as Integer) as JavaClobMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Parameters:
i - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
See also:
JavaCallableStatementMBS.getClob(parameterName as string) as JavaClobMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
See also:
JavaCallableStatementMBS.getDouble(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getDouble(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getFloat(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getFloat(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getInt(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getInt(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getLong(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getLong(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getShort(parameterIndex as Integer) 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 |
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getShort(parameterName as string) 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 |
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is 0.
See also:
JavaCallableStatementMBS.getString(parameterIndex as Integer) 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 |
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, and so on
Returns:
the parameter value. If the value is SQL NULL, the result is null.
See also:
JavaCallableStatementMBS.getString(parameterName as string) 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 |
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
Parameters:
parameterName - the name of the parameter
Returns:
the parameter value. If the value is SQL NULL, the result is null.
See also:
JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, 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 |
All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject(int) retrieves the value.
parameterIndex - the first parameter is 1, the second is 2, and so on
sqlType - the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- registerOutParameter(parameterName as string, sqlType as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale 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 |
This method must be called before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.
parameterIndex - the first parameter is 1, the second is 2, and so on
sqlType - the SQL type code defined by java.sql.Types.
scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- registerOutParameter(parameterName as string, sqlType as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
JavaCallableStatementMBS.registerOutParameter(parameterIndex as Integer, 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 |
This version of the method registerOutParameter should be used for a user-defined or REF output parameter. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-defined parameter, the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-defined and REF parameters. Although it is intended for user-defined and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.
Parameters:
paramIndex - the first parameter is 1, the second is 2,...
sqlType - a value from Types
typeName - the fully-qualified name of an SQL structured type
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
JavaCallableStatementMBS.registerOutParameter(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 |
Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method getObject(int) retrieves the value.
Parameters:
parameterName - the name of the parameter
sqlType - the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
JavaCallableStatementMBS.registerOutParameter(parameterName as string, sqlType as Integer, scale 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 |
This method must be called before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.
Parameters:
parameterName - the name of the parameter
sqlType - SQL type code defined by java.sql.Types.
scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- registerOutParameter(parameterName as string, sqlType as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
JavaCallableStatementMBS.registerOutParameter(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 |
This version of the method registerOutParameter should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly call registerOutParameter to register the type from java.sql.Types for each OUT parameter. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters. Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.
Parameters:
parameterName - the name of the parameter
sqlType - a value from Types
typeName - the fully-qualified name of an SQL structured type
See also:
- registerOutParameter(parameterIndex as Integer, sqlType as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
- registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
- registerOutParameter(parameterName as string, sqlType as Integer)
- registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
JavaCallableStatementMBS.setBoolean(parameterName as string, x 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 |
The driver converts this to an SQL BIT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value
JavaCallableStatementMBS.setByte(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 |
The driver converts this to an SQL TINYINT value when it sends it to the database.
Parameters:
parameterName - the name of the parameter
x - the parameter value
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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
The items on this page are in the following plugins: MBS Java Plugin.