java.sql.ResultSet rs = metaData.getProcedureColumns( cataLog, schemaList.get( i ).toString( ), procedureName, null ); while ( rs.next( ) ) { ParameterDefn p = new ParameterDefn( ); p.setParamName( rs.getString( "COLUMN_NAME" ) ); p.setParamInOutType( rs.getInt( "COLUMN_TYPE" ) ); p.setParamType( rs.getInt( "DATA_TYPE" ) ); p.setParamTypeName( rs.getString( "TYPE_NAME" ) ); p.setPrecision( rs.getInt( "PRECISION" ) ); p.setScale( rs.getInt( "SCALE" ) ); p.setIsNullable( rs.getInt( "NULLABLE" ) ); if ( p.getParamInOutType( ) != 5 ) paramMetaDataList.add( p ); }
ParameterDefn p = new ParameterDefn( ); p.setParamName( rs.getString( "COLUMN_NAME" ) ); p.setParamInOutType( rs.getInt( "COLUMN_TYPE" ) ); p.setParamType( rs.getInt( "DATA_TYPE" ) ); p.setParamTypeName( rs.getString( "TYPE_NAME" ) ); p.setPrecision( rs.getInt( "PRECISION" ) ); p.setScale( rs.getInt( "SCALE" ) ); p.setIsNullable( rs.getInt( "NULLABLE" ) ); if ( p.getParamInOutType( ) != 5 ) paramMetaDataList.add( p );
	private java.util.List getCallableParamMetaData( )	{		java.util.List paramMetaDataList = new ArrayList( );		try		{			DatabaseMetaData metaData = conn.getMetaData( );			String cataLog = conn.getCatalog( );			ArrayList schemaList = createSchemaList( metaData.getSchemas( ) );			if ( schemaList != null && schemaList.size( ) > 0 )			{				for ( int i = 0; i < schemaList.size( ); i++ )				{					java.sql.ResultSet rs = metaData.getProcedureColumns( cataLog,							schemaList.get( i ).toString( ),							procedureName,							null );					while ( rs.next( ) )					{						ParameterDefn p = new ParameterDefn( );						p.setParamName( rs.getString( "COLUMN_NAME" ) );						p.setParamInOutType( rs.getInt( "COLUMN_TYPE" ) );						p.setParamType( rs.getInt( "DATA_TYPE" ) );						p.setParamTypeName( rs.getString( "TYPE_NAME" ) );						p.setPrecision( rs.getInt( "PRECISION" ) );						p.setScale( rs.getInt( "SCALE" ) );						p.setIsNullable( rs.getInt( "NULLABLE" ) );						if ( p.getParamInOutType( ) != 5 )							paramMetaDataList.add( p );					}				}			}		}		catch ( SQLException e )		{		}		return paramMetaDataList;	}