Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

JavaCallableStatementMBS class

Super class: JavaStatementMBS

Type Topic Plugin Version macOS Windows Linux Console & Web iOS
class Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The REALbasic class to handle a CallableStatement in Java.
Notes:
The interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.

{?= call <procedure-name>[<arg1>,<arg2>, ...]}
{call <procedure-name>[<arg1>,<arg2>, ...]}

IN parameter values are set using the set methods inherited from PreparedStatement. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get methods provided here.

A CallableStatement can return one ResultSet object or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from Statement.

For maximum portability, a call's ResultSet objects and update counts should be processed prior to getting the values of output parameters.
Subclass of the JavaStatementMBS class.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.

Feedback, Comments & Corrections

  • 38 methods
    • method Constructor
    • method getBlob(parameterIndex as Integer) as JavaBlobMBS
    • method getBlob(parameterName as string) as JavaBlobMBS
    • method getBoolean(parameterIndex as Integer) as boolean
    • method getBoolean(parameterName as string) as boolean
    • method getByte(parameterIndex as Integer) as Integer
    • method getByte(parameterName as string) as Integer
    • method getClob(parameterIndex as Integer) as JavaClobMBS
    • method getClob(parameterName as string) as JavaClobMBS
    • method getDouble(parameterIndex as Integer) as Double
    • method getDouble(parameterName as string) as Double
    • method getFloat(parameterIndex as Integer) as single
    • method getFloat(parameterName as string) as single
    • method getInt(parameterIndex as Integer) as Integer
    • method getInt(parameterName as string) as Integer
    • method getLong(parameterIndex as Integer) as Int64
    • method getLong(parameterName as string) as Int64
    • method getShort(parameterIndex as Integer) as Integer
    • method getShort(parameterName as string) as Integer
    • method getString(parameterIndex as Integer) as String
    • method getString(parameterName as string) as String
    • method registerOutParameter(parameterIndex as Integer, sqlType as Integer)
    • method registerOutParameter(parameterIndex as Integer, sqlType as Integer, scale as Integer)
    • method registerOutParameter(parameterIndex as Integer, sqlType as Integer, typeName as string)
    • method registerOutParameter(parameterName as string, sqlType as Integer)
    • method registerOutParameter(parameterName as string, sqlType as Integer, scale as Integer)
    • method registerOutParameter(parameterName as string, sqlType as Integer, typeName as string)
    • method setBoolean(parameterName as string, x as boolean)
    • method setByte(parameterName as string, x as Integer)
    • method setDouble(parameterName as string, x as Double)
    • method setFloat(parameterName as string, x as single)
    • method setInt(parameterName as string, x as Integer)
    • method setLong(parameterName as string, x as int64)
    • method setNull(parameterName as string, sqlType as Integer)
    • method setNull(parameterName as string, sqlType as Integer, typeName as string)
    • method setShort(parameterName as string, x as Integer)
    • method setString(parameterName as string, x as string)
    • method wasNull as boolean

Super class JavaStatementMBS

Super class JavaObjectMBS

This class has no sub classes.

Some methods using this class:


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


JavaByteArrayMBS   -   JavaCharArrayMBS





Links
MBS Xojo tutorial videos