Package org.mariadb.jdbc

Class CallableParameterMetaData

java.lang.Object

org.mariadb.jdbc.CallableParameterMetaData

All Implemented Interfaces:

ParameterMetaData, Wrapper

public class CallableParameterMetaData
extends Object
implements ParameterMetaData

Field Summary

Fields

Modifier and Type	Field	Description
private final MariaDbConnection	con
private String	database
private boolean	isFunction
private final String	name
private static final Pattern	PARAMETER_PATTERN
private List<CallParameter>	params
private static final Pattern	RETURN_PATTERN
private boolean	valid

Fields inherited from interface java.sql.ParameterMetaData

parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown

Constructor Summary

Constructors

Constructor	Description
CallableParameterMetaData(MariaDbConnection con, String database, String name, boolean isFunction)	Retrieve Callable metaData.

Method Summary

Modifier and Type	Method	Description
String	getName(int param)
private CallParameter	getParam(int index)
String	getParameterClassName(int param)
int	getParameterCount()
int	getParameterMode(int param)	Get mode info.
int	getParameterType(int param)
String	getParameterTypeName(int param)
int	getPrecision(int param)
int	getScale(int param)
int	isNullable(int param)
boolean	isSigned(int param)
boolean	isWrapperFor(Class<?> iface)
private int	mapMariaDbTypeToJdbc(String str)
private void	parseFunctionReturnParam(String functionReturn)
private void	parseParamList(boolean isFunction, String paramList)
private String[]	queryMetaInfos(boolean isFunction)
private void	readMetadata()	Read procedure metadata from mysql.proc table(column param_list).
void	readMetadataFromDbIfRequired()	Search metaData if not already loaded.
<T> T	unwrap(Class<T> iface)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

PARAMETER_PATTERN

private static final Pattern PARAMETER_PATTERN

RETURN_PATTERN

private static final Pattern RETURN_PATTERN

con

private final MariaDbConnection con

name

private final String name

params

private List<CallParameter> params

database

private String database

valid

private boolean valid

isFunction

private boolean isFunction

Constructor Details

CallableParameterMetaData

public CallableParameterMetaData(MariaDbConnection con,
 String database,
 String name,
 boolean isFunction)

Retrieve Callable metaData.

Parameters:

con - connection

database - database name

name - procedure/function name

isFunction - is it a function

Method Details

readMetadataFromDbIfRequired

public void readMetadataFromDbIfRequired()
                                  throws SQLException

Search metaData if not already loaded.

Throws:

SQLException - if error append during loading metaData

mapMariaDbTypeToJdbc

private int mapMariaDbTypeToJdbc(String str)

queryMetaInfos

private String[] queryMetaInfos(boolean isFunction)
                         throws SQLException

Throws:

SQLException

parseFunctionReturnParam

private void parseFunctionReturnParam(String functionReturn)
                               throws SQLException

Throws:

SQLException

parseParamList

private void parseParamList(boolean isFunction,
 String paramList)
                     throws SQLException

Throws:

SQLException

readMetadata

private void readMetadata()
                   throws SQLException

Read procedure metadata from mysql.proc table(column param_list).

Throws:

SQLException - if data doesn't correspond.

getParameterCount

public int getParameterCount()

Specified by:

getParameterCount in interface ParameterMetaData

getParam

private CallParameter getParam(int index)
                        throws SQLException

Throws:

SQLException

isNullable

public int isNullable(int param)
               throws SQLException

Specified by:

isNullable in interface ParameterMetaData

Throws:

SQLException

isSigned

public boolean isSigned(int param)
                 throws SQLException

Specified by:

isSigned in interface ParameterMetaData

Throws:

SQLException

getPrecision

public int getPrecision(int param)
                 throws SQLException

Specified by:

getPrecision in interface ParameterMetaData

Throws:

SQLException

getScale

public int getScale(int param)
             throws SQLException

Specified by:

getScale in interface ParameterMetaData

Throws:

SQLException

getParameterType

public int getParameterType(int param)
                     throws SQLException

Specified by:

getParameterType in interface ParameterMetaData

Throws:

SQLException

getParameterTypeName

public String getParameterTypeName(int param)
                            throws SQLException

Specified by:

getParameterTypeName in interface ParameterMetaData

Throws:

SQLException

getParameterClassName

public String getParameterClassName(int param)
                             throws SQLException

Specified by:

getParameterClassName in interface ParameterMetaData

Throws:

SQLException

getParameterMode

public int getParameterMode(int param)
                     throws SQLException

Get mode info.

• 0 : unknown
• 1 : IN
• 2 : INOUT
• 4 : OUT

Specified by:

getParameterMode in interface ParameterMetaData

Parameters:

param - parameter index

Returns:

mode information

Throws:

SQLException - if index is wrong

getName

public String getName(int param)
               throws SQLException

Throws:

SQLException

unwrap

public <T> T unwrap(Class<T> iface)

Specified by:

unwrap in interface Wrapper

isWrapperFor

public boolean isWrapperFor(Class<?> iface)

Specified by:

isWrapperFor in interface Wrapper