procedure.setSchema( procedureRs.getString( "PROCEDURE_SCHEM" ) ); procedure.setCatalog( procedureRs.getString( "PROCEDURE_CAT" ) );
 	public ArrayList getAllProcedure( String cataLog, String schemaPattern,			String namePattern )	{ 		ArrayList procedureList = new ArrayList();		if ( metaData == null )		{			metaData = getMetaData( );		}		ResultSet procedureRs = null;		if ( cataLog != null && cataLog.trim( ).length( ) == 0 )		{			cataLog = null;		}		if ( metaData != null )		{			try			{				procedureRs = metaData.getProcedures( cataLog,						schemaPattern,						namePattern );				boolean isSame;				while ( procedureRs.next( ) )				{					isSame = false;					Procedure procedure = new Procedure( );					procedure.setProcedureName( procedureRs.getString( "PROCEDURE_NAME" ) );					procedure.setSchema( procedureRs.getString( "PROCEDURE_SCHEM" ) );					procedure.setCatalog( procedureRs.getString( "PROCEDURE_CAT" ) );					for ( int i = 0; i < procedureList.size( ); i++ )					{						if ( ( (Procedure) ( procedureList.get( i ) ) ).isEqualWith( procedure ) )							isSame = true;					}					if ( !isSame )						procedureList.add( procedure );				}			}			catch ( SQLException e )			{			}		}		return procedureList;	}