java.sql

Interface ParameterMetaData

public interface ParameterMetaData

An object that can be used to get information about the types and properties of the parameters in a PreparedStatement object.
Since:
1.4

Field Summary

static int
parameterModeIn
The constant indicating that the parameter's mode is IN.
static int
parameterModeInOut
The constant indicating that the parameter's mode is INOUT.
static int
parameterModeOut
The constant indicating that the parameter's mode is OUT.
static int
parameterModeUnknown
The constant indicating that the mode of the parameter is unknown.
static int
parameterNoNulls
The constant indicating that a parameter will not allow NULL values.
static int
parameterNullable
The constant indicating that a parameter will allow NULL values.
static int
parameterNullableUnknown
The constant indicating that the nullability of a parameter is unknown.

Method Summary

String
getParameterClassName(int param)
Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.
int
getParameterCount()
Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.
int
getParameterMode(int param)
Retrieves the designated parameter's mode.
int
getParameterType(int param)
Retrieves the designated parameter's SQL type.
String
getParameterTypeName(int param)
Retrieves the designated parameter's database-specific type name.
int
getPrecision(int param)
Retrieves the designated parameter's number of decimal digits.
int
getScale(int param)
Retrieves the designated parameter's number of digits to right of the decimal point.
int
isNullable(int param)
Retrieves whether null values are allowed in the designated parameter.
boolean
isSigned(int param)
Retrieves whether values for the designated parameter can be signed numbers.

Field Details

parameterModeIn

public static final int parameterModeIn
The constant indicating that the parameter's mode is IN.
Field Value:
1
Usages and Demos :

View More Examples of ParameterMetaData.parameterModeIn
   1:                 return java.sql.ParameterMetaData.parameterModeUnknown;
   2:             } else if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeIn) {
   3:         ...
   4:                 return java.sql.ParameterMetaData.parameterModeIn;
   5:             } else if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeOut) {
   6:                 return java.sql.ParameterMetaData.parameterModeOut;
   7:             } else {

View Full Code Here
   1:     private boolean isParameterModeGuessedAsAnInput(int parameterIndex) {
   2:         if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeIn ||
   3:                 sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeInOut) {
   4:         ...
   5:         } else if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeUnknown) {
   6:             sqlxParmmode_[parameterIndex - 1] = java.sql.ParameterMetaData.parameterModeIn;
   7:         }
   8:         ...
   9:     private void setParmModeForOutputParameter(int parameterIndex) {
  10:         if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeIn) {
  11:             sqlxParmmode_[parameterIndex - 1] = java.sql.ParameterMetaData.parameterModeInOut;

View Full Code Here

parameterModeInOut

public static final int parameterModeInOut
The constant indicating that the parameter's mode is INOUT.
Field Value:
2
Usages and Demos :

View More Examples of ParameterMetaData.parameterModeInOut
   1:             } else {
   2:                 return java.sql.ParameterMetaData.parameterModeInOut;
   3:             }
   4:         }
   5:         catch ( SqlException se )

View Full Code Here
   1:             if (mode == ParameterMetaData.parameterModeIn
   2:                     || mode == ParameterMetaData.parameterModeInOut) {
   3:                 Object parmValue = context.getParameterValue(treePath);
   4:         ...
   5:             isParameterOutput[i] = (
   6:                     mode == ParameterMetaData.parameterModeInOut ||
   7:                     mode == ParameterMetaData.parameterModeOut
   8:             );
   9:             if (isParameterOutput[i]) {

View Full Code Here
   1:         if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeIn ||
   2:                 sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeInOut) {
   3:             return true;
   4:         ...
   5:     public boolean isParameterModeGuessedAsOutput(int parameterIndex) {
   6:         return sqlxParmmode_[parameterIndex - 1] >= java.sql.ParameterMetaData.parameterModeInOut;
   7:     }
   8:         ...
   9:         if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeOut) {
  10:             sqlxParmmode_[parameterIndex - 1] = java.sql.ParameterMetaData.parameterModeInOut;
  11:         } else if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeUnknown) {

View Full Code Here

parameterModeOut

public static final int parameterModeOut
The constant indicating that the parameter's mode is OUT.
Field Value:
4
Usages and Demos :

View More Examples of ParameterMetaData.parameterModeOut
   1:                 return java.sql.ParameterMetaData.parameterModeIn;
   2:             } else if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeOut) {
   3:         ...
   4:                 return java.sql.ParameterMetaData.parameterModeOut;
   5:             } else {
   6:                 return java.sql.ParameterMetaData.parameterModeInOut;
   7:             }

View Full Code Here
   1:     private void setParmModeForInputParameter(int parameterIndex) {
   2:         if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeOut) {
   3:             sqlxParmmode_[parameterIndex - 1] = java.sql.ParameterMetaData.parameterModeInOut;
   4:         ...
   5:         } else if (sqlxParmmode_[parameterIndex - 1] == java.sql.ParameterMetaData.parameterModeUnknown) {
   6:             sqlxParmmode_[parameterIndex - 1] = java.sql.ParameterMetaData.parameterModeOut;
   7:         }
   8:     }

View Full Code Here

parameterModeUnknown

public static final int parameterModeUnknown
The constant indicating that the mode of the parameter is unknown.
Field Value:
0
Usages and Demos :

View More Examples of ParameterMetaData.parameterModeUnknown
   1:             columnMetaData_.checkForValidColumnIndex(param);
   2:             if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeUnknown) {
   3:         ...
   4:                 return java.sql.ParameterMetaData.parameterModeUnknown;
   5:             } else if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeIn) {
   6:                 return java.sql.ParameterMetaData.parameterModeIn;
   7:             } else if (columnMetaData_.sqlxParmmode_[param - 1] == java.sql.ParameterMetaData.parameterModeOut) {

View Full Code Here

parameterNoNulls

public static final int parameterNoNulls
The constant indicating that a parameter will not allow NULL values.
Field Value:
0

parameterNullable

public static final int parameterNullable
The constant indicating that a parameter will allow NULL values.
Field Value:
1

parameterNullableUnknown

public static final int parameterNullableUnknown
The constant indicating that the nullability of a parameter is unknown.
Field Value:
2

Method Details

getParameterClassName

public String getParameterClassName(int param)
            throws SQLException
Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
the fully-qualified name of the class in the Java programming language that would be used by the method PreparedStatement.setObject to set the value in the specified parameter. This is the class name used for custom mapping.
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getParameterClassName(int param)
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:                 int paramCount = paramMetaData.getParameterCount();
  12:         ...
  13:                     System.out.println("param SQL type name="+ paramTypeName);
  14:                     String paramClassName = paramMetaData.getParameterClassName(param);

View Full Code Here
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: 
  10: String paramClassName = metadata.getParameterClassName(param);
  11: builder.append("<className>");
  12:         ...
  13: int paramMode = metadata.getParameterMode(param);
  14: if (paramMode == ParameterMetaData.parameterModeOut){

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                   DRDAStatement stmt,
  10:                                   ParameterMetaData pmeta)
  11:                 throws DRDAProtocolException, SQLException
  12:         ...
  13:                 int type =  DRDAStatement.getOutputParameterTypeFromClassName(
  14:                                                                               pmeta.getParameterClassName(jdbcElemNum));

View Full Code Here

getParameterCount

public int getParameterCount()
            throws SQLException
Retrieves the number of parameters in the PreparedStatement object for which this ParameterMetaData object contains information.
Returns:
the number of parameters
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getParameterCount()
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select badge_number, last_name " +
   4:         ...
   5:            if (paramMetaData == null) {
   6:              System.out.println("db vendor does NOT support ParameterMetaData");
   7:            }
   8:         ...
   9:            else {
  10:              System.out.println("db vendor supports ParameterMetaData");
  11:         ...
  12:              int paramCount = paramMetaData.getParameterCount();

View Full Code Here
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String create = "create table sample_table"+
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:         ...
  12:                 int paramCount = paramMetaData.getParameterCount();

View Full Code Here
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select badge_number, last_name " +
   4:         ...
   5:            oracle.jdbc.OracleParameterMetaData  oparamMetaData  = opstmt.OracleGetParameterMetaData();
   6:            paramMetaData = (ParameterMetaData) oparamMetaData;
   7:            if (paramMetaData == null) {
   8:         ...
   9:              System.out.println("db vendor does NOT support ParameterMetaData");
  10:            }
  11:         ...
  12:              System.out.println("db vendor supports ParameterMetaData");
  13:              int paramCount = paramMetaData.getParameterCount();

View Full Code Here
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:            if (paramMetaData == null) {
   6:              System.out.println("db vendor does NOT support ParameterMetaData");
   7:            }
   8:         ...
   9:            else {
  10:              System.out.println("db vendor supports ParameterMetaData");
  11:         ...
  12:              int paramCount = paramMetaData.getParameterCount();

View Full Code Here
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:         ...
  12:                 int paramCount = paramMetaData.getParameterCount();

View Full Code Here

getParameterMode

public int getParameterMode(int param)
            throws SQLException
Retrieves the designated parameter's mode.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
mode of the parameter; one of ParameterMetaData.parameterModeIn, ParameterMetaData.parameterModeOut, or ParameterMetaData.parameterModeInOut ParameterMetaData.parameterModeUnknown.
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getParameterMode(int param)
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:                 int paramCount = paramMetaData.getParameterCount();
  12:         ...
  13:                     System.out.println("param class name="+ paramClassName);
  14:                     int paramMode = paramMetaData.getParameterMode(param);

View Full Code Here
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: builder.append("<mode>");
  10: int paramMode = metadata.getParameterMode(param);
  11:         ...
  12: if (paramMode == ParameterMetaData.parameterModeOut){

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.ResultSet;
   4:         ...
   5: 
   6:         ParameterMetaData metaData = cs.getParameterMetaData();
   7:         int parmCount = metaData.getParameterCount();
   8:         ...
   9:             String treePath = parsed.getParameterName(i);
  10:             int mode = metaData.getParameterMode(parameterIndex);
  11:         ...
  12:             if (mode == ParameterMetaData.parameterModeIn

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                     trace("******param null");
  10:                                 if (pmeta.getParameterMode(i + 1) 
  11:                                     != JDBC30Translation.PARAMETER_MODE_OUT )
  12:         ...
  13:                                   DRDAStatement stmt,
  14:                                   ParameterMetaData pmeta)

View Full Code Here

getParameterType

public int getParameterType(int param)
            throws SQLException
Retrieves the designated parameter's SQL type.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
SQL type from java.sql.Types
Throws:
SQLException - if a database access error occurs
Since:
1.4
See Also:
Types
Usages and Demos :

View More Examples of getParameterType(int param)
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:                 int paramCount = paramMetaData.getParameterCount();
  12:         ...
  13:                     System.out.println("param number="+param);
  14:                     int sqlTypeCode = paramMetaData.getParameterType(param);

View Full Code Here
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: builder.append("\">");
  10: int sqlTypeCode = metadata.getParameterType(param);
  11: builder.append("<type>");
  12:         ...
  13: int paramMode = metadata.getParameterMode(param);
  14: if (paramMode == ParameterMetaData.parameterModeOut){

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.ResultSet;
   4:         ...
   5: 
   6:         ParameterMetaData metaData = cs.getParameterMetaData();
   7:         int parmCount = metaData.getParameterCount();
   8:         ...
   9:             int mode = metaData.getParameterMode(parameterIndex);
  10:             if (mode == ParameterMetaData.parameterModeIn
  11:                     || mode == ParameterMetaData.parameterModeInOut) {
  12:         ...
  13:                 cs.registerOutParameter(
  14:                         parameterIndex, metaData.getParameterType(parameterIndex));

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                     != JDBC30Translation.PARAMETER_MODE_OUT )
  10:                                         ps.setNull(i+1, pmeta.getParameterType(i+1));
  11:                                 if (stmt.isOutputParam(i+1))
  12:         ...
  13:                                   DRDAStatement stmt,
  14:                                   ParameterMetaData pmeta)

View Full Code Here

getParameterTypeName

public String getParameterTypeName(int param)
            throws SQLException
Retrieves the designated parameter's database-specific type name.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
type the name used by the database. If the parameter type is a user-defined type, then a fully-qualified type name is returned.
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getParameterTypeName(int param)
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:                 int paramCount = paramMetaData.getParameterCount();
  12:         ...
  13:                     System.out.println("param SQL type code="+ sqlTypeCode);
  14:                     String paramTypeName = paramMetaData.getParameterTypeName(param);

View Full Code Here
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: builder.append("</type>");
  10: String paramTypeName = metadata.getParameterTypeName(param);
  11: builder.append("<typeName>");
  12:         ...
  13: int paramMode = metadata.getParameterMode(param);
  14: if (paramMode == ParameterMetaData.parameterModeOut){

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                   DRDAStatement stmt,
  10:                                   ParameterMetaData pmeta)
  11:                 throws DRDAProtocolException, SQLException
  12:         ...
  13:         String typeName = rtnOutput ? rsmeta.getColumnTypeName(jdbcElemNum) :
  14:                                         pmeta.getParameterTypeName(jdbcElemNum);

View Full Code Here

getPrecision

public int getPrecision(int param)
            throws SQLException
Retrieves the designated parameter's number of decimal digits.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
precision
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getPrecision(int param)
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: int paramMode = metadata.getParameterMode(param);
  10: if (paramMode == ParameterMetaData.parameterModeOut){
  11: builder.append("OUT");
  12:         ...
  13: builder.append("<precision>");
  14: int precision = metadata.getPrecision(param);

View Full Code Here
   1: import java.sql.DriverManager;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.Statement;
   4:         ...
   5:         
   6:         ParameterMetaData metaData = stmt.getParameterMetaData();
   7:         
   8:         ...
   9:         assertTrue("simple_field must have size 60", 
  10:             metaData.getPrecision(1) == 60);
  11:             
  12:         ...
  13:         assertTrue("two_byte_field must have size 60", 
  14:             metaData.getPrecision(2) == 60);

View Full Code Here
   1: 
   2:       int precision = metaData.getPrecision(field);
   3:       return LongValue.create(precision);
   4: 
   5:     } catch (Exception ex) {

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                   DRDAStatement stmt,
  10:                                   ParameterMetaData pmeta)
  11:                 throws DRDAProtocolException, SQLException
  12:         ...
  13:             {
  14:                 precision = rsmeta.getPrecision(i);

View Full Code Here

getScale

public int getScale(int param)
            throws SQLException
Retrieves the designated parameter's number of digits to right of the decimal point.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
scale
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of getScale(int param)
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: int paramMode = metadata.getParameterMode(param);
  10: if (paramMode == ParameterMetaData.parameterModeOut){
  11: builder.append("OUT");
  12:         ...
  13: builder.append("<scale>");
  14: int scale = metadata.getScale(param);

View Full Code Here
   1: 
   2:       int precision = metaData.getScale(field);
   3:       return LongValue.create(precision);
   4: 
   5:     } catch (Exception ex) {

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.ParameterMetaData;
   3: import java.sql.PreparedStatement;
   4:         ...
   5:         int codePoint;
   6:         ParameterMetaData pmeta = null;
   7: 
   8:         ...
   9:                                   DRDAStatement stmt,
  10:                                   ParameterMetaData pmeta)
  11:                 throws DRDAProtocolException, SQLException
  12:         ...
  13:                 precision = rsmeta.getPrecision(i);
  14:                 scale = rsmeta.getScale(i);

View Full Code Here

isNullable

public int isNullable(int param)
            throws SQLException
Retrieves whether null values are allowed in the designated parameter.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
the nullability status of the given parameter; one of ParameterMetaData.parameterNoNulls, ParameterMetaData.parameterNullable, or ParameterMetaData.parameterNullableUnknown
Throws:
SQLException - if a database access error occurs
Since:
1.4
Usages and Demos :

View More Examples of isNullable(int param)
   1:         PreparedStatement pstmt = null;
   2:         ParameterMetaData paramMetaData = null;
   3:         String query = "select id, str_col, num_col " +
   4:         ...
   5:             if (paramMetaData == null) {
   6:                 System.out.println("db vendor does NOT support ParameterMetaData");
   7:             }
   8:         ...
   9:             else {
  10:                 System.out.println("db vendor supports ParameterMetaData");
  11:                 int paramCount = paramMetaData.getParameterCount();
  12:         ...
  13: 
  14:                     int nullable = paramMetaData.isNullable(param);

View Full Code Here
   1: 
   2: public static String getParameterMetaDataAsXML(ParameterMetaData metadata)
   3: throws SQLException {
   4:         ...
   5: int paramCount = metadata.getParameterCount();
   6: builder.append("<parameterMetaData count=\"");
   7: builder.append(paramCount);
   8:         ...
   9: int paramMode = metadata.getParameterMode(param);
  10: if (paramMode == ParameterMetaData.parameterModeOut){
  11: builder.append("OUT");
  12:         ...
  13: builder.append("<nullable>");
  14: int nullable = metadata.isNullable(param);

View Full Code Here
   1: 
   2:       return metaData.isNullable(fieldNumber + 1) == ResultSetMetaData.columnNullable;
   3: 
   4:     } catch (Exception ex) {
   5:       log.log(Level.FINE, ex.toString(), ex);

View Full Code Here

isSigned

public boolean isSigned(int param)
            throws SQLException
Retrieves whether values for the designated parameter can be signed numbers.
Parameters:
param - the first parameter is 1, the second is 2, ...
Returns:
true if so; false otherwise
Throws:
SQLException - if a database access error occurs
Since:
1.4